VIEW: APPS.PO_PO_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 ,ms.need_by_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 ,decode(ms.po_release_id, null, ph.printed_date,pr.printed_date) ,decode(ms.po_release_id, null, ph.revision_num,pr.revision_num) ,decode(decode(sign(decode(pr.po_release_id, Null, nvl(ph.firm_date,sysdate+1), nvl(pr.firm_date,sysdate+1))-sysdate),1,decode(pr.po_release_id, Null,nvl(ph.firm_status_lookup_code,'N'), nvl(pr.firm_status_lookup_code,'N')),'Y'),'N', decode(sign(nvl(pll.firm_date,sysdate+1)-sysdate),1, nvl(pll.firm_status_lookup_code,'N'),'Y'),'Y') ,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.po_line_location_id ,ms.po_distribution_id ,pl.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 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 where (ms.supply_type_code = 'PO' OR ms.supply_type_code = 'ASN') 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 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
, MS.NEED_BY_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
, DECODE(MS.PO_RELEASE_ID
, NULL
, PH.PRINTED_DATE
, PR.PRINTED_DATE)
, DECODE(MS.PO_RELEASE_ID
, NULL
, PH.REVISION_NUM
, PR.REVISION_NUM)
, DECODE(DECODE(SIGN(DECODE(PR.PO_RELEASE_ID
, NULL
, NVL(PH.FIRM_DATE
, SYSDATE+1)
, NVL(PR.FIRM_DATE
, SYSDATE+1))-SYSDATE)
, 1
, DECODE(PR.PO_RELEASE_ID
, NULL
, NVL(PH.FIRM_STATUS_LOOKUP_CODE
, 'N')
, NVL(PR.FIRM_STATUS_LOOKUP_CODE
, 'N'))
, 'Y')
, 'N'
, DECODE(SIGN(NVL(PLL.FIRM_DATE
, SYSDATE+1)-SYSDATE)
, 1
, NVL(PLL.FIRM_STATUS_LOOKUP_CODE
, 'N')
, 'Y')
, 'Y')
, 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.PO_LINE_LOCATION_ID
, MS.PO_DISTRIBUTION_ID
, PL.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
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
WHERE (MS.SUPPLY_TYPE_CODE = 'PO' OR MS.SUPPLY_TYPE_CODE = 'ASN')
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 MUOM.UNIT_OF_MEASURE = MS.UNIT_OF_MEASURE