APPS.PJI_FM_EXTR dependencies on PJI_FM_PROJ_BATCH_MAP

Line 57: FROM pji_fm_proj_batch_map bat

53: ,pf.project_allocated_amount PRJ_ALLOCATED_AMOUNT
54: ,pf.pji_summarized_flag PJI_SUMMARIZED_FLAG
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'

Line 89: FROM pji_fm_proj_batch_map bat

85: ,pf.project_allocated_amount PRJ_ALLOCATED_AMOUNT
86: ,pf.pji_summarized_flag PJI_SUMMARIZED_FLAG
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'

Line 120: FROM pji_fm_proj_batch_map bat

116: ,pf.project_allocated_amount PRJ_ALLOCATED_AMOUNT
117: ,pf.pji_summarized_flag PJI_SUMMARIZED_FLAG
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'

Line 154: FROM pji_fm_proj_batch_map bat

150: ,pf.project_allocated_amount PRJ_ALLOCATED_AMOUNT
151: ,pf.pji_summarized_flag PJI_SUMMARIZED_FLAG
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'

Line 446: pji_fm_proj_batch_map bat

442: , drv.pji_summarized_flag PJI_SUMMARIZED_FLAG
443: , agr.customer_id customer_id
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'

Line 487: pji_fm_proj_batch_map bat

483: , drv.pji_summarized_flag PJI_SUMMARIZED_FLAG
484: , agr.customer_id customer_id
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'

Line 525: pji_fm_proj_batch_map bat

521: , drv.pji_summarized_flag PJI_SUMMARIZED_FLAG
522: , agr.customer_id customer_id
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'

Line 564: pji_fm_proj_batch_map bat

560: , drv.pji_summarized_flag PJI_SUMMARIZED_FLAG
561: , agr.customer_id customer_id
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'

Line 606: , pji_fm_proj_batch_map bat

602: , agr.customer_id customer_id
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

Line 1143: pji_fm_proj_batch_map map,

1139: , CnR.Eou_Uer AS EOU_UER
1140: , CnR.Quantity AS QUANTITY
1141: , CnR.Bill_Quantity AS BILL_QUANTITY
1142: FROM
1143: pji_fm_proj_batch_map map,
1144: (
1145: Select /*+ FULL(cdl) PARALLEL(cdl) */
1146: 'COST' AS C_or_R
1147: , cdl.Project_ID AS PROJECT_ID

Line 1632: pji_fm_proj_batch_map bat

1628: , bat.project_organization_id
1629: , bat.project_type_class
1630: , cdl.pji_summarized_flag
1631: FROM
1632: pji_fm_proj_batch_map bat
1633: , pa_cost_distribution_lines_all cdl
1634: WHERE
1635: bat.worker_id = p_worker_id
1636: and cdl.project_id = bat.project_id

Line 1653: pji_fm_proj_batch_map bat

1649: , bat.project_organization_id
1650: , bat.project_type_class
1651: , cdl.pji_summarized_flag
1652: FROM
1653: pji_fm_proj_batch_map bat
1654: , pa_cost_distribution_lines_all cdl
1655: WHERE
1656: bat.worker_id = p_worker_id
1657: and cdl.project_id = bat.project_id

Line 2926: pji_fm_proj_batch_map bat

2922: -- need to consider only the external invoices
2923: -- NOTE for cost we will consider everything (external + internal)
2924: -- this skews the margin but ...
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

Line 2989: pji_fm_proj_batch_map bat

2985: -- need to consider only the external invoices
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

Line 3052: pji_fm_proj_batch_map bat

3048: -- need to consider only the external invoices
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

Line 3117: pji_fm_proj_batch_map bat

3113: -- need to consider only the external invoices
3114: -- NOTE for cost we will consider everything (external + internal)
3115: -- this skews the margin but ...
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

Line 3534: , pji_fm_proj_batch_map bat

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
3538: bat.worker_id = p_worker_id