View: PABV_COMMITMENTS

Product:	PA - Projects
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PABV_COMMITMENTS

View Text

SELECT PC.CMT_LINE_ID
, '_LA:PC.TRANSACTION_SOURCE:PA_LOOKUPS:COMMITMENT TXN SOURCE:MEANING'
, 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
, '_LA:PC.LINE_TYPE:PA_LOOKUPS:COMMITMENT LINE TYPE:MEANING'
, PC.CMT_CREATION_DATE
, PC.CMT_APPROVED_DATE
, '_LA:PC.CMT_APPROVED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PC.CMT_PROMISED_DATE
, PC.CMT_NEED_BY_DATE
, PC.PROJECT_ID
, PC.TASK_ID
, PC.EXPENDITURE_TYPE
, PC.ORGANIZATION_ID
, 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
, PC.ACCT_EXCHANGE_RATE
, PC.PROJECT_CURRENCY_CODE
, PC.PROJECT_RATE_DATE
, PC.PROJECT_RATE_TYPE
, PC.PROJECT_EXCHANGE_RATE
, PC.CMT_DISTRIBUTION_ID
FROM PA_COMMITMENT_TXNS PC
, PA_PROJECTS_ALL PPA
WHERE PC.PROJECT_ID = PPA.PROJECT_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns