View: PA_PROJ_APPR_REQ_DISTRIBUTIONS

Product:	PA - Projects
Description:	Shows all approved and unpurchased requisition distributions, which are project related.
Implementation/DBA Data:	APPS.PA_PROJ_APPR_REQ_DISTRIBUTIONS

View Text

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'

Columns