View: GML_LN_RCV_ERV

Product:	GML - Process Manufacturing Logistics
Description:	View of Line level information of a receipt for ERES
Implementation/DBA Data:	APPS.GML_LN_RCV_ERV

View Text

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)

Columns