Product: | PA - Projects |
---|---|
Description: | Shows all approved and uninvoiced purchase order distributions, which are project related. |
Implementation/DBA Data: | APPS.PA_PROJ_APPR_PO_DISTRIBUTIONS |
SELECT POD.PO_NUMBER
, POD.PO_REVISION
, POD.RELEASE_NUMBER
, POD.RELEASE_REVISION
, POD.DOCUMENT_TYPE
, POD.CREATION_DATE
, POD.APPROVED_DATE
, POD.PRINTED_DATE
, POD.REQUESTOR_PERSON_ID
, POD.REQUESTOR_NAME
, POD.BUYER_PERSON_ID
, POD.BUYER_NAME
, POD.VENDOR_NAME
, POD.VENDOR_ID
, POD.PO_LINE
, POD.ITEM_DESCRIPTION
, POD.UNIT
, POD.UNIT_PRICE
, POD.QUANTITY_ORDERED
, POD.AMOUNT_ORDERED
, POD.ORIGINAL_QUANTITY_ORDERED
, POD.ORIGINAL_AMOUNT_ORDERED
, POD.QUANTITY_CANCELLED
, POD.AMOUNT_CANCELLED
, POD.QUANTITY_DELIVERED
, POD.AMOUNT_DELIVERED
, POD.QUANTITY_INVOICED
, POD.AMOUNT_INVOICED
, POD.QUANTITY_OUTSTANDING_DELIVERY
, POD.AMOUNT_OUTSTANDING_DELIVERY
, POD.QUANTITY_OUTSTANDING_INVOICE
, POD.DENOM_CURRENCY_CODE
, POD.DENOM_AMT_OUTSTANDING_INVOICE
, POD.ACCT_CURRENCY_CODE
, POD.AMOUNT_OUTSTANDING_INVOICE
, POD.ACCT_RATE_DATE
, POD.ACCT_RATE_TYPE
, POD.ACCT_EXCHANGE_RATE
, POD.QUANTITY_OVERBILLED
, POD.AMOUNT_OVERBILLED
, POD.PROJECT_NUMBER
, POD.PROJECT_NAME
, POD.TASK_NUMBER
, POD.TASK_NAME
, POD.EXPENDITURE_TYPE
, POD.EXPENDITURE_CATEGORY
, POD.REVENUE_CATEGORY
, POD.EXPENDITURE_ITEM_DATE
, POD.EXPENDITURE_ORGANIZATION
, POD.PO_HEADER_ID
, POD.PO_RELEASE_ID
, POD.PO_LINE_ID
, POD.PO_LINE_LOCATION_ID
, POD.PO_DISTRIBUTION_ID
, POD.PROJECT_ID
, POD.TASK_ID
, POD.EXPENDITURE_ORGANIZATION_ID
FROM PA_PROJ_PO_DISTRIBUTIONS POD
WHERE POD.EVER_APPROVED_FLAG = 'Y'