VIEW: APPS.PA_ACCUM_CMT_TXNS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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