Product: | PA - Projects |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.PA_STATUS_COMMITMENTS_V |
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(+)