eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_STATUS_CMT_BASE_V

Product:	PA - Projects
Description:	10SC Only - Retrofitted - Retrofitted
Implementation/DBA Data:	APPS.PA_STATUS_CMT_BASE_V

View Text

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
, TRANSACTION_SOURCE
, TRANSACTION_SOURCE_M
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDENED_COST
, ACCT_CURRENCY_CODE
, ACCT_RAW_COST
, ACCT_BURDENED_COST
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, RECEIPT_CURRENCY_CODE
, RECEIPT_CURRENCY_AMOUNT
, RECEIPT_EXCHANGE_RATE
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE
, CMT_REJECTION_CODE
FROM PA_STATUS_PROJ_CMT_BASE_V UNION ALL 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
, TRANSACTION_SOURCE
, TRANSACTION_SOURCE_M
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDENED_COST
, ACCT_CURRENCY_CODE
, ACCT_RAW_COST
, ACCT_BURDENED_COST
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, RECEIPT_CURRENCY_CODE
, RECEIPT_CURRENCY_AMOUNT
, RECEIPT_EXCHANGE_RATE
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE
, CMT_REJECTION_CODE
FROM PA_STATUS_TASK_CMT_BASE_V UNION ALL 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
, TRANSACTION_SOURCE
, TRANSACTION_SOURCE_M
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDENED_COST
, ACCT_CURRENCY_CODE
, ACCT_RAW_COST
, ACCT_BURDENED_COST
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, RECEIPT_CURRENCY_CODE
, RECEIPT_CURRENCY_AMOUNT
, RECEIPT_EXCHANGE_RATE
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE
, CMT_REJECTION_CODE
FROM PA_STATUS_RSRC_CMT_BASE_V

Columns

Name
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
TRANSACTION_SOURCE
TRANSACTION_SOURCE_M
DENOM_CURRENCY_CODE
DENOM_RAW_COST
DENOM_BURDENED_COST
ACCT_CURRENCY_CODE
ACCT_RAW_COST
ACCT_BURDENED_COST
ACCT_RATE_DATE
ACCT_RATE_TYPE
ACCT_EXCHANGE_RATE
RECEIPT_CURRENCY_CODE
RECEIPT_CURRENCY_AMOUNT
RECEIPT_EXCHANGE_RATE
PROJECT_CURRENCY_CODE
PROJECT_RATE_DATE
PROJECT_RATE_TYPE
PROJECT_EXCHANGE_RATE
CMT_REJECTION_CODE