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.GML_LN_RCV_ERV

Source

View Text - Preformatted


SELECT R.GROUP_ID GROUP_ID, R.INTERFACE_TRANSACTION_ID INTERFACE_TRANSACTION_ID, SH.RECEIPT_NUM RECEIPT_NUM, NULL LINE_NUM, MSI.SEGMENT1 ITEM_NO, NVL(R.ITEM_DESCRIPTION,MSI.DESCRIPTION) ITEM_DESCRIPTION, R.TRANSACTION_DATE TRANSACTION_DATE, PV.VENDOR_NAME VENDOR_NAME, PV.VENDOR_ID VENDOR_ID, PV.SEGMENT1 VENDOR_NO, R.SUBINVENTORY SUBINVENTORY, MIL.DESCRIPTION LOCATOR_DESC, R.LOCATOR_ID LOCATOR_ID, R.QUANTITY QUANTITY, R.UNIT_OF_MEASURE UOM, R.SECONDARY_QUANTITY SECONDARY_QUANTITY, R.SECONDARY_UNIT_OF_MEASURE SECONDARY_UOM, MP.ORGANIZATION_CODE ORGANIZATION_CODE, H.NAME ORGANIZATION_NAME, R.VENDOR_LOT_NUM VENDOR_LOT_NUM FROM RCV_TRANSACTIONS_INTERFACE R, RCV_SHIPMENT_HEADERS SH, MTL_SYSTEM_ITEMS MSI, PO_VENDORS PV, MTL_ITEM_LOCATIONS MIL, HR_ALL_ORGANIZATION_UNITS H, MTL_PARAMETERS MP WHERE R.SHIPMENT_HEADER_ID = SH.SHIPMENT_HEADER_ID AND R.VENDOR_ID = PV.VENDOR_ID(+) AND R.LOCATOR_ID = MIL.INVENTORY_LOCATION_ID(+) AND R.ITEM_ID = MSI.INVENTORY_ITEM_ID AND R.TO_ORGANIZATION_ID = MSI.ORGANIZATION_ID AND R.TO_ORGANIZATION_ID = H.ORGANIZATION_ID AND H.ORGANIZATION_ID = MP.ORGANIZATION_ID AND R.DESTINATION_TYPE_CODE = 'INVENTORY' AND MSI.LOT_CONTROL_CODE = 2 AND EXISTS (SELECT 1 FROM GML_LOT_ERES_TEMP GT WHERE GT.INTERFACE_TRANSACTION_ID = R.INTERFACE_TRANSACTION_ID)

View Text - HTML Formatted

SELECT R.GROUP_ID GROUP_ID
, R.INTERFACE_TRANSACTION_ID INTERFACE_TRANSACTION_ID
, SH.RECEIPT_NUM RECEIPT_NUM
, NULL LINE_NUM
, MSI.SEGMENT1 ITEM_NO
, NVL(R.ITEM_DESCRIPTION
, MSI.DESCRIPTION) ITEM_DESCRIPTION
, R.TRANSACTION_DATE TRANSACTION_DATE
, PV.VENDOR_NAME VENDOR_NAME
, PV.VENDOR_ID VENDOR_ID
, PV.SEGMENT1 VENDOR_NO
, R.SUBINVENTORY SUBINVENTORY
, MIL.DESCRIPTION LOCATOR_DESC
, R.LOCATOR_ID LOCATOR_ID
, R.QUANTITY QUANTITY
, R.UNIT_OF_MEASURE UOM
, R.SECONDARY_QUANTITY SECONDARY_QUANTITY
, R.SECONDARY_UNIT_OF_MEASURE SECONDARY_UOM
, MP.ORGANIZATION_CODE ORGANIZATION_CODE
, H.NAME ORGANIZATION_NAME
, R.VENDOR_LOT_NUM VENDOR_LOT_NUM
FROM RCV_TRANSACTIONS_INTERFACE R
, RCV_SHIPMENT_HEADERS SH
, MTL_SYSTEM_ITEMS MSI
, PO_VENDORS PV
, MTL_ITEM_LOCATIONS MIL
, HR_ALL_ORGANIZATION_UNITS H
, MTL_PARAMETERS MP
WHERE R.SHIPMENT_HEADER_ID = SH.SHIPMENT_HEADER_ID
AND R.VENDOR_ID = PV.VENDOR_ID(+)
AND R.LOCATOR_ID = MIL.INVENTORY_LOCATION_ID(+)
AND R.ITEM_ID = MSI.INVENTORY_ITEM_ID
AND R.TO_ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND R.TO_ORGANIZATION_ID = H.ORGANIZATION_ID
AND H.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND R.DESTINATION_TYPE_CODE = 'INVENTORY'
AND MSI.LOT_CONTROL_CODE = 2
AND EXISTS (SELECT 1
FROM GML_LOT_ERES_TEMP GT
WHERE GT.INTERFACE_TRANSACTION_ID = R.INTERFACE_TRANSACTION_ID)