VIEW: APPS.PABV_EXPENDITURE_ITEMS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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