VIEW: APPS.PA_STATUS_TASK_CMT_BASE_V

Source

View Text - Preformatted

SELECT CT.PROJECT_ID , CT.TASK_ID , 0 ,TAD.TXN_ACCUM_ID , CT.VENDOR_ID , CT.VENDOR_NAME , CT.EXPENDITURE_ITEM_DATE , CT.LINE_TYPE , L.MEANING , CT.CMT_NUMBER , CT.CMT_LINE_NUMBER , CT.PROJ_RAW_COST , CT.PROJ_BURDENED_COST , CT.CMT_APPROVED_DATE , CT.CMT_PROMISED_DATE , CT.CMT_NEED_BY_DATE , CT.DESCRIPTION , T.TASK_NUMBER , T.TASK_NAME , CT.EXPENDITURE_TYPE , CT.ORGANIZATION_ID , O.NAME , CT.CMT_APPROVED_FLAG , CT.TOT_CMT_QUANTITY , CT.UNIT_OF_MEASURE , CT.CMT_REQUESTOR_NAME , CT.CMT_BUYER_NAME , CT.TRANSACTION_SOURCE , L2.MEANING ,CT.DENOM_CURRENCY_CODE ,CT.DENOM_RAW_COST ,CT.DENOM_BURDENED_COST ,CT.ACCT_CURRENCY_CODE ,CT.ACCT_RAW_COST ,CT.ACCT_BURDENED_COST ,CT.ACCT_RATE_DATE ,CT.ACCT_RATE_TYPE ,CT.ACCT_EXCHANGE_RATE ,CT.RECEIPT_CURRENCY_CODE ,CT.RECEIPT_CURRENCY_AMOUNT ,CT.RECEIPT_EXCHANGE_RATE ,CT.PROJECT_CURRENCY_CODE ,CT.PROJECT_RATE_DATE ,CT.PROJECT_RATE_TYPE ,CT.PROJECT_EXCHANGE_RATE ,CT.CMT_REJECTION_CODE ,CT.cmt_distribution_id FROM PA_COMMITMENT_TXNS CT , PA_TXN_ACCUM_DETAILS TAD , PA_LOOKUPS L , PA_LOOKUPS L2 , PA_TASKS T , HR_ORGANIZATION_UNITS O WHERE TAD.LINE_TYPE = 'M' AND TAD.CMT_LINE_ID = CT.CMT_LINE_ID AND L.LOOKUP_CODE = CT.LINE_TYPE AND L.LOOKUP_TYPE = 'COMMITMENT LINE TYPE' AND L2.LOOKUP_CODE = CT.TRANSACTION_SOURCE AND L2.LOOKUP_TYPE = 'COMMITMENT TXN SOURCE' AND CT.TASK_ID = T.TASK_ID AND CT.ORGANIZATION_ID = O.ORGANIZATION_ID AND CT.PROJECT_ID = PA_STATUS.GETPROJID AND CT.TASK_ID = PA_STATUS.GETTASKID

View Text - HTML Formatted

SELECT CT.PROJECT_ID
, CT.TASK_ID
, 0
, TAD.TXN_ACCUM_ID
, CT.VENDOR_ID
, CT.VENDOR_NAME
, CT.EXPENDITURE_ITEM_DATE
, CT.LINE_TYPE
, L.MEANING
, CT.CMT_NUMBER
, CT.CMT_LINE_NUMBER
, CT.PROJ_RAW_COST
, CT.PROJ_BURDENED_COST
, CT.CMT_APPROVED_DATE
, CT.CMT_PROMISED_DATE
, CT.CMT_NEED_BY_DATE
, CT.DESCRIPTION
, T.TASK_NUMBER
, T.TASK_NAME
, CT.EXPENDITURE_TYPE
, CT.ORGANIZATION_ID
, O.NAME
, CT.CMT_APPROVED_FLAG
, CT.TOT_CMT_QUANTITY
, CT.UNIT_OF_MEASURE
, CT.CMT_REQUESTOR_NAME
, CT.CMT_BUYER_NAME
, CT.TRANSACTION_SOURCE
, L2.MEANING
, CT.DENOM_CURRENCY_CODE
, CT.DENOM_RAW_COST
, CT.DENOM_BURDENED_COST
, CT.ACCT_CURRENCY_CODE
, CT.ACCT_RAW_COST
, CT.ACCT_BURDENED_COST
, CT.ACCT_RATE_DATE
, CT.ACCT_RATE_TYPE
, CT.ACCT_EXCHANGE_RATE
, CT.RECEIPT_CURRENCY_CODE
, CT.RECEIPT_CURRENCY_AMOUNT
, CT.RECEIPT_EXCHANGE_RATE
, CT.PROJECT_CURRENCY_CODE
, CT.PROJECT_RATE_DATE
, CT.PROJECT_RATE_TYPE
, CT.PROJECT_EXCHANGE_RATE
, CT.CMT_REJECTION_CODE
, CT.CMT_DISTRIBUTION_ID
FROM PA_COMMITMENT_TXNS CT
, PA_TXN_ACCUM_DETAILS TAD
, PA_LOOKUPS L
, PA_LOOKUPS L2
, PA_TASKS T
, HR_ORGANIZATION_UNITS O
WHERE TAD.LINE_TYPE = 'M'
AND TAD.CMT_LINE_ID = CT.CMT_LINE_ID
AND L.LOOKUP_CODE = CT.LINE_TYPE
AND L.LOOKUP_TYPE = 'COMMITMENT LINE TYPE'
AND L2.LOOKUP_CODE = CT.TRANSACTION_SOURCE
AND L2.LOOKUP_TYPE = 'COMMITMENT TXN SOURCE'
AND CT.TASK_ID = T.TASK_ID
AND CT.ORGANIZATION_ID = O.ORGANIZATION_ID
AND CT.PROJECT_ID = PA_STATUS.GETPROJID
AND CT.TASK_ID = PA_STATUS.GETTASKID