VIEW: APPS.POR_RCV_CONF_ITEMS_V

Source

View Text - Preformatted

SELECT RSH.RECEIPT_NUM, RT.TRANSACTION_DATE, PORH.SEGMENT1, PORL.ITEM_DESCRIPTION, MUOM.UNIT_OF_MEASURE_TL, RT.QUANTITY, RSH.WAYBILL_AIRBILL_NUM, RSL.PACKING_SLIP, RSL.COMMENTS, RSH.COMMENTS, HOU.NAME SOURCE, HOU1.NAME DESTINATION_ORGANIZATION, RT.GROUP_ID FROM PO_REQUISITION_LINES PORL, PO_REQUISITION_HEADERS PORH, RCV_SHIPMENT_HEADERS RSH, RCV_SHIPMENT_LINES RSL, RCV_TRANSACTIONS RT, HR_ALL_ORGANIZATION_UNITS HOU, HR_ALL_ORGANIZATION_UNITS HOU1, MTL_UNITS_OF_MEASURE MUOM WHERE RT.TRANSACTION_TYPE = 'DELIVER' AND RT.SOURCE_DOCUMENT_CODE = 'REQ' AND RT.UNIT_OF_MEASURE = MUOM.UNIT_OF_MEASURE (+) AND RSL.SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND PORL.REQUISITION_LINE_ID = RSL.REQUISITION_LINE_ID AND PORH.REQUISITION_HEADER_ID = PORL.REQUISITION_HEADER_ID AND HOU.ORGANIZATION_ID = PORL.SOURCE_ORGANIZATION_ID AND HOU1.ORGANIZATION_ID = RSL.TO_ORGANIZATION_ID UNION ALL SELECT RSH.RECEIPT_NUM, RT.TRANSACTION_DATE, DECODE(POD.REQ_DISTRIBUTION_ID, NULL, NULL, (SELECT PORH.SEGMENT1 FROM PO_REQUISITION_LINES PORL, PO_REQUISITION_HEADERS PORH, PO_REQ_DISTRIBUTIONS PORD WHERE PORD.DISTRIBUTION_ID = POD.REQ_DISTRIBUTION_ID AND PORL.REQUISITION_LINE_ID = PORD.REQUISITION_LINE_ID AND PORH.REQUISITION_HEADER_ID = PORL.REQUISITION_HEADER_ID)), SUBSTR( POL.ITEM_DESCRIPTION, 1, 240) ITEM_DESCRIPTION, decode( POL.MATCHING_BASIS, 'AMOUNT', RT.CURRENCY_CODE, MUOM.UNIT_OF_MEASURE_TL), decode( POL.MATCHING_BASIS, 'AMOUNT', RT.AMOUNT, RT.QUANTITY), RSH.WAYBILL_AIRBILL_NUM, RSL.PACKING_SLIP, RSL.COMMENTS, RSH.COMMENTS, POV.VENDOR_NAME VENDOR, HOU.NAME DESTINATION_ORGANIZATION, RT.GROUP_ID FROM PO_DISTRIBUTIONS_TRX_V POD, PO_LINES_TRX_V POL, PO_LINE_LOCATIONS_TRX_V POLL, RCV_SHIPMENT_HEADERS RSH, RCV_SHIPMENT_LINES RSL, RCV_TRANSACTIONS RT, PO_VENDORS POV, MTL_UNITS_OF_MEASURE MUOM, HR_ALL_ORGANIZATION_UNITS_TL HOU WHERE RT.TRANSACTION_TYPE = 'DELIVER' AND RT.SOURCE_DOCUMENT_CODE = 'PO' AND RT.UNIT_OF_MEASURE = MUOM.UNIT_OF_MEASURE (+) AND RSL.SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND POV.VENDOR_ID = RSH.VENDOR_ID AND HOU.ORGANIZATION_ID = RSL.TO_ORGANIZATION_ID AND HOU.LANGUAGE = USERENV('LANG') AND POD.PO_DISTRIBUTION_ID = RT.PO_DISTRIBUTION_ID AND POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND POLL.PAYMENT_TYPE IS NULL AND POD.PO_LINE_ID = POL.PO_LINE_ID

View Text - HTML Formatted

SELECT RSH.RECEIPT_NUM
, RT.TRANSACTION_DATE
, PORH.SEGMENT1
, PORL.ITEM_DESCRIPTION
, MUOM.UNIT_OF_MEASURE_TL
, RT.QUANTITY
, RSH.WAYBILL_AIRBILL_NUM
, RSL.PACKING_SLIP
, RSL.COMMENTS
, RSH.COMMENTS
, HOU.NAME SOURCE
, HOU1.NAME DESTINATION_ORGANIZATION
, RT.GROUP_ID
FROM PO_REQUISITION_LINES PORL
, PO_REQUISITION_HEADERS PORH
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, RCV_TRANSACTIONS RT
, HR_ALL_ORGANIZATION_UNITS HOU
, HR_ALL_ORGANIZATION_UNITS HOU1
, MTL_UNITS_OF_MEASURE MUOM
WHERE RT.TRANSACTION_TYPE = 'DELIVER'
AND RT.SOURCE_DOCUMENT_CODE = 'REQ'
AND RT.UNIT_OF_MEASURE = MUOM.UNIT_OF_MEASURE (+)
AND RSL.SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID
AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
AND PORL.REQUISITION_LINE_ID = RSL.REQUISITION_LINE_ID
AND PORH.REQUISITION_HEADER_ID = PORL.REQUISITION_HEADER_ID
AND HOU.ORGANIZATION_ID = PORL.SOURCE_ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = RSL.TO_ORGANIZATION_ID UNION ALL SELECT RSH.RECEIPT_NUM
, RT.TRANSACTION_DATE
, DECODE(POD.REQ_DISTRIBUTION_ID
, NULL
, NULL
, (SELECT PORH.SEGMENT1
FROM PO_REQUISITION_LINES PORL
, PO_REQUISITION_HEADERS PORH
, PO_REQ_DISTRIBUTIONS PORD
WHERE PORD.DISTRIBUTION_ID = POD.REQ_DISTRIBUTION_ID
AND PORL.REQUISITION_LINE_ID = PORD.REQUISITION_LINE_ID
AND PORH.REQUISITION_HEADER_ID = PORL.REQUISITION_HEADER_ID))
, SUBSTR( POL.ITEM_DESCRIPTION
, 1
, 240) ITEM_DESCRIPTION
, DECODE( POL.MATCHING_BASIS
, 'AMOUNT'
, RT.CURRENCY_CODE
, MUOM.UNIT_OF_MEASURE_TL)
, DECODE( POL.MATCHING_BASIS
, 'AMOUNT'
, RT.AMOUNT
, RT.QUANTITY)
, RSH.WAYBILL_AIRBILL_NUM
, RSL.PACKING_SLIP
, RSL.COMMENTS
, RSH.COMMENTS
, POV.VENDOR_NAME VENDOR
, HOU.NAME DESTINATION_ORGANIZATION
, RT.GROUP_ID
FROM PO_DISTRIBUTIONS_TRX_V POD
, PO_LINES_TRX_V POL
, PO_LINE_LOCATIONS_TRX_V POLL
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, RCV_TRANSACTIONS RT
, PO_VENDORS POV
, MTL_UNITS_OF_MEASURE MUOM
, HR_ALL_ORGANIZATION_UNITS_TL HOU
WHERE RT.TRANSACTION_TYPE = 'DELIVER'
AND RT.SOURCE_DOCUMENT_CODE = 'PO'
AND RT.UNIT_OF_MEASURE = MUOM.UNIT_OF_MEASURE (+)
AND RSL.SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID
AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
AND POV.VENDOR_ID = RSH.VENDOR_ID
AND HOU.ORGANIZATION_ID = RSL.TO_ORGANIZATION_ID
AND HOU.LANGUAGE = USERENV('LANG')
AND POD.PO_DISTRIBUTION_ID = RT.PO_DISTRIBUTION_ID
AND POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
AND POLL.PAYMENT_TYPE IS NULL
AND POD.PO_LINE_ID = POL.PO_LINE_ID