eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_FM_EXTR dependencies on PA_PROJECT_CUSTOMERS

Line 60: ,pa_project_customers cust

56: ,ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) BATCH_ID
57: FROM pji_fm_proj_batch_map bat
58: ,pa_project_fundings pf
59: ,pa_agreements_all agr
60: ,pa_project_customers cust
61: WHERE l_extraction_type = 'FULL'
62: AND pf.agreement_id = agr.agreement_id
63: AND pf.project_id = bat.project_id
64: AND bat.worker_id = p_worker_id

Line 92: ,pa_project_customers cust

88: ,ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) BATCH_ID
89: FROM pji_fm_proj_batch_map bat
90: ,pa_project_fundings pf
91: ,pa_agreements_all agr
92: ,pa_project_customers cust
93: WHERE l_extraction_type = 'INCREMENTAL'
94: AND pf.agreement_id = agr.agreement_id
95: AND pf.project_id = bat.project_id
96: AND bat.worker_id = p_worker_id

Line 123: ,pa_project_customers cust

119: ,ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) BATCH_ID
120: FROM pji_fm_proj_batch_map bat
121: ,pa_project_fundings pf
122: ,pa_agreements_all agr
123: ,pa_project_customers cust
124: WHERE l_extraction_type = 'INCREMENTAL'
125: AND pf.agreement_id = agr.agreement_id
126: AND pf.project_id = bat.project_id
127: AND bat.worker_id = p_worker_id

Line 157: ,pa_project_customers cust

153: ,ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) BATCH_ID
154: FROM pji_fm_proj_batch_map bat
155: ,pa_project_fundings pf
156: ,pa_agreements_all agr
157: ,pa_project_customers cust
158: WHERE l_extraction_type = 'PARTIAL'
159: AND pf.agreement_id = agr.agreement_id
160: AND pf.project_id = bat.project_id
161: AND bat.worker_id = p_worker_id

Line 1266: , pa_project_customers cust

1262: , to_number(null) AS QUANTITY
1263: , to_number(null) AS BILL_QUANTITY
1264: From PJI_FM_EXTR_DREVN drev
1265: , pa_agreements_all ag
1266: , pa_project_customers cust
1267: , pa_cust_rev_dist_lines_all crdl
1268: Where 1 = 1
1269: And drev.worker_id = p_worker_id
1270: And drev.project_id = crdl.project_id

Line 1498: , pa_project_customers cust

1494: , to_number(null) AS EOU_UER
1495: , to_number(null) AS QUANTITY
1496: , to_number(null) AS BILL_QUANTITY
1497: From pa_agreements_all ag
1498: , pa_project_customers cust
1499: , pa_events ev
1500: , pa_event_types evt
1501: , PJI_FM_EXTR_DREVN drev
1502: , pa_cust_event_rdl_all erdl

Line 1735: , pa_project_customers cust

1731: , cust.customer_id
1732: FROM
1733: PJI_FM_EXTR_DREVN drev
1734: , pa_agreements_all ag
1735: , pa_project_customers cust
1736: , pa_cust_rev_dist_lines_all crdl
1737: WHERE
1738: drev.worker_id = p_worker_id
1739: and drev.project_id = crdl.project_id

Line 1829: , pa_project_customers cust

1825: , drev.gl_period_name gl_period_name
1826: FROM
1827: PJI_FM_EXTR_DREVN drev
1828: , pa_agreements_all ag
1829: , pa_project_customers cust
1830: , pa_events ev
1831: , pa_event_types evt
1832: , pa_cust_event_rdl_all erdl
1833: WHERE