[Home] [Help]
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'
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'
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'
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'
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'
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'
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'
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'
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
1142: , CnR.Quantity AS QUANTITY
1143: , CnR.Bill_Quantity AS BILL_QUANTITY
1144: , CnR.CBS_ELEMENT_ID AS CBS_ELEMENT_ID /* Added for CBS Changes */
1145: FROM
1146: pji_fm_proj_batch_map map,
1147: (
1148: Select /*+ FULL(cdl) PARALLEL(cdl) */
1149: 'COST' AS C_or_R
1150: , cdl.Project_ID AS PROJECT_ID
1635: , bat.project_organization_id
1636: , bat.project_type_class
1637: , cdl.pji_summarized_flag
1638: FROM
1639: pji_fm_proj_batch_map bat
1640: , pa_cost_distribution_lines_all cdl
1641: WHERE
1642: bat.worker_id = p_worker_id
1643: and cdl.project_id = bat.project_id
1656: , bat.project_organization_id
1657: , bat.project_type_class
1658: , cdl.pji_summarized_flag
1659: FROM
1660: pji_fm_proj_batch_map bat
1661: , pa_cost_distribution_lines_all cdl
1662: WHERE
1663: bat.worker_id = p_worker_id
1664: and cdl.project_id = bat.project_id
2935: -- need to consider only the external invoices
2936: -- NOTE for cost we will consider everything (external + internal)
2937: -- this skews the margin but ...
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
2998: -- need to consider only the external invoices
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
3061: -- need to consider only the external invoices
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
3126: -- need to consider only the external invoices
3127: -- NOTE for cost we will consider everything (external + internal)
3128: -- this skews the margin but ...
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
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
3551: bat.worker_id = p_worker_id