DBA Data[Home] [Help]

APPS.PJI_FM_EXTR dependencies on PA_DRAFT_INVOICES_ALL

Line 2942: , pa_draft_invoices_all dinv

2938: FROM
2939: pji_fm_proj_batch_map bat
2940: , pa_projects_all ppa
2941: , pa_project_types_all ptyp
2942: , pa_draft_invoices_all dinv
2943: , pa_agreements_all agr
2944: WHERE
2945: l_extraction_type = 'FULL'
2946: and bat.worker_id = p_worker_id

Line 3003: , pa_draft_invoices_all dinv

2999: -- NOTE for cost we will consider everything (external + internal)
3000: -- this skews the margin but ...
3001: FROM
3002: pji_fm_proj_batch_map bat
3003: , pa_draft_invoices_all dinv
3004: , pa_projects_all ppa
3005: , pa_project_types_all ptyp
3006: , pa_agreements_all agr
3007: WHERE

Line 3066: , pa_draft_invoices_all dinv

3062: -- NOTE for cost we will consider everything (external + internal)
3063: -- this skews the margin but ...
3064: FROM
3065: pji_fm_proj_batch_map bat
3066: , pa_draft_invoices_all dinv
3067: , pa_projects_all ppa
3068: , pa_project_types_all ptyp
3069: , pa_agreements_all agr
3070: WHERE

Line 3133: , pa_draft_invoices_all dinv

3129: FROM
3130: pji_fm_proj_batch_map bat
3131: , pa_projects_all ppa
3132: , pa_project_types_all ptyp
3133: , pa_draft_invoices_all dinv
3134: , pa_agreements_all agr
3135: WHERE
3136: l_extraction_type = 'PARTIAL'
3137: and bat.worker_id = p_worker_id

Line 3180: UPDATE pa_draft_invoices_all dinv

3176: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_EXTR.MARK_EXTRACTED_DINV_ROWS(p_worker_id);')) then
3177: return;
3178: end if;
3179:
3180: UPDATE pa_draft_invoices_all dinv
3181: SET dinv.pji_summarized_flag = 'O'
3182: -- later the flag is updated to null for those invoices that are closed
3183: WHERE dinv.rowid in (select row_id
3184: from PJI_FM_EXTR_DINVC

Line 3546: pa_draft_invoices_all part

3542: , max(ar.actual_date_closed) actual_date_closed
3543: , trx.bill_to_customer_id customer_id
3544: , part.pji_summarized_flag
3545: FROM
3546: pa_draft_invoices_all part
3547: , pji_fm_proj_batch_map bat
3548: , ra_customer_trx_all trx
3549: , ar_payment_schedules_all ar
3550: WHERE

Line 3674: UPDATE pa_draft_invoices_all dinv

3670: if (sql%rowcount <> 0) then
3671:
3672: commit;
3673:
3674: UPDATE pa_draft_invoices_all dinv
3675: SET dinv.pji_summarized_flag = NULL
3676: WHERE dinv.rowid in (SELECT /*+ cardinality(ar, 1) */
3677: ar.row_id
3678: FROM PJI_FM_EXTR_ARINV ar