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

Source

View Text - Preformatted


SELECT MSIK.CONCATENATED_SEGMENTS ITEM_NAME, POL.ITEM_DESCRIPTION, POH.SEGMENT1 PO_NUMBER, POR.RELEASE_NUM, POL.LINE_NUM, POLL.SHIPMENT_NUM, POD.DISTRIBUTION_NUM, RSH.RECEIPT_NUM, RAE.PRIMARY_QUANTITY, POV.VENDOR_NAME, MP.ORGANIZATION_CODE, RAE.TRANSACTION_DATE, NVL(RT.TRANSACTION_TYPE, DECODE(RAE.EVENT_TYPE_ID, 14, 'PERIOD END ACCRUAL')) RCV_TXN_TYPE, RAE.RCV_TRANSACTION_ID TRANSACTION_ID, RAE.ORGANIZATION_ID, RAE.ACCOUNTING_EVENT_ID , RAE.PRIMARY_UNIT_OF_MEASURE FROM RCV_TRANSACTIONS RT, RCV_SHIPMENT_HEADERS RSH, PO_VENDORS POV, PO_HEADERS_ALL POH, PO_LINES_ALL POL, PO_LINE_LOCATIONS_ALL POLL, PO_DISTRIBUTIONS_ALL POD, PO_RELEASES_ALL POR, MTL_SYSTEM_ITEMS_KFV MSIK, RCV_ACCOUNTING_EVENTS RAE, MTL_PARAMETERS MP WHERE RAE.PO_HEADER_ID = POH.PO_HEADER_ID AND RAE.PO_LINE_ID = POL.PO_LINE_ID AND RAE.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND RAE.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID AND RAE.PO_RELEASE_ID = POR.PO_RELEASE_ID(+) AND POH.VENDOR_ID = POV.VENDOR_ID AND RT.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID(+) AND RAE.RCV_TRANSACTION_ID = RT.TRANSACTION_ID(+) AND MSIK.ORGANIZATION_ID(+) = RAE.ORGANIZATION_ID AND MSIK.INVENTORY_ITEM_ID(+) = RAE.INVENTORY_ITEM_ID AND MP.ORGANIZATION_ID = RAE.ORGANIZATION_ID

View Text - HTML Formatted

SELECT MSIK.CONCATENATED_SEGMENTS ITEM_NAME
, POL.ITEM_DESCRIPTION
, POH.SEGMENT1 PO_NUMBER
, POR.RELEASE_NUM
, POL.LINE_NUM
, POLL.SHIPMENT_NUM
, POD.DISTRIBUTION_NUM
, RSH.RECEIPT_NUM
, RAE.PRIMARY_QUANTITY
, POV.VENDOR_NAME
, MP.ORGANIZATION_CODE
, RAE.TRANSACTION_DATE
, NVL(RT.TRANSACTION_TYPE
, DECODE(RAE.EVENT_TYPE_ID
, 14
, 'PERIOD END ACCRUAL')) RCV_TXN_TYPE
, RAE.RCV_TRANSACTION_ID TRANSACTION_ID
, RAE.ORGANIZATION_ID
, RAE.ACCOUNTING_EVENT_ID
, RAE.PRIMARY_UNIT_OF_MEASURE
FROM RCV_TRANSACTIONS RT
, RCV_SHIPMENT_HEADERS RSH
, PO_VENDORS POV
, PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, PO_LINE_LOCATIONS_ALL POLL
, PO_DISTRIBUTIONS_ALL POD
, PO_RELEASES_ALL POR
, MTL_SYSTEM_ITEMS_KFV MSIK
, RCV_ACCOUNTING_EVENTS RAE
, MTL_PARAMETERS MP
WHERE RAE.PO_HEADER_ID = POH.PO_HEADER_ID
AND RAE.PO_LINE_ID = POL.PO_LINE_ID
AND RAE.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
AND RAE.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID
AND RAE.PO_RELEASE_ID = POR.PO_RELEASE_ID(+)
AND POH.VENDOR_ID = POV.VENDOR_ID
AND RT.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID(+)
AND RAE.RCV_TRANSACTION_ID = RT.TRANSACTION_ID(+)
AND MSIK.ORGANIZATION_ID(+) = RAE.ORGANIZATION_ID
AND MSIK.INVENTORY_ITEM_ID(+) = RAE.INVENTORY_ITEM_ID
AND MP.ORGANIZATION_ID = RAE.ORGANIZATION_ID