VIEW: APPS.PA_STATUS_COMMITMENTS_V

Source

View Text - Preformatted

SELECT CB.PROJECT_ID , CB.TASK_ID , CB.RESOURCE_LIST_MEMBER_ID , CB.TXN_ACCUM_ID , CB.VENDOR_ID , CB.VENDOR_NAME , CB.CMT_CREATION_DATE , CB.CMT_TYPE_CODE , CB.CMT_TYPE_CODE_M , CB.CMT_NUMBER , CB.CMT_LINE_NUMBER , CB.TOT_CMT_RAW_COST , CB.TOT_CMT_BURDENED_COST , CB.CMT_APPROVED_DATE , CB.CMT_PROMISED_DATE , CB.CMT_NEED_BY_DATE , CB.DESCRIPTION , CB.TASK_NUMBER , CB.TASK_NAME , CB.EXPENDITURE_TYPE , CB.ORGANIZATION_ID , CB.EXPENDITURE_ORG_NAME , CB.CMT_APPROVED_FLAG , CB.QUANTITY_OUTSTANDING , CB.UNIT_OF_MEASURE , CB.CMT_REQUESTOR_NAME , CB.CMT_BUYER_NAME , CB.TRANSACTION_SOURCE , CB.TRANSACTION_SOURCE_M ,CB.denom_currency_code ,CB.denom_raw_cost ,CB.denom_burdened_cost ,CB.acct_currency_code ,CB.acct_raw_cost ,CB.acct_burdened_cost ,CB.acct_rate_date ,CB.acct_rate_type ,CB.acct_exchange_rate ,CB.receipt_currency_code ,CB.receipt_currency_amount ,CB.receipt_exchange_rate ,CB.project_currency_code ,CB.project_rate_date ,CB.project_rate_type ,CB.project_exchange_rate ,CB.cmt_rejection_code ,CONV.USER_CONVERSION_TYPE ,CONV2.USER_CONVERSION_TYPE ,fnd_message.get_string('PA', CB.cmt_rejection_code) FROM PA_STATUS_CMT_BASE_V CB, PA_CONVERSION_TYPES_V CONV, PA_CONVERSION_TYPES_V CONV2 WHERE CB.PROJECT_ID = PA_STATUS.GETPROJID AND CB.TASK_ID = PA_STATUS.GETTASKID AND CB.RESOURCE_LIST_MEMBER_ID = PA_STATUS.GETRSRCMEMBERID AND CB.ACCT_RATE_TYPE = CONV.CONVERSION_TYPE (+) AND CB.PROJECT_RATE_TYPE = CONV2.CONVERSION_TYPE(+)

View Text - HTML Formatted

SELECT CB.PROJECT_ID
, CB.TASK_ID
, CB.RESOURCE_LIST_MEMBER_ID
, CB.TXN_ACCUM_ID
, CB.VENDOR_ID
, CB.VENDOR_NAME
, CB.CMT_CREATION_DATE
, CB.CMT_TYPE_CODE
, CB.CMT_TYPE_CODE_M
, CB.CMT_NUMBER
, CB.CMT_LINE_NUMBER
, CB.TOT_CMT_RAW_COST
, CB.TOT_CMT_BURDENED_COST
, CB.CMT_APPROVED_DATE
, CB.CMT_PROMISED_DATE
, CB.CMT_NEED_BY_DATE
, CB.DESCRIPTION
, CB.TASK_NUMBER
, CB.TASK_NAME
, CB.EXPENDITURE_TYPE
, CB.ORGANIZATION_ID
, CB.EXPENDITURE_ORG_NAME
, CB.CMT_APPROVED_FLAG
, CB.QUANTITY_OUTSTANDING
, CB.UNIT_OF_MEASURE
, CB.CMT_REQUESTOR_NAME
, CB.CMT_BUYER_NAME
, CB.TRANSACTION_SOURCE
, CB.TRANSACTION_SOURCE_M
, CB.DENOM_CURRENCY_CODE
, CB.DENOM_RAW_COST
, CB.DENOM_BURDENED_COST
, CB.ACCT_CURRENCY_CODE
, CB.ACCT_RAW_COST
, CB.ACCT_BURDENED_COST
, CB.ACCT_RATE_DATE
, CB.ACCT_RATE_TYPE
, CB.ACCT_EXCHANGE_RATE
, CB.RECEIPT_CURRENCY_CODE
, CB.RECEIPT_CURRENCY_AMOUNT
, CB.RECEIPT_EXCHANGE_RATE
, CB.PROJECT_CURRENCY_CODE
, CB.PROJECT_RATE_DATE
, CB.PROJECT_RATE_TYPE
, CB.PROJECT_EXCHANGE_RATE
, CB.CMT_REJECTION_CODE
, CONV.USER_CONVERSION_TYPE
, CONV2.USER_CONVERSION_TYPE
, FND_MESSAGE.GET_STRING('PA'
, CB.CMT_REJECTION_CODE)
FROM PA_STATUS_CMT_BASE_V CB
, PA_CONVERSION_TYPES_V CONV
, PA_CONVERSION_TYPES_V CONV2
WHERE CB.PROJECT_ID = PA_STATUS.GETPROJID
AND CB.TASK_ID = PA_STATUS.GETTASKID
AND CB.RESOURCE_LIST_MEMBER_ID = PA_STATUS.GETRSRCMEMBERID
AND CB.ACCT_RATE_TYPE = CONV.CONVERSION_TYPE (+)
AND CB.PROJECT_RATE_TYPE = CONV2.CONVERSION_TYPE(+)