VIEW: APPS.PJM_PROJECT_PO_V

Source

View Text - Preformatted

SELECT DISTINCT DIST.PROJECT_ID , DIST.TASK_ID , POH.PO_HEADER_ID , POH.SEGMENT1 , POL.LINE_NUM , POLL.SHIPMENT_NUM , DIST.DISTRIBUTION_NUM , pjm_inquiry.po_type(poh.org_id) , POH.REVISION_NUM , POH.REVISED_DATE , POH.CREATION_DATE , pjm_inquiry.get_lookup(NVL(POH.AUTHORIZATION_STATUS, 'INCOMPLETE'), 'AUTHORIZATION STATUS') , POH.VENDOR_ID , pjm_inquiry.vendor_name(poh.vendor_id) , POH.VENDOR_SITE_ID , pjm_inquiry.vendor_site(poh.vendor_id, poh.vendor_site_id) , POH.SHIP_TO_LOCATION_ID , pjm_inquiry.location_code(POH.SHIP_TO_LOCATION_ID) , POH.SHIP_VIA_LOOKUP_CODE , pjm_inquiry.get_lookup(POH.FREIGHT_TERMS_LOOKUP_CODE, 'FREIGHT TERMS') , pjm_inquiry.get_lookup(POH.FOB_LOOKUP_CODE, 'FOB') , POH.AGENT_ID , pjm_inquiry.people_name(POH.AGENT_ID) , POH.BILL_TO_LOCATION_ID , pjm_inquiry.location_code(POH.BILL_TO_LOCATION_ID) , POH.TERMS_ID , pjm_inquiry.payment_term(POH.TERMS_ID) , POH.CURRENCY_CODE , TO_CHAR( DECODE(POL.MATCHING_BASIS, 'QUANTITY', DIST.QUANTITY_ORDERED * POLL.PRICE_OVERRIDE, 'AMOUNT', DIST.AMOUNT_ORDERED), FND_CURRENCY_CACHE.GET_FORMAT_MASK( POH.CURRENCY_CODE , 40 ) ) , pjm_inquiry.item_number(POL.ITEM_ID,DIST.DESTINATION_ORGANIZATION_ID) , POL.ITEM_DESCRIPTION , DIST.END_ITEM_UNIT_NUMBER , POH.ORG_ID FROM PO_HEADERS_ALL POH , PO_LINES_ALL POL , PO_LINE_LOCATIONS_ALL POLL , PO_DISTRIBUTIONS_ALL DIST WHERE POH.TYPE_LOOKUP_CODE = 'STANDARD' AND POH.APPROVED_FLAG IN ('Y') AND POL.PO_LINE_ID = DIST.PO_LINE_ID AND POH.PO_HEADER_ID = POL.PO_HEADER_ID AND DIST.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND POL.PO_LINE_ID = POLL.PO_LINE_ID ORDER BY DIST.PROJECT_ID DESC, POH.PO_HEADER_ID DESC, POL.LINE_NUM

View Text - HTML Formatted

SELECT DISTINCT DIST.PROJECT_ID
, DIST.TASK_ID
, POH.PO_HEADER_ID
, POH.SEGMENT1
, POL.LINE_NUM
, POLL.SHIPMENT_NUM
, DIST.DISTRIBUTION_NUM
, PJM_INQUIRY.PO_TYPE(POH.ORG_ID)
, POH.REVISION_NUM
, POH.REVISED_DATE
, POH.CREATION_DATE
, PJM_INQUIRY.GET_LOOKUP(NVL(POH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
, 'AUTHORIZATION STATUS')
, POH.VENDOR_ID
, PJM_INQUIRY.VENDOR_NAME(POH.VENDOR_ID)
, POH.VENDOR_SITE_ID
, PJM_INQUIRY.VENDOR_SITE(POH.VENDOR_ID
, POH.VENDOR_SITE_ID)
, POH.SHIP_TO_LOCATION_ID
, PJM_INQUIRY.LOCATION_CODE(POH.SHIP_TO_LOCATION_ID)
, POH.SHIP_VIA_LOOKUP_CODE
, PJM_INQUIRY.GET_LOOKUP(POH.FREIGHT_TERMS_LOOKUP_CODE
, 'FREIGHT TERMS')
, PJM_INQUIRY.GET_LOOKUP(POH.FOB_LOOKUP_CODE
, 'FOB')
, POH.AGENT_ID
, PJM_INQUIRY.PEOPLE_NAME(POH.AGENT_ID)
, POH.BILL_TO_LOCATION_ID
, PJM_INQUIRY.LOCATION_CODE(POH.BILL_TO_LOCATION_ID)
, POH.TERMS_ID
, PJM_INQUIRY.PAYMENT_TERM(POH.TERMS_ID)
, POH.CURRENCY_CODE
, TO_CHAR( DECODE(POL.MATCHING_BASIS
, 'QUANTITY'
, DIST.QUANTITY_ORDERED * POLL.PRICE_OVERRIDE
, 'AMOUNT'
, DIST.AMOUNT_ORDERED)
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( POH.CURRENCY_CODE
, 40 ) )
, PJM_INQUIRY.ITEM_NUMBER(POL.ITEM_ID
, DIST.DESTINATION_ORGANIZATION_ID)
, POL.ITEM_DESCRIPTION
, DIST.END_ITEM_UNIT_NUMBER
, POH.ORG_ID
FROM PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, PO_LINE_LOCATIONS_ALL POLL
, PO_DISTRIBUTIONS_ALL DIST
WHERE POH.TYPE_LOOKUP_CODE = 'STANDARD'
AND POH.APPROVED_FLAG IN ('Y')
AND POL.PO_LINE_ID = DIST.PO_LINE_ID
AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND DIST.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
AND POL.PO_LINE_ID = POLL.PO_LINE_ID ORDER BY DIST.PROJECT_ID DESC
, POH.PO_HEADER_ID DESC
, POL.LINE_NUM