POR_PJC_COMMITMENTS_V

Details

• Schema: FUSION

• Object owner: POR

• Object type: VIEW

Columns

Name

REQUISITION_HEADER_ID REQUISITION_NUMBER REQUISITION_LINE_ID LINE_NUMBER CREATION_DATE NEED_BY_DATE DESTINATION_TYPE_CODE APPROVED_FLAG CATEGORY_ID ITEM_DESCRIPTION ITEM_ID LINE_TYPE_ID QUANTITY UNIT_PRICE CURRENCY_UNIT_PRICE UOM_CODE REQUESTER_ID VENDOR_ID REQ_BU_ID CURRENCY_CODE AMOUNT CURRENCY_AMOUNT RATE RATE_TYPE RATE_DATE SOURCE_TYPE_CODE SOURCE_ORGANIZATION_ID SOURCE_SUBINVENTORY PO_HEADER_ID PO_LINE_ID TO_HEADER_ID TO_LINE_ID DISTRIBUTION_ID DISTRIBUTION_NUMBER DISTRIBUTION_QUANTITY PERCENT DISTRIBUTION_AMOUNT DISTRIBUTION_CURRENCY_AMOUNT NONRECOVERABLE_TAX NONRECOVERABLE_CURRENCY_TAX RECOVERABLE_TAX RECOVERABLE_CURRENCY_TAX PRIMARY_LEDGER_ID CODE_COMBINATION_ID FUNDS_STATUS BUDGET_DATE PJC_CONTEXT_CATEGORY PJC_PROJECT_ID PJC_TASK_ID PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID PJC_BILLABLE_FLAG PJC_CAPITALIZABLE_FLAG PJC_WORK_TYPE_ID PJC_CONTRACT_ID PJC_CONTRACT_LINE_ID PJC_FUNDING_ALLOCATION_ID PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE10 PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE10 PROJECT_TYPE_ID COST_COLL_EXCLUDED

Query

SQL_Statement

SELECT PRH.REQUISITION_HEADER_ID, PRH.REQUISITION_NUMBER, PRL.REQUISITION_LINE_ID, PRL.LINE_NUMBER, PRL.CREATION_DATE, PRL.NEED_BY_DATE, PRL.DESTINATION_TYPE_CODE, (DECODE (PRL.LINE_STATUS, 'APPROVED', 'Y', 'HOLD', 'Y', 'N')) APPROVED_FLAG, PRL.CATEGORY_ID, PRL.ITEM_DESCRIPTION, PRL.ITEM_ID, PRL.LINE_TYPE_ID, PRL.QUANTITY, PRL.UNIT_PRICE, PRL.CURRENCY_UNIT_PRICE, PRL.UOM_CODE, PRL.REQUESTER_ID, PRL.VENDOR_ID, PRL.REQ_BU_ID, PRL.CURRENCY_CODE, PRL.AMOUNT, PRL.CURRENCY_AMOUNT, PRL.RATE, PRL.RATE_TYPE, PRL.RATE_DATE, PRL.SOURCE_TYPE_CODE, PRL.SOURCE_ORGANIZATION_ID, PRL.SOURCE_SUBINVENTORY, PRL.PO_HEADER_ID, PRL.PO_LINE_ID, PRL.TO_HEADER_ID, PRL.TO_LINE_ID, PRD.DISTRIBUTION_ID, PRD.DISTRIBUTION_NUMBER, PRD.DISTRIBUTION_QUANTITY, PRD.PERCENT, PRD.DISTRIBUTION_AMOUNT, PRD.DISTRIBUTION_CURRENCY_AMOUNT, PRD.NONRECOVERABLE_TAX, PRD.NONRECOVERABLE_CURRENCY_TAX, PRD.RECOVERABLE_TAX, PRD.RECOVERABLE_CURRENCY_TAX, PRD.PRIMARY_LEDGER_ID, PRD.CODE_COMBINATION_ID, PRD.FUNDS_STATUS, PRD.BUDGET_DATE, PRD.PJC_CONTEXT_CATEGORY, PRD.PJC_PROJECT_ID, PRD.PJC_TASK_ID, PRD.PJC_EXPENDITURE_TYPE_ID, PRD.PJC_EXPENDITURE_ITEM_DATE, PRD.PJC_ORGANIZATION_ID, PRD.PJC_BILLABLE_FLAG, PRD.PJC_CAPITALIZABLE_FLAG, PRD.PJC_WORK_TYPE_ID, PRD.PJC_CONTRACT_ID, PRD.PJC_CONTRACT_LINE_ID, PRD.PJC_FUNDING_ALLOCATION_ID, PRD.PJC_RESERVED_ATTRIBUTE1, PRD.PJC_RESERVED_ATTRIBUTE2, PRD.PJC_RESERVED_ATTRIBUTE3, PRD.PJC_RESERVED_ATTRIBUTE4, PRD.PJC_RESERVED_ATTRIBUTE5, PRD.PJC_RESERVED_ATTRIBUTE6, PRD.PJC_RESERVED_ATTRIBUTE7, PRD.PJC_RESERVED_ATTRIBUTE8, PRD.PJC_RESERVED_ATTRIBUTE9, PRD.PJC_RESERVED_ATTRIBUTE10, PJC_USER_DEF_ATTRIBUTE1, PJC_USER_DEF_ATTRIBUTE2, PJC_USER_DEF_ATTRIBUTE3, PJC_USER_DEF_ATTRIBUTE4, PJC_USER_DEF_ATTRIBUTE5, PJC_USER_DEF_ATTRIBUTE6, PJC_USER_DEF_ATTRIBUTE7, PJC_USER_DEF_ATTRIBUTE8, PJC_USER_DEF_ATTRIBUTE9, PJC_USER_DEF_ATTRIBUTE10, RPCCSV.PROJECT_TYPE_ID, RPCCSV.COST_COLL_EXCLUDED FROM POR_REQ_DISTRIBUTIONS_ALL PRD, POR_REQUISITION_LINES_ALL PRL, POR_REQUISITION_HEADERS_ALL PRH, RCS_PROJ_COST_COLL_STATUS_V RPCCSV WHERE PRD.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID AND PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID AND PRL.REQUISITION_LINE_ID NOT IN (SELECT PARENT_REQ_LINE_ID FROM POR_REQUISITION_LINES_ALL WHERE ITEM_SOURCE = 'REINSTATE' AND REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID) AND NVL(PRH.PROCESS_STATUS, 'COMPLETED') = 'COMPLETED' AND PRL.LINE_STATUS NOT IN('SPLIT', 'REPLACED', 'CANCELED') AND PRD.PJC_PROJECT_ID = RPCCSV.PROJECT_ID (+)