VIEW: APPS.PA_PROJ_APPR_REQ_DISTRIBUTIONS

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'