SECONDARY_INVENTORY VARCHAR2 10 Secondary inventory code (not currently used) SOURCE_TYPE NUMBER Source type of the sourcing. Make, Buy, Transfer. ALLOCATION_PERCENT NUMBER Percent of supply allocated to this source RANK NUMBER This value indicates the Rank of the record. VENDOR_NAME VARCHAR2 360...
INCLUDE_VENDOR_REQS NUMBER Identifier to indicate if vendor requisitions to be included. INCLUDE_INTERNAL_ORDERS NUMBER Yes/No flag for ATP computation to include demand from internal orders INCLUDE_FLOW_SCHEDULE_DEMAND NUMBER Yes/No flag for ATP computation to include demand from flow schedule INCLUD...
VENDOR_LOT_NUMBER VARCHAR2 80 The lot number at the Vendors location SERIAL_NUMBER VARCHAR2 80 The serial number of the item GRADE_CODE VARCHAR2 150 Grade of the Lot for a grade controlled Item TRANSACTION_QTY NUMBER Quantity in the transaction unit of measure as stamped in the header transa...
SECONDARY_INVENTORY VARCHAR2 10 Secondary inventory code (not currently used) SOURCE_TYPE NUMBER Source type of the sourcing. Make, Buy, Transfer. ALLOCATION_PERCENT NUMBER Percent of supply allocated to this source RANK NUMBER This value indicates the Rank of the record. VENDOR_NAME VARCHAR2 360...
VENDOR_NAME VARCHAR2 360 Name of the supplier attached to PO/PR. VENDOR_SITE_CODE VARCHAR2 240 Name of the supplier site attached to PO/PR. SUPPLIER_SITE_CODE VARCHAR2 240 This value indicates the Supplier site code collected from source system. MESSAGE_ID NUMBER This is a foreign key ref...
AND pad.DOCUMENT_TYPE_CODE = 'BLANKET' ) ITEM_PRICE, PASL.PRIMARY_VENDOR_ITEM, greatest(pasl.last_update_date,paa.last_update_date) last_update_date FROM PO_APPROVED_SUPPLIER_LIST PASL, PO_ASL_ATTRIBUTES PAA, MSC_AP_SUPPLIERS_V sup, MSC_AP_SUPPLIER_SITES_V supsite WHERE PASL.USING_ORGA...
TP_SITE_CODE VARCHAR2 30 Vendor site code for Customer Sites SR_TP_ID NUMBER 18 Customer id in the source side LOCATION VARCHAR2 60 location LOCATION_ID NUMBER 18 location id PARTNER_TYPE NUMBER Yes 2-Customer DELETED_FLAG NUMBER Deleted_flag LONGITUDE NUMBER 10 Longitude LATITUDE NUMBER 10 ...
VENDOR_SITE_CODE VARCHAR2 240 Name of the supplier site attached to an Item in ASL. FROM_DATE DATE Identifies the First date of valid capacity TO_DATE DATE This value indicates the Last date of valid capacity. CAPACITY NUMBER The quantity that the supplier is capable of supplying. STATUS ...
LOT_CONTROL_CODE NUMBER Yes Flag indicating if lots_expiration is used or not Active SHRINKAGE_RATE NUMBER Percentage of shinkage for this item Active FIXED_DAYS_SUPPLY NUMBER Period of the supply days (in days) Active FIXED_ORDER_QUANTITY NUMBER Fixed order quantity for Vendor managed inventory...
) subinventory_code,ph.vendor_id supplier_id,supHZP.partner_name supplier_name,ph.vendor_site_id supplier_site_id,pvsa.vendor_site_code supplier_site_code,ph.buyer_managed_transport_flag,sup.destination_type_code,DECODE(UPPER(NVL(sup.DESTINATION_TYPE_CODE,'-1')),'DROP SHIP','1','...