You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need Join between projects and item tables in fusion

in Reporting and Analytics for SCM

Hi Team,

I am using below query to fetch the data for Project Budget details. I am unable to fetch the join between project and egp_system_items_b tables.If any one having an idea on this, please leave a comment here

SELECT
ppa.ORG_ID,
ptv.TASK_NUMBER,
ptv.TASK_NAME,
pei.quantity,
ppa.segment1,
ppv.version_number,
ppv.pfc_raw_cost,
ppv.pfc_revenue,
ppv.version_name
FROM
pjf_projects_all_b ppa,
pjo_plan_versions_vl ppv,
pjf_tasks_v ptv,
PJC_EXP_ITEMS_ALL pei,
--pjf_resource_classes_tl pjrc,
PJF_RESOURCE_CLASSES_B prc,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!