View: PAFV_EXPENDITURE_ITEMS

Product:	PA - Projects
Description:	Business view to show information about the expenditure items entered.
Implementation/DBA Data:	APPS.PAFV_EXPENDITURE_ITEMS

View Text

SELECT PEI.EXPENDITURE_ITEM_ID
, PEI.QUANTITY
, PEI.RAW_COST
, PEI.RAW_REVENUE
, PEI.BURDEN_COST
, PEI.EXPENDITURE_ITEM_DATE
, '_LA:PEI.BILLABLE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PEI.ACCRUED_REVENUE
, PEI.ACCRUAL_RATE
, '_LA:PEI.BILL_HOLD_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:PEI.COST_DISTRIBUTED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:PEI.REVENUE_DISTRIBUTED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PEI.RAW_COST_RATE
, PEI.BURDEN_COST_RATE
, PEI.BILL_AMOUNT
, PEI.BILL_RATE
, PEI.FORECAST_REVENUE
, '_LA:PEI.REV_DIST_REJECTION_CODE:PA_LOOKUPS:REVENUE DIST REJECTION CODE:MEANING'
, PEI.BILL_JOB_BILLING_TITLE
, PEI.BILL_EMPLOYEE_BILLING_TITLE
, '_LA:PEI.NET_ZERO_ADJUSTMENT_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:PEI.CONVERTED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_DF:PA:PA_EXPENDITURE_ITEMS_DESC_FLEX:PEI'
, PEI.EXPENDITURE_TYPE
, PET.DESCRIPTION
, PEI.TRANSACTION_SOURCE
, PTS.DESCRIPTION
, PEI.NON_LABOR_RESOURCE
, PEI.ORGANIZATION_ID
, POU.NAME
, PEI.EXPENDITURE_ID
, PEA.DESCRIPTION
, PEI.EVENT_TASK_ID
, PEI.EVENT_NUM
, PE.DESCRIPTION
, PEI.TASK_ID
, PT.TASK_NAME
, PT.TASK_NUMBER
, PT.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PEI.ORG_ID /* OPERATING UNIT */
, TL.NAME
, PEI.LAST_UPDATE_DATE
, PEI.LAST_UPDATED_BY
, PEI.CREATION_DATE
, PEI.CREATED_BY
, PEI.DENOM_CURRENCY_CODE
, PEI.DENOM_RAW_COST
, PEI.DENOM_BURDENED_COST
, PEI.ACCT_CURRENCY_CODE
, PEI.ACCT_RAW_COST
, PEI.ACCT_BURDENED_COST
, PEI.ACCT_RATE_TYPE
, PCT.USER_CONVERSION_TYPE
, PEI.ACCT_RATE_DATE
, PEI.ACCT_EXCHANGE_RATE
, PEI.PROJECT_CURRENCY_CODE
, PEI.PROJECT_RATE_TYPE
, PCT1.USER_CONVERSION_TYPE
, PEI.PROJECT_RATE_DATE
, PEI.PROJECT_EXCHANGE_RATE
, PEI.RECEIPT_CURRENCY_CODE
, PEI.RECEIPT_CURRENCY_AMOUNT
, PEI.RECEIPT_EXCHANGE_RATE
, PEI.ADJUSTED_EXPENDITURE_ITEM_ID
, PEI.TRANSFERRED_FROM_EXP_ITEM_ID
FROM PA_EXPENDITURE_ITEMS_ALL PEI
, PA_PROJECTS_ALL PPA
, PA_EXPENDITURES_ALL PEA
, PA_EVENTS PE
, PA_NON_LABOR_RESOURCE_ORGS PNLR
, PA_TRANSACTION_SOURCES PTS
, PA_EXPENDITURE_TYPES PET
, PA_TASKS PT
, PER_ALL_ORGANIZATION_UNITS POU
, HR_ALL_ORGANIZATION_UNITS HRO
, HR_ALL_ORGANIZATION_UNITS_TL TL
, PA_CONVERSION_TYPES_V PCT
, PA_CONVERSION_TYPES_V PCT1
WHERE PEI.TASK_ID = PT.TASK_ID
AND PT.PROJECT_ID = PPA.PROJECT_ID
AND PEI.EXPENDITURE_ID = PEA.EXPENDITURE_ID
AND PEI.EVENT_TASK_ID = PE.TASK_ID(+)
AND PEI.EVENT_NUM = PE.EVENT_NUM(+)
AND PEI.PROJECT_ID = PE.PROJECT_ID(+)
AND PEI.NON_LABOR_RESOURCE = PNLR.NON_LABOR_RESOURCE(+)
AND PEI.ORGANIZATION_ID = PNLR.ORGANIZATION_ID(+)
AND PNLR.ORGANIZATION_ID = POU.ORGANIZATION_ID(+)
AND PEI.TRANSACTION_SOURCE = PTS.TRANSACTION_SOURCE(+)
AND PEI.EXPENDITURE_TYPE = PET.EXPENDITURE_TYPE
AND '_SEC:PEI.ORG_ID' IS NOT NULL
AND PEI.ORG_ID=HRO.ORGANIZATION_ID (+)
AND PEI.ORG_ID=TL.ORGANIZATION_ID (+)
AND TL.LANGUAGE = USERENV('LANG')
AND PEI.ACCT_RATE_TYPE = PCT.CONVERSION_TYPE(+)
AND PEI.PROJECT_RATE_TYPE = PCT1.CONVERSION_TYPE(+) WITH READ ONLY

Columns