CMR_RCV_PROJECT_INFO_V

Details

• Schema: FUSION

• Object owner: CMR

• Object type: VIEW

Columns

Name

CMR_PO_DISTRIBUTION_ID CMR_RCV_TRANSACTION_ID TRANSACTION_TYPE RCV_RANK PJC_CONTEXT_CATEGORY PJC_PROJECT_ID PJC_TASK_ID PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID PJC_BILLABLE_FLAG PJC_WORK_TYPE_ID PJC_FUNDING_ALLOCATION_ID PJC_CONTRACT_ID PJC_CONTRACT_LINE_ID 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 PJC_CAPITALIZABLE_FLAG 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_INTERFACED_STATUS

Query

SQL_Statement

SELECT CMR_PO_DISTRIBUTION_ID, CMR_RCV_TRANSACTION_ID, TRANSACTION_TYPE, RANK () OVER (PARTITION BY CMR_PO_DISTRIBUTION_ID ORDER BY CMR_RCV_TRANSACTION_ID DESC) rcv_rank, PJC_CONTEXT_CATEGORY, PJC_PROJECT_ID, PJC_TASK_ID, PJC_EXPENDITURE_TYPE_ID, PJC_EXPENDITURE_ITEM_DATE, PJC_ORGANIZATION_ID, PJC_BILLABLE_FLAG, PJC_WORK_TYPE_ID, PJC_FUNDING_ALLOCATION_ID, PJC_CONTRACT_ID, PJC_CONTRACT_LINE_ID, 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, PJC_CAPITALIZABLE_FLAG, 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_INTERFACED_STATUS FROM CMR_RCV_TRANSACTIONS