Product: | PA - Projects |
---|---|
Description: | Shows project related unapproved, unpurchased requisition distributions |
Implementation/DBA Data: | APPS.PA_PROJ_PEND_REQ_DISTRIBUTIONS |
SELECT PRD.REQ_NUMBER
, PRD.DOCUMENT_TYPE
, PRD.REQ_LINE
, PRD.ITEM_DESCRIPTION
, PRD.NEED_BY_DATE
, PRD.CREATION_DATE
, PRD.VENDOR_NAME
, PRD.VENDOR_ID
, PRD.REQUESTOR_PERSON_ID
, PRD.REQUESTOR_NAME
, PRD.UNIT
, PRD.UNIT_PRICE
, PRD.QUANTITY
, PRD.DENOM_CURRENCY_CODE
, PRD.DENOM_AMOUNT
, PRD.ACCT_CURRENCY_CODE
, PRD.AMOUNT
, PRD.ACCT_RATE_DATE
, PRD.ACCT_RATE_TYPE
, PRD.ACCT_EXCHANGE_RATE
, PRD.PROJECT_NUMBER
, PRD.PROJECT_NAME
, PRD.TASK_NUMBER
, PRD.TASK_NAME
, PRD.EXPENDITURE_TYPE
, PRD.EXPENDITURE_CATEGORY
, PRD.REVENUE_CATEGORY
, PRD.EXPENDITURE_ITEM_DATE
, PRD.EXPENDITURE_ORGANIZATION
, PRD.REQUISITION_HEADER_ID
, PRD.REQUISITION_LINE_ID
, PRD.REQ_DISTRIBUTION_ID
, PRD.PROJECT_ID
, PRD.TASK_ID
, PRD.EXPENDITURE_ORGANIZATION_ID
FROM PA_PROJ_REQ_DISTRIBUTIONS PRD
WHERE PRD.APPROVED_FLAG != 'Y'