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 1272: , pa_project_customers cust

1268: , to_number(null) AS BILL_QUANTITY
1269: , -1 AS CBS_ELEMENT_ID /* Added for CBS Changes */
1270: From PJI_FM_EXTR_DREVN drev
1271: , pa_agreements_all ag
1272: , pa_project_customers cust
1273: , pa_cust_rev_dist_lines_all crdl
1274: Where 1 = 1
1275: And drev.worker_id = p_worker_id
1276: And drev.project_id = crdl.project_id

Line 1505: , pa_project_customers cust

1501: , to_number(null) AS EOU_UER
1502: , to_number(null) AS QUANTITY
1503: , to_number(null) AS BILL_QUANTITY
1504: From pa_agreements_all ag
1505: , pa_project_customers cust
1506: , pa_events ev
1507: , pa_event_types evt
1508: , PJI_FM_EXTR_DREVN drev
1509: , pa_cust_event_rdl_all erdl

Line 1742: , pa_project_customers cust

1738: , cust.customer_id
1739: FROM
1740: PJI_FM_EXTR_DREVN drev
1741: , pa_agreements_all ag
1742: , pa_project_customers cust
1743: , pa_cust_rev_dist_lines_all crdl
1744: WHERE
1745: drev.worker_id = p_worker_id
1746: and drev.project_id = crdl.project_id

Line 1836: , pa_project_customers cust

1832: , drev.gl_period_name gl_period_name
1833: FROM
1834: PJI_FM_EXTR_DREVN drev
1835: , pa_agreements_all ag
1836: , pa_project_customers cust
1837: , pa_cust_event_rdl_all erdl /* Changed the order for bug 8668173 */
1838: , pa_events ev
1839: , pa_event_types evt
1840: WHERE