Query for Projects, Subledger and General Ledger
Summary:
Query for Projects, Subledger and General Ledger
Content (required):
Hello
I was wondering if you can share with me any Query for Projects, Subledger and General Ledger.
I just have the basic information i.e.
Thanks for your help
Regards
1. SELECT FROM PJF_PROJECTS_ALL_B WHERE SEGMENT1='proj_nr';
-- note the project_id;
2. SELECT *
FROM PJC_COST_DIST_LINES_ALL D,
PJF_PROJECTS_ALL_B P
WHERE D.PROJECT_ID =P.PROJECT_ID
and PROJECT_ID= ... replace the project_id...
AND ROWNUM<=1
ORDER BY D.CREATION_DATE DESC
-- find the expenditure_item_id, ie:10000
3. select * from xla_distribution_links where application_id = 10036 and event_id in
0