View: PABV_EXPENDITURE_ITEMS

Product:	PA - Projects
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PABV_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
, PEI.TRANSACTION_SOURCE
, PEI.NON_LABOR_RESOURCE
, PEI.ORGANIZATION_ID
, PEI.EXPENDITURE_ID
, PEI.EVENT_TASK_ID
, PEI.EVENT_NUM
, PEI.TASK_ID
, PT.PROJECT_ID
, PEI.ORG_ID /* OPERATING UNIT */
, 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
, PEI.ACCT_RATE_DATE
, PEI.ACCT_EXCHANGE_RATE
, PEI.PROJECT_CURRENCY_CODE
, PEI.PROJECT_RATE_TYPE
, PEI.PROJECT_RATE_DATE
, PEI.PROJECT_EXCHANGE_RATE
, PEI.RECEIPT_CURRENCY_CODE
, PEI.RECEIPT_CURRENCY_AMOUNT
, PEI.RECEIPT_EXCHANGE_RATE
FROM PA_EXPENDITURE_ITEMS_ALL PEI
, PA_TASKS PT
WHERE PEI.TASK_ID=PT.TASK_ID
AND '_SEC:PEI.ORG_ID' IS NOT NULL WITH READ ONLY

Columns