[Home] [Help]
View: PAFV_COMMITMENTS_OBSOLETE
| Product: | PA - Projects |
|---|
| Description: | Business view to show commitments for a project. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
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'
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
| CMT_LINE_ID |
| COMMITMENT_NUMBER |
| EXPENDITURE_ITEM_DATE |
| RAW_COST |
| BURDENED_COST |
| QUANTITY |
| DESCRIPTION |
| COMMITMENT_LINE_NUMBER |
| COMMITMENT_CREATION_DATE |
| COMMITMENT_APPROVED_DATE |
| COMMITMENT_PROMISED_DATE |
| COMMITMENT_NEED_BY_DATE |
| PROJECT_ID |
| PROJECT_NAME |
| PROJECT_NUMBER |
| TASK_ID |
| TASK_NAME |
| TASK_NUMBER |
| EXPENDITURE_TYPE |
| ORG_ID |
| ORGANIZATION_ID |
| ORGANIZATION_NAME |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
| RECEIPT_CURRENCY_CODE |
| RECEIPT_CURRENCY_AMOUNT |
| RECEIPT_EXCHANGE_RATE |
| DENOM_CURRENCY_CODE |
| DENOM_RAW_COST |
| DENOM_BURDENED_COST |
| ACCT_CURRENCY_CODE |
| ACCT_RAW_COST |
| ACCT_BURDENED_COST |
| ACCT_RATE_DATE |
| ACCT_RATE_TYPE |
| USER_ACCT_RATE_TYPE |
| ACCT_EXCHANGE_RATE |
| PROJECT_CURRENCY_CODE |
| PROJECT_RATE_DATE |
| PROJECT_RATE_TYPE |
| USER_PROJECT_RATE_TYPE |
| PROJECT_EXCHANGE_RATE |
| "_LA:COMMITMENT_SOURCE" |
| "_LA:LINE_TYPE" |
| "_LA:APPROVED_FLAG" |
| Name |