VIEW: APPS.PO_RCV_SUPPLY_VIEW

Source

View Text - Preformatted

SELECT MS.ITEM_ID , MS.TO_ORGANIZATION_ID , MS.PO_HEADER_ID , PH.VENDOR_ID , PH.VENDOR_SITE_ID , RT.TRANSACTION_DATE , DECODE(MS.PO_RELEASE_ID, NULL, PH.SEGMENT1, PH.SEGMENT1||'('|| TO_CHAR(PR.RELEASE_NUM)||')') , MS.QUANTITY , MUOM.UOM_CODE , MS.TO_ORG_PRIMARY_QUANTITY , MS.TO_ORG_PRIMARY_UOM , PLL.PRICE_OVERRIDE , PL.LINE_NUM , MS.DESTINATION_TYPE_CODE , RSH.RECEIPT_NUM , DECODE(MS.PO_RELEASE_ID, NULL, PH.REVISION_NUM,PR.REVISION_NUM) , MS.MRP_EXPECTED_DELIVERY_DATE , MS.MRP_PRIMARY_QUANTITY , MS.mrp_primary_uom , MS.mrp_destination_type_code , MS.mrp_to_organization_id , MS.mrp_to_subinventory , MS.po_line_id , MS.ITEM_REVISION ,ms.EXPECTED_DELIVERY_DATE ,ms.TO_ORG_PRIMARY_QUANTITY ,ms.TO_ORGANIZATION_ID ,pd.project_id ,pd.task_id ,pd.end_item_unit_number ,ms.to_subinventory ,ms.from_organization_id FROM MTL_UNITS_OF_MEASURE MUOM, MTL_SUPPLY MS, PO_HEADERS_ALL PH, PO_LINES_ALL PL, PO_LINE_LOCATIONS_ALL PLL, PO_DISTRIBUTIONS_ALL PD, PO_RELEASES_ALL PR, RCV_SHIPMENT_HEADERS RSH, RCV_TRANSACTIONS RT WHERE MS.SUPPLY_TYPE_CODE = 'RECEIVING' AND PH.PO_HEADER_ID = MS.PO_HEADER_ID AND PR.PO_RELEASE_ID(+) = MS.PO_RELEASE_ID AND PL.PO_LINE_ID = MS.PO_LINE_ID AND PLL.LINE_LOCATION_ID = MS.PO_LINE_LOCATION_ID AND PD.PO_DISTRIBUTION_ID = MS.PO_DISTRIBUTION_ID AND RSH.SHIPMENT_HEADER_ID = MS.SHIPMENT_HEADER_ID AND RT.TRANSACTION_ID = MS.RCV_TRANSACTION_ID AND MUOM.UNIT_OF_MEASURE = MS.UNIT_OF_MEASURE

View Text - HTML Formatted

SELECT MS.ITEM_ID
, MS.TO_ORGANIZATION_ID
, MS.PO_HEADER_ID
, PH.VENDOR_ID
, PH.VENDOR_SITE_ID
, RT.TRANSACTION_DATE
, DECODE(MS.PO_RELEASE_ID
, NULL
, PH.SEGMENT1
, PH.SEGMENT1||'('|| TO_CHAR(PR.RELEASE_NUM)||')')
, MS.QUANTITY
, MUOM.UOM_CODE
, MS.TO_ORG_PRIMARY_QUANTITY
, MS.TO_ORG_PRIMARY_UOM
, PLL.PRICE_OVERRIDE
, PL.LINE_NUM
, MS.DESTINATION_TYPE_CODE
, RSH.RECEIPT_NUM
, DECODE(MS.PO_RELEASE_ID
, NULL
, PH.REVISION_NUM
, PR.REVISION_NUM)
, MS.MRP_EXPECTED_DELIVERY_DATE
, MS.MRP_PRIMARY_QUANTITY
, MS.MRP_PRIMARY_UOM
, MS.MRP_DESTINATION_TYPE_CODE
, MS.MRP_TO_ORGANIZATION_ID
, MS.MRP_TO_SUBINVENTORY
, MS.PO_LINE_ID
, MS.ITEM_REVISION
, MS.EXPECTED_DELIVERY_DATE
, MS.TO_ORG_PRIMARY_QUANTITY
, MS.TO_ORGANIZATION_ID
, PD.PROJECT_ID
, PD.TASK_ID
, PD.END_ITEM_UNIT_NUMBER
, MS.TO_SUBINVENTORY
, MS.FROM_ORGANIZATION_ID
FROM MTL_UNITS_OF_MEASURE MUOM
, MTL_SUPPLY MS
, PO_HEADERS_ALL PH
, PO_LINES_ALL PL
, PO_LINE_LOCATIONS_ALL PLL
, PO_DISTRIBUTIONS_ALL PD
, PO_RELEASES_ALL PR
, RCV_SHIPMENT_HEADERS RSH
, RCV_TRANSACTIONS RT
WHERE MS.SUPPLY_TYPE_CODE = 'RECEIVING'
AND PH.PO_HEADER_ID = MS.PO_HEADER_ID
AND PR.PO_RELEASE_ID(+) = MS.PO_RELEASE_ID
AND PL.PO_LINE_ID = MS.PO_LINE_ID
AND PLL.LINE_LOCATION_ID = MS.PO_LINE_LOCATION_ID
AND PD.PO_DISTRIBUTION_ID = MS.PO_DISTRIBUTION_ID
AND RSH.SHIPMENT_HEADER_ID = MS.SHIPMENT_HEADER_ID
AND RT.TRANSACTION_ID = MS.RCV_TRANSACTION_ID
AND MUOM.UNIT_OF_MEASURE = MS.UNIT_OF_MEASURE