View: PA_ACCUM_TASK_CMT_TXNS_BASE_V

Product:	PA - Projects
Description:	This view retrieves project-task level commitments, including commitment-line attributes like commi - Retrofitted
Implementation/DBA Data:	APPS.PA_ACCUM_TASK_CMT_TXNS_BASE_V

View Text

SELECT CT.PROJECT_ID
, CT.TASK_ID
, 0
, TAD.TXN_ACCUM_ID
, CT.VENDOR_ID
, CT.VENDOR_NAME
, CT.CMT_CREATION_DATE
, CT.LINE_TYPE
, L.MEANING
, CT.CMT_NUMBER
, CT.CMT_LINE_NUMBER
, CT.TOT_CMT_RAW_COST
, CT.TOT_CMT_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.AMOUNT_DELIVERED
, CT.TRANSACTION_SOURCE
, L2.MEANING
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

Columns