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_DRAFT_INVOICES_ALL

Line 2929: , pa_draft_invoices_all dinv

2925: FROM
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

Line 2990: , pa_draft_invoices_all dinv

2986: -- NOTE for cost we will consider everything (external + internal)
2987: -- this skews the margin but ...
2988: FROM
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

Line 3053: , pa_draft_invoices_all dinv

3049: -- NOTE for cost we will consider everything (external + internal)
3050: -- this skews the margin but ...
3051: FROM
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

Line 3120: , pa_draft_invoices_all dinv

3116: FROM
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

Line 3167: UPDATE pa_draft_invoices_all dinv

3163: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_DINV_ROWS(p_worker_id);')) then
3164: return;
3165: end if;
3166:
3167: UPDATE pa_draft_invoices_all dinv
3168: SET dinv.pji_summarized_flag = 'O'
3169: -- later the flag is updated to null for those invoices that are closed
3170: WHERE dinv.rowid in (select row_id
3171: from PJI_FM_EXTR_DINVC

Line 3533: pa_draft_invoices_all part

3529: , max(ar.actual_date_closed) actual_date_closed
3530: , trx.bill_to_customer_id customer_id
3531: , part.pji_summarized_flag
3532: FROM
3533: pa_draft_invoices_all part
3534: , pji_fm_proj_batch_map bat
3535: , ra_customer_trx_all trx
3536: , ar_payment_schedules_all ar
3537: WHERE

Line 3661: UPDATE pa_draft_invoices_all dinv

3657: if (sql%rowcount <> 0) then
3658:
3659: commit;
3660:
3661: UPDATE pa_draft_invoices_all dinv
3662: SET dinv.pji_summarized_flag = NULL
3663: WHERE dinv.rowid in (SELECT /*+ cardinality(ar, 1) */
3664: ar.row_id
3665: FROM PJI_FM_EXTR_ARINV ar