Product: | PA - Projects |
---|---|
Description: | This view retrieves project, task and resource related commitments, including commitment-line attribute |
Implementation/DBA Data: | APPS.PA_ACCUM_CMT_TXNS_V |
SELECT PROJECT_ID
, TASK_ID
, RESOURCE_LIST_MEMBER_ID
, TXN_ACCUM_ID
, VENDOR_ID
, VENDOR_NAME
, CMT_CREATION_DATE
, CMT_TYPE_CODE
, CMT_TYPE_CODE_M
, CMT_NUMBER
, CMT_LINE_NUMBER
, TOT_CMT_RAW_COST
, TOT_CMT_BURDENED_COST
, CMT_APPROVED_DATE
, CMT_PROMISED_DATE
, CMT_NEED_BY_DATE
, DESCRIPTION
, TASK_NUMBER
, TASK_NAME
, EXPENDITURE_TYPE
, ORGANIZATION_ID
, EXPENDITURE_ORG_NAME
, CMT_APPROVED_FLAG
, QUANTITY_OUTSTANDING
, UNIT_OF_MEASURE
, CMT_REQUESTOR_NAME
, CMT_BUYER_NAME
, AMOUNT_DELIVERED
, TRANSACTION_SOURCE
, TRANSACTION_SOURCE_M
FROM PA_ACCUM_PROJ_CMT_TXNS_BASE_V UNION SELECT PROJECT_ID
, TASK_ID
, RESOURCE_LIST_MEMBER_ID
, TXN_ACCUM_ID
, VENDOR_ID
, VENDOR_NAME
, CMT_CREATION_DATE
, CMT_TYPE_CODE
, CMT_TYPE_CODE_M
, CMT_NUMBER
, CMT_LINE_NUMBER
, TOT_CMT_RAW_COST
, TOT_CMT_BURDENED_COST
, CMT_APPROVED_DATE
, CMT_PROMISED_DATE
, CMT_NEED_BY_DATE
, DESCRIPTION
, TASK_NUMBER
, TASK_NAME
, EXPENDITURE_TYPE
, ORGANIZATION_ID
, EXPENDITURE_ORG_NAME
, CMT_APPROVED_FLAG
, QUANTITY_OUTSTANDING
, UNIT_OF_MEASURE
, CMT_REQUESTOR_NAME
, CMT_BUYER_NAME
, AMOUNT_DELIVERED
, TRANSACTION_SOURCE
, TRANSACTION_SOURCE_M
FROM PA_ACCUM_TASK_CMT_TXNS_BASE_V UNION SELECT PROJECT_ID
, TASK_ID
, RESOURCE_LIST_MEMBER_ID
, TXN_ACCUM_ID
, VENDOR_ID
, VENDOR_NAME
, CMT_CREATION_DATE
, CMT_TYPE_CODE
, CMT_TYPE_CODE_M
, CMT_NUMBER
, CMT_LINE_NUMBER
, TOT_CMT_RAW_COST
, TOT_CMT_BURDENED_COST
, CMT_APPROVED_DATE
, CMT_PROMISED_DATE
, CMT_NEED_BY_DATE
, DESCRIPTION
, TASK_NUMBER
, TASK_NAME
, EXPENDITURE_TYPE
, ORGANIZATION_ID
, EXPENDITURE_ORG_NAME
, CMT_APPROVED_FLAG
, QUANTITY_OUTSTANDING
, UNIT_OF_MEASURE
, CMT_REQUESTOR_NAME
, CMT_BUYER_NAME
, AMOUNT_DELIVERED
, TRANSACTION_SOURCE
, TRANSACTION_SOURCE_M
FROM PA_ACCUM_RSRC_CMT_TXNS_BASE_V