View: PAFV_COMMITMENTS

Product:	PA - Projects
Description:	Business view to show commitments for a project. Business view to show commitments for a project.
Implementation/DBA Data:	APPS.PAFV_COMMITMENTS

View Text

SELECT PC.CMT_LINE_ID
, PC.CMT_NUMBER
, PC.EXPENDITURE_ITEM_DATE
, PC.TOT_CMT_RAW_COST
, PC.TOT_CMT_BURDENED_COST
, PC.TOT_CMT_QUANTITY
, PC.DESCRIPTION
, PC.CMT_LINE_NUMBER
, CMT_CREATION_DATE
, CMT_APPROVED_DATE
, CMT_PROMISED_DATE
, CMT_NEED_BY_DATE
, PC.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PC.TASK_ID
, PT.TASK_NAME
, PT.TASK_NUMBER
, PC.EXPENDITURE_TYPE
, PPA.ORG_ID
, PC.ORGANIZATION_ID
, T.NAME
, PC.LAST_UPDATE_DATE
, PC.LAST_UPDATED_BY
, PC.CREATION_DATE
, PC.CREATED_BY
, PC.RECEIPT_CURRENCY_CODE
, PC.RECEIPT_CURRENCY_AMOUNT
, PC.RECEIPT_EXCHANGE_RATE
, PC.DENOM_CURRENCY_CODE
, PC.DENOM_RAW_COST
, PC.DENOM_BURDENED_COST
, PC.ACCT_CURRENCY_CODE
, PC.ACCT_RAW_COST
, PC.ACCT_BURDENED_COST
, PC.ACCT_RATE_DATE
, PC.ACCT_RATE_TYPE
, PCT.USER_CONVERSION_TYPE
, PC.ACCT_EXCHANGE_RATE
, PC.PROJECT_CURRENCY_CODE
, PC.PROJECT_RATE_DATE
, PC.PROJECT_RATE_TYPE
, PCT1.USER_CONVERSION_TYPE
, PC.PROJECT_EXCHANGE_RATE
, '_LA:TRANSACTION_SOURCE:PA_LOOKUPS:COMMITMENT TXN SOURCE:MEANING'
, '_LA:LINE_TYPE:PA_LOOKUPS:COMMITMENT LINE TYPE:MEANING'
, '_LA:CMT_APPROVED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PC.CMT_DISTRIBUTION_ID
FROM PA_COMMITMENT_TXNS PC
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
, HR_ALL_ORGANIZATION_UNITS HRO
, HR_ALL_ORGANIZATION_UNITS_TL T
, PA_CONVERSION_TYPES_V PCT
, PA_CONVERSION_TYPES_V PCT1
WHERE PC.PROJECT_ID = PPA.PROJECT_ID
AND PC.TASK_ID = PT.TASK_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL
AND PC.ACCT_RATE_TYPE = PCT.CONVERSION_TYPE(+)
AND PC.PROJECT_RATE_TYPE = PCT1.CONVERSION_TYPE(+)
AND PC.ORGANIZATION_ID=HRO.ORGANIZATION_ID (+)
AND PC.ORGANIZATION_ID=T.ORGANIZATION_ID(+)
AND T.LANGUAGE(+)=USERENV('LANG') WITH READ ONLY

Columns