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_AGREEMENTS_ALL

Line 59: ,pa_agreements_all agr

55: ,pf.rowid ROW_ID
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

Line 91: ,pa_agreements_all agr

87: ,pf.rowid ROW_ID
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

Line 122: ,pa_agreements_all agr

118: ,pf.rowid ROW_ID
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

Line 156: ,pa_agreements_all agr

152: ,pf.rowid ROW_ID
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

Line 448: , pa_agreements_all agr

444: , ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) batch_id
445: FROM
446: pji_fm_proj_batch_map bat
447: , pa_draft_revenues_all drv
448: , pa_agreements_all agr
449: WHERE
450: l_extraction_type = 'FULL'
451: and bat.worker_id = p_worker_id
452: and bat.project_id = drv.project_id

Line 489: , pa_agreements_all agr

485: , ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) batch_id
486: FROM
487: pji_fm_proj_batch_map bat
488: , pa_draft_revenues_all drv
489: , pa_agreements_all agr
490: WHERE
491: l_extraction_type = 'INCREMENTAL'
492: and bat.worker_id = p_worker_id
493: and bat.project_id = drv.project_id

Line 527: , pa_agreements_all agr

523: , ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) batch_id
524: FROM
525: pji_fm_proj_batch_map bat
526: , pa_draft_revenues_all drv
527: , pa_agreements_all agr
528: WHERE
529: l_extraction_type = 'INCREMENTAL'
530: and bat.worker_id = p_worker_id
531: and bat.project_id = drv.project_id

Line 566: , pa_agreements_all agr

562: , ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) batch_id
563: FROM
564: pji_fm_proj_batch_map bat
565: , pa_draft_revenues_all drv
566: , pa_agreements_all agr
567: WHERE
568: l_extraction_type = 'PARTIAL'
569: and bat.worker_id = p_worker_id
570: and bat.project_id = drv.project_id

Line 607: , pa_agreements_all agr

603: , ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) batch_id
604: FROM
605: pa_pji_proj_events_log log
606: , pji_fm_proj_batch_map bat
607: , pa_agreements_all agr
608: /* Note:
609: * The tables below are not needed if Billing Team
610: * populates the PA and GL period_names while
611: * inserting records into the log table

Line 1265: , pa_agreements_all ag

1261: , to_number(null) AS EOU_UER
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

Line 1497: From pa_agreements_all ag

1493: , to_number(null) AS EOU_UBR
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

Line 1734: , pa_agreements_all ag

1730: , cust.bill_another_project_flag
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

Line 1828: , pa_agreements_all ag

1824: , drev.gl_date gl_date
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

Line 2930: , pa_agreements_all agr

2926: pji_fm_proj_batch_map bat
2927: , pa_projects_all ppa
2928: , pa_project_types_all ptyp
2929: , pa_draft_invoices_all dinv
2930: , pa_agreements_all agr
2931: WHERE
2932: l_extraction_type = 'FULL'
2933: and bat.worker_id = p_worker_id
2934: and ppa.project_id = bat.project_id

Line 2993: , pa_agreements_all agr

2989: pji_fm_proj_batch_map bat
2990: , pa_draft_invoices_all dinv
2991: , pa_projects_all ppa
2992: , pa_project_types_all ptyp
2993: , pa_agreements_all agr
2994: WHERE
2995: l_extraction_type = 'INCREMENTAL'
2996: and bat.worker_id = p_worker_id
2997: and bat.project_id = dinv.project_id

Line 3056: , pa_agreements_all agr

3052: pji_fm_proj_batch_map bat
3053: , pa_draft_invoices_all dinv
3054: , pa_projects_all ppa
3055: , pa_project_types_all ptyp
3056: , pa_agreements_all agr
3057: WHERE
3058: l_extraction_type = 'INCREMENTAL'
3059: and bat.worker_id = p_worker_id
3060: and ppa.project_id = bat.project_id

Line 3121: , pa_agreements_all agr

3117: pji_fm_proj_batch_map bat
3118: , pa_projects_all ppa
3119: , pa_project_types_all ptyp
3120: , pa_draft_invoices_all dinv
3121: , pa_agreements_all agr
3122: WHERE
3123: l_extraction_type = 'PARTIAL'
3124: and bat.worker_id = p_worker_id
3125: and ppa.project_id = bat.project_id