eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.RCV_ENTER_RECEIPTS_INVENTORY_V

Source

View Text - Preformatted


SELECT 'N', 'INTERNAL', RSL.SOURCE_DOCUMENT_CODE, RSL.SOURCE_DOCUMENT_CODE, RSH.RECEIPT_SOURCE_CODE, TO_NUMBER(NULL), NULL, TO_NUMBER( NULL), TO_NUMBER( NULL), TO_NUMBER( NULL), TO_NUMBER( NULL), TO_NUMBER( NULL), TO_NUMBER( NULL), TO_NUMBER(NULL), NULL, TO_NUMBER(NULL), TO_NUMBER(NULL), RSL.REQ_DISTRIBUTION_ID, RSL.SHIPMENT_HEADER_ID, RSH.SHIPMENT_NUM, RSL.SHIPMENT_LINE_ID, RSL.LINE_NUM, RSL.FROM_ORGANIZATION_ID, RSL.TO_ORGANIZATION_ID, RSL.SHIPMENT_LINE_ID, OOD.ORGANIZATION_NAME, TO_NUMBER(NULL), 'N', RSL.ITEM_ID, RSL.UNIT_OF_MEASURE, MUM.UOM_CLASS, NVL(MSI.ALLOWED_UNITS_LOOKUP_CODE,2), NVL(MSI.LOCATION_CONTROL_CODE,1), DECODE(MSI.RESTRICT_LOCATORS_CODE,1,'Y','N'), DECODE(MSI.RESTRICT_SUBINVENTORIES_CODE,1,'Y','N'), NVL(MSI.SHELF_LIFE_CODE,1), NVL(MSI.SHELF_LIFE_DAYS,0), MSI.SERIAL_NUMBER_CONTROL_CODE, MSI.LOT_CONTROL_CODE, DECODE(MSI.REVISION_QTY_CONTROL_CODE,1,'N',2,'Y','N'), DECODE(MSI1.REVISION_QTY_CONTROL_CODE,1,'N',2,'Y','N'), NULL ITEM_NUMBER, RSL.ITEM_REVISION, RSL.ITEM_DESCRIPTION, RSL.CATEGORY_ID, NULL, NULL, RSL.VENDOR_ITEM_NUM, RSH.SHIP_TO_LOCATION_ID, HL.LOCATION_CODE, RSH.PACKING_SLIP, RSL.ROUTING_HEADER_ID, RCVRH.ROUTING_NAME, TO_DATE(NULL), RSH.EXPECTED_RECEIPT_DATE, RSL.QUANTITY_SHIPPED, RSL.UNIT_OF_MEASURE, RSH.USSGL_TRANSACTION_CODE, RSH.GOVERNMENT_CONTEXT, NULL, NULL, NULL, TO_NUMBER(NULL), NULL, NULL, TO_DATE(NULL), TO_NUMBER(NULL), NULL, RSL.DESTINATION_TYPE_CODE, RSL.DELIVER_TO_PERSON_ID, RSL.DELIVER_TO_LOCATION_ID, RSL.TO_SUBINVENTORY, RSL.ATTRIBUTE_CATEGORY, RSL.ATTRIBUTE1, RSL.ATTRIBUTE2, RSL.ATTRIBUTE3, RSL.ATTRIBUTE4, RSL.ATTRIBUTE5, RSL.ATTRIBUTE6, RSL.ATTRIBUTE7, RSL.ATTRIBUTE8, RSL.ATTRIBUTE9, RSL.ATTRIBUTE10, RSL.ATTRIBUTE11, RSL.ATTRIBUTE12, RSL.ATTRIBUTE13, RSL.ATTRIBUTE14, RSL.ATTRIBUTE15, 'OPEN', null, rsh.bill_of_lading, rsh.shipped_date, rsh.freight_carrier_code, rsh.waybill_airbill_num, rsh.freight_bill_number, rsl.vendor_lot_num, rsl.container_num, rsl.truck_num, rsl.bar_code_label, null, 'P', null , TO_NUMBER(NULL) , TO_NUMBER(NULL) , TO_NUMBER(NULL) , TO_NUMBER(NULL) , TO_NUMBER(NULL) , TO_NUMBER(NULL) , null ,NULL ,RSL.SECONDARY_QUANTITY_SHIPPED SECONDARY_ORDERED_QTY ,RSL.SECONDARY_UNIT_OF_MEASURE SECONDARY_ORDERED_UOM ,RSL.QC_GRADE QC_GRADE, TO_NUMBER(NULL) ,DECODE(MSI.TRACKING_QUANTITY_IND,'PS',MSI.SECONDARY_DEFAULT_IND,NULL) ,to_number(null) ,to_number(null) , RSL.LCM_SHIPMENT_LINE_ID , RSL.UNIT_LANDED_COST , NULL FROM RCV_SHIPMENT_HEADERS RSH, RCV_SHIPMENT_LINES RSL, MTL_SUPPLY MS, RCV_ROUTING_HEADERS RCVRH, HR_LOCATIONS_ALL_TL HL, MTL_SYSTEM_ITEMS MSI, MTL_SYSTEM_ITEMS MSI1, MTL_UNITS_OF_MEASURE MUM, ORG_ORGANIZATION_DEFINITIONS OOD WHERE RSH.RECEIPT_SOURCE_CODE = 'INVENTORY' AND MS.SUPPLY_TYPE_CODE = 'SHIPMENT' AND MS.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND RSH.SHIP_TO_LOCATION_ID = HL.LOCATION_ID (+) AND HL.LANGUAGE(+) = USERENV('LANG') AND RSL.ROUTING_HEADER_ID = RCVRH.ROUTING_HEADER_ID(+) AND MUM.UNIT_OF_MEASURE (+) = RSL.UNIT_OF_MEASURE AND MSI.ORGANIZATION_ID (+) = RSL.TO_ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID (+) = RSL.ITEM_ID AND MSI1.ORGANIZATION_ID (+) = RSL.FROM_ORGANIZATION_ID AND MSI1.INVENTORY_ITEM_ID (+) = RSL.ITEM_ID AND OOD.ORGANIZATION_ID = RSL.FROM_ORGANIZATION_ID AND MS.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID

View Text - HTML Formatted

SELECT 'N'
, 'INTERNAL'
, RSL.SOURCE_DOCUMENT_CODE
, RSL.SOURCE_DOCUMENT_CODE
, RSH.RECEIPT_SOURCE_CODE
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER( NULL)
, TO_NUMBER( NULL)
, TO_NUMBER( NULL)
, TO_NUMBER( NULL)
, TO_NUMBER( NULL)
, TO_NUMBER( NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, RSL.REQ_DISTRIBUTION_ID
, RSL.SHIPMENT_HEADER_ID
, RSH.SHIPMENT_NUM
, RSL.SHIPMENT_LINE_ID
, RSL.LINE_NUM
, RSL.FROM_ORGANIZATION_ID
, RSL.TO_ORGANIZATION_ID
, RSL.SHIPMENT_LINE_ID
, OOD.ORGANIZATION_NAME
, TO_NUMBER(NULL)
, 'N'
, RSL.ITEM_ID
, RSL.UNIT_OF_MEASURE
, MUM.UOM_CLASS
, NVL(MSI.ALLOWED_UNITS_LOOKUP_CODE
, 2)
, NVL(MSI.LOCATION_CONTROL_CODE
, 1)
, DECODE(MSI.RESTRICT_LOCATORS_CODE
, 1
, 'Y'
, 'N')
, DECODE(MSI.RESTRICT_SUBINVENTORIES_CODE
, 1
, 'Y'
, 'N')
, NVL(MSI.SHELF_LIFE_CODE
, 1)
, NVL(MSI.SHELF_LIFE_DAYS
, 0)
, MSI.SERIAL_NUMBER_CONTROL_CODE
, MSI.LOT_CONTROL_CODE
, DECODE(MSI.REVISION_QTY_CONTROL_CODE
, 1
, 'N'
, 2
, 'Y'
, 'N')
, DECODE(MSI1.REVISION_QTY_CONTROL_CODE
, 1
, 'N'
, 2
, 'Y'
, 'N')
, NULL ITEM_NUMBER
, RSL.ITEM_REVISION
, RSL.ITEM_DESCRIPTION
, RSL.CATEGORY_ID
, NULL
, NULL
, RSL.VENDOR_ITEM_NUM
, RSH.SHIP_TO_LOCATION_ID
, HL.LOCATION_CODE
, RSH.PACKING_SLIP
, RSL.ROUTING_HEADER_ID
, RCVRH.ROUTING_NAME
, TO_DATE(NULL)
, RSH.EXPECTED_RECEIPT_DATE
, RSL.QUANTITY_SHIPPED
, RSL.UNIT_OF_MEASURE
, RSH.USSGL_TRANSACTION_CODE
, RSH.GOVERNMENT_CONTEXT
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, NULL
, RSL.DESTINATION_TYPE_CODE
, RSL.DELIVER_TO_PERSON_ID
, RSL.DELIVER_TO_LOCATION_ID
, RSL.TO_SUBINVENTORY
, RSL.ATTRIBUTE_CATEGORY
, RSL.ATTRIBUTE1
, RSL.ATTRIBUTE2
, RSL.ATTRIBUTE3
, RSL.ATTRIBUTE4
, RSL.ATTRIBUTE5
, RSL.ATTRIBUTE6
, RSL.ATTRIBUTE7
, RSL.ATTRIBUTE8
, RSL.ATTRIBUTE9
, RSL.ATTRIBUTE10
, RSL.ATTRIBUTE11
, RSL.ATTRIBUTE12
, RSL.ATTRIBUTE13
, RSL.ATTRIBUTE14
, RSL.ATTRIBUTE15
, 'OPEN'
, NULL
, RSH.BILL_OF_LADING
, RSH.SHIPPED_DATE
, RSH.FREIGHT_CARRIER_CODE
, RSH.WAYBILL_AIRBILL_NUM
, RSH.FREIGHT_BILL_NUMBER
, RSL.VENDOR_LOT_NUM
, RSL.CONTAINER_NUM
, RSL.TRUCK_NUM
, RSL.BAR_CODE_LABEL
, NULL
, 'P'
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, RSL.SECONDARY_QUANTITY_SHIPPED SECONDARY_ORDERED_QTY
, RSL.SECONDARY_UNIT_OF_MEASURE SECONDARY_ORDERED_UOM
, RSL.QC_GRADE QC_GRADE
, TO_NUMBER(NULL)
, DECODE(MSI.TRACKING_QUANTITY_IND
, 'PS'
, MSI.SECONDARY_DEFAULT_IND
, NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, RSL.LCM_SHIPMENT_LINE_ID
, RSL.UNIT_LANDED_COST
, NULL
FROM RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, MTL_SUPPLY MS
, RCV_ROUTING_HEADERS RCVRH
, HR_LOCATIONS_ALL_TL HL
, MTL_SYSTEM_ITEMS MSI
, MTL_SYSTEM_ITEMS MSI1
, MTL_UNITS_OF_MEASURE MUM
, ORG_ORGANIZATION_DEFINITIONS OOD
WHERE RSH.RECEIPT_SOURCE_CODE = 'INVENTORY'
AND MS.SUPPLY_TYPE_CODE = 'SHIPMENT'
AND MS.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
AND RSH.SHIP_TO_LOCATION_ID = HL.LOCATION_ID (+)
AND HL.LANGUAGE(+) = USERENV('LANG')
AND RSL.ROUTING_HEADER_ID = RCVRH.ROUTING_HEADER_ID(+)
AND MUM.UNIT_OF_MEASURE (+) = RSL.UNIT_OF_MEASURE
AND MSI.ORGANIZATION_ID (+) = RSL.TO_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID (+) = RSL.ITEM_ID
AND MSI1.ORGANIZATION_ID (+) = RSL.FROM_ORGANIZATION_ID
AND MSI1.INVENTORY_ITEM_ID (+) = RSL.ITEM_ID
AND OOD.ORGANIZATION_ID = RSL.FROM_ORGANIZATION_ID
AND MS.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID