VIEW: APPS.PAFV_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, 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

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
, 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