VIEW: APPS.PA_PROJ_PEND_PO_DISTRIBUTIONS

Source

View Text - Preformatted

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 = 'N'

View Text - HTML Formatted

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 = 'N'