SELECT ppa.segment1 "Project Number", ppa.NAME "Project Name",
pt.task_name "Task Name", pei.expenditure_type "Expenditure Type",
pei.expenditure_item_date "Expenditure Item Date", pv.amount "Amount",
gc1.concatenated_segments "Credit ",
gc2.concatenated_segments "Debit "
FROM pa_projects_all ppa,
pa_tasks pt,
pa_expenditure_items_all pei,
pa_cost_distribution_lines_all pv,
gl_code_combinations_kfv gc1,
gl_code_combinations_kfv gc2,
hr_organization_units hr
WHERE ppa.project_id = pt.project_id
AND ppa.project_id = pv.project_id
AND pv.task_id = pt.task_id
AND pei.expenditure_item_id = pv.expenditure_item_id
AND ppa.project_id = pei.project_id
AND pt.task_id = pei.task_id
AND pv.cr_code_combination_id = gc1.code_combination_id
AND pv.dr_code_combination_id = gc2.code_combination_id
AND ppa.carrying_out_organization_id = hr.organization_id
Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
ReplyDelete