VIEW: APPS.PJM_PROJECT_COMMIT_V

Source

View Text - Preformatted

SELECT CT.PROJECT_ID , CT.TASK_ID , 0 , PTAD.TXN_ACCUM_ID , CT.VENDOR_ID , CT.VENDOR_NAME , CT.CMT_CREATION_DATE , L1.MEANING , CT.CMT_NUMBER , CT.CMT_LINE_NUMBER , TO_CHAR(CT.TOT_CMT_RAW_COST , FND_CURRENCY_CACHE.GET_FORMAT_MASK(CT.ACCT_CURRENCY_CODE , 40)) , TO_CHAR(CT.TOT_CMT_BURDENED_COST , FND_CURRENCY_CACHE.GET_FORMAT_MASK(CT.ACCT_CURRENCY_CODE , 40)) , CT.CMT_APPROVED_DATE , CT.CMT_PROMISED_DATE , CT.CMT_NEED_BY_DATE , CT.DESCRIPTION , T.TASK_NUMBER , T.TASK_NAME , CT.EXPENDITURE_TYPE , HOU.NAME , CT.CMT_APPROVED_FLAG , CT.TOT_CMT_QUANTITY , CT.UNIT_OF_MEASURE , CT.CMT_REQUESTOR_NAME , CT.CMT_BUYER_NAME , L2.MEANING , CT.DENOM_CURRENCY_CODE , TO_CHAR(CT.DENOM_RAW_COST , FND_CURRENCY_CACHE.GET_FORMAT_MASK(CT.DENOM_CURRENCY_CODE , 40)) , TO_CHAR(CT.DENOM_BURDENED_COST , FND_CURRENCY_CACHE.GET_FORMAT_MASK(CT.DENOM_CURRENCY_CODE , 40)) , CT.ACCT_CURRENCY_CODE , TO_CHAR(CT.ACCT_RAW_COST , FND_CURRENCY_CACHE.GET_FORMAT_MASK(CT.ACCT_CURRENCY_CODE , 40)) , TO_CHAR(CT.ACCT_BURDENED_COST , FND_CURRENCY_CACHE.GET_FORMAT_MASK(CT.ACCT_CURRENCY_CODE , 40)) , CT.ACCT_RATE_DATE , CT.ACCT_RATE_TYPE , ROUND(CT.ACCT_EXCHANGE_RATE , NVL( ACCT_CURR.EXTENDED_PRECISION , NVL(ACCT_CURR.PRECISION , 5))) , CT.RECEIPT_CURRENCY_CODE , TO_CHAR(CT.RECEIPT_CURRENCY_AMOUNT , FND_CURRENCY_CACHE.GET_FORMAT_MASK(CT.RECEIPT_CURRENCY_CODE , 40)) , ROUND(CT.RECEIPT_EXCHANGE_RATE , NVL( RCPT_CURR.EXTENDED_PRECISION , NVL(RCPT_CURR.PRECISION , 5))) , CT.PROJECT_CURRENCY_CODE , CT.PROJECT_RATE_DATE , CT.PROJECT_RATE_TYPE , ROUND(CT.PROJECT_EXCHANGE_RATE , NVL( PROJ_CURR.EXTENDED_PRECISION , NVL(PROJ_CURR.PRECISION , 5))) , FND_MESSAGE_CACHE.GET_STRING( 'PA' , CT.CMT_REJECTION_CODE ) FROM PA_COMMITMENT_TXNS CT , PA_TASKS T , PA_TXN_ACCUM_DETAILS PTAD , PA_LOOKUPS L1 , PA_LOOKUPS L2 , HR_ALL_ORGANIZATION_UNITS_TL HOU , FND_CURRENCIES ACCT_CURR , FND_CURRENCIES RCPT_CURR , FND_CURRENCIES PROJ_CURR WHERE PTAD.LINE_TYPE = 'M' AND PTAD.CMT_LINE_ID = CT.CMT_LINE_ID AND T.TASK_ID = CT.TASK_ID AND L1.LOOKUP_TYPE = 'COMMITMENT LINE TYPE' AND L1.LOOKUP_CODE = CT.LINE_TYPE AND L2.LOOKUP_TYPE = 'COMMITMENT TXN SOURCE' AND L2.LOOKUP_CODE = CT.TRANSACTION_SOURCE AND CT.ORGANIZATION_ID = HOU.ORGANIZATION_ID AND HOU.LANGUAGE = USERENV('LANG') AND ACCT_CURR.CURRENCY_CODE (+) = CT.ACCT_CURRENCY_CODE AND RCPT_CURR.CURRENCY_CODE (+) = CT.RECEIPT_CURRENCY_CODE AND PROJ_CURR.CURRENCY_CODE (+) = CT.PROJECT_CURRENCY_CODE

View Text - HTML Formatted

SELECT CT.PROJECT_ID
, CT.TASK_ID
, 0
, PTAD.TXN_ACCUM_ID
, CT.VENDOR_ID
, CT.VENDOR_NAME
, CT.CMT_CREATION_DATE
, L1.MEANING
, CT.CMT_NUMBER
, CT.CMT_LINE_NUMBER
, TO_CHAR(CT.TOT_CMT_RAW_COST
, FND_CURRENCY_CACHE.GET_FORMAT_MASK(CT.ACCT_CURRENCY_CODE
, 40))
, TO_CHAR(CT.TOT_CMT_BURDENED_COST
, FND_CURRENCY_CACHE.GET_FORMAT_MASK(CT.ACCT_CURRENCY_CODE
, 40))
, CT.CMT_APPROVED_DATE
, CT.CMT_PROMISED_DATE
, CT.CMT_NEED_BY_DATE
, CT.DESCRIPTION
, T.TASK_NUMBER
, T.TASK_NAME
, CT.EXPENDITURE_TYPE
, HOU.NAME
, CT.CMT_APPROVED_FLAG
, CT.TOT_CMT_QUANTITY
, CT.UNIT_OF_MEASURE
, CT.CMT_REQUESTOR_NAME
, CT.CMT_BUYER_NAME
, L2.MEANING
, CT.DENOM_CURRENCY_CODE
, TO_CHAR(CT.DENOM_RAW_COST
, FND_CURRENCY_CACHE.GET_FORMAT_MASK(CT.DENOM_CURRENCY_CODE
, 40))
, TO_CHAR(CT.DENOM_BURDENED_COST
, FND_CURRENCY_CACHE.GET_FORMAT_MASK(CT.DENOM_CURRENCY_CODE
, 40))
, CT.ACCT_CURRENCY_CODE
, TO_CHAR(CT.ACCT_RAW_COST
, FND_CURRENCY_CACHE.GET_FORMAT_MASK(CT.ACCT_CURRENCY_CODE
, 40))
, TO_CHAR(CT.ACCT_BURDENED_COST
, FND_CURRENCY_CACHE.GET_FORMAT_MASK(CT.ACCT_CURRENCY_CODE
, 40))
, CT.ACCT_RATE_DATE
, CT.ACCT_RATE_TYPE
, ROUND(CT.ACCT_EXCHANGE_RATE
, NVL( ACCT_CURR.EXTENDED_PRECISION
, NVL(ACCT_CURR.PRECISION
, 5)))
, CT.RECEIPT_CURRENCY_CODE
, TO_CHAR(CT.RECEIPT_CURRENCY_AMOUNT
, FND_CURRENCY_CACHE.GET_FORMAT_MASK(CT.RECEIPT_CURRENCY_CODE
, 40))
, ROUND(CT.RECEIPT_EXCHANGE_RATE
, NVL( RCPT_CURR.EXTENDED_PRECISION
, NVL(RCPT_CURR.PRECISION
, 5)))
, CT.PROJECT_CURRENCY_CODE
, CT.PROJECT_RATE_DATE
, CT.PROJECT_RATE_TYPE
, ROUND(CT.PROJECT_EXCHANGE_RATE
, NVL( PROJ_CURR.EXTENDED_PRECISION
, NVL(PROJ_CURR.PRECISION
, 5)))
, FND_MESSAGE_CACHE.GET_STRING( 'PA'
, CT.CMT_REJECTION_CODE )
FROM PA_COMMITMENT_TXNS CT
, PA_TASKS T
, PA_TXN_ACCUM_DETAILS PTAD
, PA_LOOKUPS L1
, PA_LOOKUPS L2
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, FND_CURRENCIES ACCT_CURR
, FND_CURRENCIES RCPT_CURR
, FND_CURRENCIES PROJ_CURR
WHERE PTAD.LINE_TYPE = 'M'
AND PTAD.CMT_LINE_ID = CT.CMT_LINE_ID
AND T.TASK_ID = CT.TASK_ID
AND L1.LOOKUP_TYPE = 'COMMITMENT LINE TYPE'
AND L1.LOOKUP_CODE = CT.LINE_TYPE
AND L2.LOOKUP_TYPE = 'COMMITMENT TXN SOURCE'
AND L2.LOOKUP_CODE = CT.TRANSACTION_SOURCE
AND CT.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND HOU.LANGUAGE = USERENV('LANG')
AND ACCT_CURR.CURRENCY_CODE (+) = CT.ACCT_CURRENCY_CODE
AND RCPT_CURR.CURRENCY_CODE (+) = CT.RECEIPT_CURRENCY_CODE
AND PROJ_CURR.CURRENCY_CODE (+) = CT.PROJECT_CURRENCY_CODE