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.MSC_CL_WIP_PULL dependencies on MSC_UTIL

Line 16: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;

12: v_temp_sql3 VARCHAR2(1000);
13: v_temp_sql4 VARCHAR2(1000);
14:
15: -- NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
16: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
17:
18: v_once_per_org varchar2(10) := 'NOTDONE';
19:
20: -----OSFM---------

Line 26: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN

22: PROCEDURE LOAD_OPER_NETWORKS IS
23: v_get_apps_ver number;
24: BEGIN
25:
26: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
27:
28: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
29:
30:

Line 28: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

24: BEGIN
25:
26: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
27:
28: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
29:
30:
31: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPER_NETWORKS';
32: MSC_CL_PULL.v_view_name := 'MRP_AD_OPER_NETWORKS_V';

Line 40: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

36:
37:
38: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
39:
40: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
41: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
42: ELSE
43: v_temp_sql := NULL;
44: END IF;

Line 41: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

37:
38: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
39:
40: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
41: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
42: ELSE
43: v_temp_sql := NULL;
44: END IF;
45:

Line 149: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

145: ||' x.TO_SEQ_NUM, '
146: ||' :v_refresh_id,'
147: ||' :v_instance_id '
148: ||' from MRP_AP_OPER_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
149: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
150: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
151: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
152: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
153: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn

Line 165: End if; /* MSC_UTIL.G_APPS115 */

161: -- extract_effectivities
162:
163: End if; /* v_once_per_org */
164:
165: End if; /* MSC_UTIL.G_APPS115 */
166: END IF; -- MSC_CL_PULL.BOM_ENABLED
167:
168: END LOAD_OPER_NETWORKS;
169:

Line 184: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN

180: v_temp_sql_stmt2 varchar2(10240) := null;
181: v_temp_sql2 varchar2(10240) := null;
182: BEGIN
183:
184: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN
185:
186: --=================== Net Change Mode: Delete ==================
187:
188: lv_op_seq_num := 'x.OPERATION_SEQ_NUM, ';

Line 189: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

185:
186: --=================== Net Change Mode: Delete ==================
187:
188: lv_op_seq_num := 'x.OPERATION_SEQ_NUM, ';
189: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
190:
191:
192: select LBJ_DETAILS into lv_lbj_details from msc_apps_instances
193: where instance_id = MSC_CL_PULL.v_instance_id ;

Line 206: IF ((MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN

202:
203:
204: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
205:
206: IF ((MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN
207:
208: -- For Demands from non depo orgs
209:
210: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';

Line 241: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_non_depot_org_str ;

237: ||' OR DECODE( :v_mps_consume_profile_value,'
238: ||' 1, x.MPS_FLAG,'
239: ||' x.NMPS_FLAG)= 1 )'
240: ||' AND x.RN> :v_lrn '
241: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_non_depot_org_str ;
242:
243: -- For Demands from depot repair orgs
244:
245: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';

Line 276: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_depot_org_str ;

272: ||' OR DECODE( :v_mps_consume_profile_value,'
273: ||' 1, x.MPS_FLAG,'
274: ||' x.NMPS_FLAG)= 1 )'
275: ||' AND x.RN> :v_lrn '
276: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_depot_org_str ;
277:
278: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
279: MSC_CL_PULL.v_instance_id,
280: MSC_CL_PULL.v_mps_consume_profile_value,

Line 297: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

293:
294: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
295: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_COMP_DEMANDS_V';
296:
297: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
298: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
299: ELSE
300: v_temp_sql := NULL;
301: END IF;

Line 298: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

294: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
295: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_COMP_DEMANDS_V';
296:
297: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
298: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
299: ELSE
300: v_temp_sql := NULL;
301: END IF;
302:

Line 349: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

345:
346: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
347: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_FLOW_DEMANDS_V';
348:
349: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
350: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
351: ELSE
352: v_temp_sql := NULL;
353: END IF;

Line 350: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

346: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
347: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_FLOW_DEMANDS_V';
348:
349: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
350: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
351: ELSE
352: v_temp_sql := NULL;
353: END IF;
354:

Line 385: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

381:
382: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
383: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_COMP_DEMANDS_V';
384:
385: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
386: v_temp_sql := 'x.quantity_per_assembly,x.asset_item_id,x.asset_serial_number,x.basis_type,x.component_yield_factor, '; /* ds change */
387:
388: ELSE
389:

Line 430: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

426: ||' 2,'
427: ||' :v_refresh_id,'
428: ||' :v_instance_id'
429: ||' from MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
430: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
431: ||' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')'
432: */
433: ||' UNION '
434: ||' select'

Line 462: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

458: || v_temp_sql
459: ||' :v_refresh_id,'
460: ||' :v_instance_id'
461: ||' from MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
462: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
463: ||' AND x.NEW_REQUIRED_QUANTITY > 0'
464: --||' AND DECODE(:V_COLLECT_COMPLETED_JOBS,'
465: --||' 2 ,x.coll_completed_qty_ind,'
466: --||' 1) >0'

Line 500: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

496: || v_temp_sql
497: ||' :v_refresh_id,'
498: ||' :v_instance_id'
499: ||' from MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
500: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
501: ||' AND x.NEW_REQUIRED_QUANTITY > 0'
502: --||' AND DECODE(:V_COLLECT_COMPLETED_JOBS,'
503: --||' 2 ,x.coll_completed_qty_ind,'
504: --||' 1) >0'

Line 586: if (MSC_UTIL.G_COLLECT_SRP_DATA='N' or MSC_CL_PULL.v_lrnn<> -1 or MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS120) Then /* Build v_sql_stmt based on the MSC_SRP_ENABLED profile Bug 5909379 */

582: ||' AND x.NEW_REQUIRED_QUANTITY > 0'
583: || v_union_sql ;
584:
585:
586: if (MSC_UTIL.G_COLLECT_SRP_DATA='N' or MSC_CL_PULL.v_lrnn<> -1 or MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS120) Then /* Build v_sql_stmt based on the MSC_SRP_ENABLED profile Bug 5909379 */
587:
588: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
589: lv_new_view_name := 'MRP_AP_WIP_COMP_DEMANDS_V';
590: lv_new_org_string := MSC_UTIL.v_in_org_str;

Line 590: lv_new_org_string := MSC_UTIL.v_in_org_str;

586: if (MSC_UTIL.G_COLLECT_SRP_DATA='N' or MSC_CL_PULL.v_lrnn<> -1 or MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS120) Then /* Build v_sql_stmt based on the MSC_SRP_ENABLED profile Bug 5909379 */
587:
588: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
589: lv_new_view_name := 'MRP_AP_WIP_COMP_DEMANDS_V';
590: lv_new_org_string := MSC_UTIL.v_in_org_str;
591:
592: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
593: ||' WHERE x.ORGANIZATION_ID '||lv_new_org_string||v_temp_sql;
594: else -- Profile MSC_UTIL.G_COLLECT_SRP_DATA = 'Y'

Line 594: else -- Profile MSC_UTIL.G_COLLECT_SRP_DATA = 'Y'

590: lv_new_org_string := MSC_UTIL.v_in_org_str;
591:
592: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
593: ||' WHERE x.ORGANIZATION_ID '||lv_new_org_string||v_temp_sql;
594: else -- Profile MSC_UTIL.G_COLLECT_SRP_DATA = 'Y'
595:
596:
597: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
598: lv_new_view_name := 'MRP_AP_NON_ERO_WIP_DEMAND_V';

Line 599: lv_new_org_string := MSC_UTIL.v_non_depot_org_str;

595:
596:
597: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
598: lv_new_view_name := 'MRP_AP_NON_ERO_WIP_DEMAND_V';
599: lv_new_org_string := MSC_UTIL.v_non_depot_org_str;
600:
601: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_ERO_WIP_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'
602: ||' WHERE x.ORGANIZATION_ID '||lv_new_org_string||v_temp_sql;
603: ---- Code for SRP when Repair Orders Entity is/not selected . Building v_sql_stmt

Line 620: if (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) Then

616: */
617:
618: ELSE
619:
620: if (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) Then
621: Begin
622:
623: EXECUTE IMMEDIATE v_temp_sql_stmt
624: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;

Line 630: lv_new_org_string := MSC_UTIL.v_depot_org_str;

626:
627: v_temp_sql_stmt := NULL;
628: MSC_CL_PULL.v_table_name := 'MSC_ST_DEMANDS';
629: lv_new_view_name := 'MRP_AP_NON_RO_WIP_DEMAND_V';
630: lv_new_org_string := MSC_UTIL.v_depot_org_str;
631:
632: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_RO_WIP_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'
633: ||' WHERE x.ORGANIZATION_ID '||lv_new_org_string||v_temp_sql;
634:

Line 645: end if; -- For SRP and MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120

641: ELSE
642: EXECUTE IMMEDIATE v_temp_sql_stmt
643: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;
644:
645: end if; -- For SRP and MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120
646: END IF;
647:
648: COMMIT;
649:

Line 659: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

655:
656: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
657: MSC_CL_PULL.v_view_name := 'MRP_AD_REPT_ITEM_DEMANDS_V';
658:
659: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
660: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
661: ELSE
662: v_temp_sql := NULL;
663: END IF;

Line 660: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

656: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
657: MSC_CL_PULL.v_view_name := 'MRP_AD_REPT_ITEM_DEMANDS_V';
658:
659: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
660: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
661: ELSE
662: v_temp_sql := NULL;
663: END IF;
664:

Line 725: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

721: ||' 2,'
722: ||' :v_refresh_id,'
723: ||' :v_instance_id'
724: ||' from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
725: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
726: ||' AND ( x.RN2 > :v_lrn )'
727: ||' UNION '
728: ||' select'
729: ||' x.INVENTORY_ITEM_ID,'

Line 748: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

744: ||' 2,'
745: ||' :v_refresh_id,'
746: ||' :v_instance_id'
747: ||' from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
748: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
749: ||' AND ( x.RN3 > :v_lrn )'
750: ||' UNION '
751: ||' select'
752: ||' x.INVENTORY_ITEM_ID,'

Line 771: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

767: ||' 2,'
768: ||' :v_refresh_id,'
769: ||' :v_instance_id'
770: ||' from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
771: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
772: ||' AND ( x.RN4 > :v_lrn )'
773: ||' UNION '
774: ||' select'
775: ||' x.INVENTORY_ITEM_ID,'

Line 794: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

790: ||' 2,'
791: ||' :v_refresh_id,'
792: ||' :v_instance_id'
793: ||' from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
794: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
795: ||' AND ( x.RN5 > :v_lrn )';
796:
797: ELSE
798:

Line 845: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

841: ||' 2,'
842: ||' :v_refresh_id,'
843: ||' :v_instance_id'
844: ||' from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
845: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
846: || v_union_sql;
847:
848:
849:

Line 887: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN

883: v_temp_sql_stmt2 VARCHAR2(10240) :=null;
884:
885: BEGIN
886:
887: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN
888:
889: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
890:
891: select LBJ_DETAILS into lv_lbj_details from msc_apps_instances

Line 889: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

885: BEGIN
886:
887: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN
888:
889: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
890:
891: select LBJ_DETAILS into lv_lbj_details from msc_apps_instances
892: where instance_id = MSC_CL_PULL.v_instance_id ;
893: END IF;

Line 923: IF ((MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN

919:
920: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
921:
922: -- =================== JOB/FLOW SCHEDULE =====================
923: IF ((MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN
924: -- Changed for Bug 6081537
925: -- Supplies from Non Depot orgs
926:
927: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

Line 950: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_non_depot_org_str;

946: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'
947: ||' x.WJS_NET_QTY_FLAG),'
948: ||' x.WJS_NET_QTY_FLAG)=1'
949: ||' AND x.RN> :v_lrn '
950: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_non_depot_org_str;
951:
952: -- Supplies from Depot repair orgs
953: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
954: MSC_CL_PULL.v_view_name := 'MRP_AD_NON_RO_WIP_JOB_SUPP_V';

Line 976: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_depot_org_str;

972: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'
973: ||' x.WJS_NET_QTY_FLAG),'
974: ||' x.WJS_NET_QTY_FLAG)=1'
975: ||' AND x.RN> :v_lrn '
976: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_depot_org_str;
977:
978:
979: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
980: MSC_CL_PULL.v_instance_id,

Line 984: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_NON_ERO_WIP_JOB_SUP_V = '|| SQL%ROWCOUNT);

980: MSC_CL_PULL.v_instance_id,
981: MSC_CL_PULL.v_mps_consume_profile_value,
982: MSC_CL_PULL.v_lrn;
983:
984: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_NON_ERO_WIP_JOB_SUP_V = '|| SQL%ROWCOUNT);
985: COMMIT;
986:
987: EXECUTE IMMEDIATE v_temp_sql2 USING MSC_CL_PULL.v_refresh_id,
988: MSC_CL_PULL.v_instance_id,

Line 992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_NON_ERO_WIP_JOB_SUP_V = '|| SQL%ROWCOUNT);

988: MSC_CL_PULL.v_instance_id,
989: MSC_CL_PULL.v_mps_consume_profile_value,
990: MSC_CL_PULL.v_lrn;
991:
992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_NON_ERO_WIP_JOB_SUP_V = '|| SQL%ROWCOUNT);
993: COMMIT;
994:
995: ELSE -- (SRP Profile is No)
996:

Line 1000: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

996:
997: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
998: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_JOB_SUPPLIES_V';
999:
1000: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1001: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1002: ELSE
1003: v_temp_sql := NULL;
1004: END IF;

Line 1001: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

997: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
998: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_JOB_SUPPLIES_V';
999:
1000: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1001: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1002: ELSE
1003: v_temp_sql := NULL;
1004: END IF;
1005:

Line 1033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_WIP_JOB_SUPPLIES_V = '|| SQL%ROWCOUNT);

1029: MSC_CL_PULL.v_instance_id,
1030: MSC_CL_PULL.v_mps_consume_profile_value,
1031: MSC_CL_PULL.v_lrn;
1032:
1033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_WIP_JOB_SUPPLIES_V = '|| SQL%ROWCOUNT);
1034: COMMIT;
1035: END IF;
1036: -- =================== JOB COMPONENTS =====================
1037:

Line 1043: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

1039: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_COMP_SUPPLIES_V';
1040:
1041: lv_op_seq_num := 'x.OPERATION_SEQ_NUM, ';
1042:
1043: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1044: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1045:
1046: if lv_lbj_details = 1 Then
1047: lv_op_seq_num := ' x.COPY_OP_SEQ_NUM, ';

Line 1044: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

1040:
1041: lv_op_seq_num := 'x.OPERATION_SEQ_NUM, ';
1042:
1043: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1044: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1045:
1046: if lv_lbj_details = 1 Then
1047: lv_op_seq_num := ' x.COPY_OP_SEQ_NUM, ';
1048: end if;

Line 1095: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

1091:
1092: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1093: MSC_CL_PULL.v_view_name := 'MRP_AD_REPT_ITEM_SUPPLIES_V';
1094:
1095: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1096: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1097: ELSE
1098: v_temp_sql := NULL;
1099: END IF;

Line 1096: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

1092: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1093: MSC_CL_PULL.v_view_name := 'MRP_AD_REPT_ITEM_SUPPLIES_V';
1094:
1095: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1096: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1097: ELSE
1098: v_temp_sql := NULL;
1099: END IF;
1100:

Line 1131: if MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then

1127: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_JOB_SUPPLIES_V';
1128:
1129:
1130: Begin
1131: if MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then
1132: if lv_lbj_details = 1 Then
1133: v_temp_sql := ' x.routing_reference_id,x.bom_reference_id,x.coproducts_supply,x.jd_operation_seq_num,'||
1134: 'x.JUMP_OP_SEQ_NUM,x.JOB_OP_SEQ_NUM, '||
1135: 'x.requested_start_date,x.requested_completion_date,x.schedule_priority,x.asset_item_id,x.asset_serial_number,' ||/* ds change */

Line 1151: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

1147:
1148: Begin
1149:
1150: --Bug#3419189
1151: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1152:
1153: v_temp_sql1 := ' x.wip_start_quantity,';
1154:
1155: ELSE

Line 1159: /*Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS115,

1155: ELSE
1156: v_temp_sql1 := ' NULL,';
1157: END IF;
1158:
1159: /*Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS115,
1160: ' DECODE( x.wip_job_type, 1,
1161: DECODE( :v_mps_consume_profile_value,
1162: 1, x.mps_wip_start_quantity,
1163: x.wip_start_quantity),

Line 1220: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1216: || v_temp_sql1
1217: ||' :v_refresh_id,'
1218: ||' :v_instance_id'
1219: ||' from MRP_AP_WIP_JOB_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
1220: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1221: /*Bug#4704457 ||' AND DECODE( x.wip_job_type,'
1222: ||' 1, DECODE( :v_mps_consume_profile_value,'
1223: ||' 1, x.mps_net_quantity,'
1224: ||' x.net_quantity),'

Line 1332: if (MSC_UTIL.G_COLLECT_SRP_DATA='N' or MSC_CL_PULL.v_lrnn<> -1 or MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS120) Then /* Build v_sql_stmt based on the MSC_SRP_ENABLED profile Bug 5909379 */

1328:
1329: v_temp_sql2:= v_sql_stmt; -- Added For Bug 5935273
1330: v_temp_sql := lv_qty_sql_temp|| v_union_sql;
1331:
1332: if (MSC_UTIL.G_COLLECT_SRP_DATA='N' or MSC_CL_PULL.v_lrnn<> -1 or MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS120) Then /* Build v_sql_stmt based on the MSC_SRP_ENABLED profile Bug 5909379 */
1333:
1334: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1335: lv_new_view_name := 'MRP_AP_WIP_JOB_SUPPLIES_V';
1336: lv_new_org_string := MSC_UTIL.v_in_org_str;

Line 1336: lv_new_org_string := MSC_UTIL.v_in_org_str;

1332: if (MSC_UTIL.G_COLLECT_SRP_DATA='N' or MSC_CL_PULL.v_lrnn<> -1 or MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS120) Then /* Build v_sql_stmt based on the MSC_SRP_ENABLED profile Bug 5909379 */
1333:
1334: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1335: lv_new_view_name := 'MRP_AP_WIP_JOB_SUPPLIES_V';
1336: lv_new_org_string := MSC_UTIL.v_in_org_str;
1337:
1338: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_WIP_JOB_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'||
1339: ' where x.ORGANIZATION_ID '||lv_new_org_string||' '||v_temp_sql ;
1340: /* Changes For Bug 5909379 SRP Enhancements */

Line 1342: else -- Profile MSC_UTIL.G_COLLECT_SRP_DATA = 'Y'

1338: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_WIP_JOB_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'||
1339: ' where x.ORGANIZATION_ID '||lv_new_org_string||' '||v_temp_sql ;
1340: /* Changes For Bug 5909379 SRP Enhancements */
1341:
1342: else -- Profile MSC_UTIL.G_COLLECT_SRP_DATA = 'Y'
1343: -- Repair Order Entities are No
1344:
1345: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1346: lv_new_view_name := 'MRP_AP_NON_ERO_WIP_JOB_SUPP_V';

Line 1347: lv_new_org_string := MSC_UTIL.v_non_depot_org_str;

1343: -- Repair Order Entities are No
1344:
1345: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1346: lv_new_view_name := 'MRP_AP_NON_ERO_WIP_JOB_SUPP_V';
1347: lv_new_org_string := MSC_UTIL.v_non_depot_org_str;
1348:
1349: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_ERO_WIP_JOB_SUPP_V'||MSC_CL_PULL.v_dblink||' x'||
1350: ' where x.ORGANIZATION_ID '||lv_new_org_string||' '||v_temp_sql ;
1351:

Line 1356: end if; /* End Profile MSC_UTIL.G_COLLECT_SRP_DATA 5909379 */

1352:
1353: ---- Code for SRP when Repair Orders Entity is/not selected . Building v_sql_stmt
1354:
1355:
1356: end if; /* End Profile MSC_UTIL.G_COLLECT_SRP_DATA 5909379 */
1357:
1358:
1359: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1360: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);

Line 1360: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);

1356: end if; /* End Profile MSC_UTIL.G_COLLECT_SRP_DATA 5909379 */
1357:
1358:
1359: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1360: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);
1361: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1362: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1363: MSC_CL_PULL.v_mps_consume_profile_value,
1364: MSC_CL_PULL.v_dgmt,

Line 1377: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply complete = '||v_sql_stmt);

1373: MSC_CL_PULL.v_lrn;
1374:
1375: ELSE -- For COmplete Refresh
1376:
1377: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply complete = '||v_sql_stmt);
1378:
1379:
1380: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
1381:

Line 1380: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN

1376:
1377: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply complete = '||v_sql_stmt);
1378:
1379:
1380: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
1381:
1382:
1383:
1384:

Line 1397: lv_new_org_string := MSC_UTIL.v_depot_org_str;

1393:
1394: begin
1395: MSC_CL_PULL.v_table_name := 'MSC_ST_SUPPLIES';
1396: lv_new_view_name := 'MRP_AP_NON_RO_WIP_JOB_SUPPLY_V';
1397: lv_new_org_string := MSC_UTIL.v_depot_org_str;
1398:
1399: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_RO_WIP_JOB_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'||
1400: ' where x.ORGANIZATION_ID '||lv_new_org_string ||' '||v_temp_sql;
1401:

Line 1410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_NON_RO_WIP_JOB_SUPPLY_V = '|| SQL%ROWCOUNT);

1406: MSC_CL_PULL.v_mps_consume_profile_value,
1407: MSC_CL_PULL.v_dgmt,
1408: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1409: MSC_CL_PULL.v_mps_consume_profile_value;
1410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_NON_RO_WIP_JOB_SUPPLY_V = '|| SQL%ROWCOUNT);
1411:
1412:
1413: end ; ---- Code for SRP To get the work orders not attached to repair orders:
1414:

Line 1430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_WIP_JOB_SUPPLIES_V = '|| SQL%ROWCOUNT);

1426: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1427: MSC_CL_PULL.v_mps_consume_profile_value;
1428: END IF;
1429: END IF;
1430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_WIP_JOB_SUPPLIES_V = '|| SQL%ROWCOUNT);
1431: COMMIT;
1432:
1433: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1434: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_COMP_SUPPLIES_V';

Line 1438: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

1434: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_COMP_SUPPLIES_V';
1435:
1436: lv_op_seq_num := ' x.OPERATION_SEQ_NUM, ';
1437:
1438: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1439: v_temp_sql := ' x.quantity_per_assembly,x.quantity_issued, x.ACTUAL_START_DATE, ';
1440:
1441: if lv_lbj_details = 1 Then
1442: lv_op_seq_num := ' x.COPY_OP_SEQ_NUM, ';

Line 1484: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1480: ||' 2,'
1481: ||' :v_refresh_id,'
1482: ||' :v_instance_id'
1483: ||' from MRP_AP_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
1484: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1485: ||' AND x.BY_PROD_QUANTITY <> 0'
1486: || lv_cond_sql
1487: --||' AND DECODE(:V_COLLECT_COMPLETED_JOBS,'
1488: --||' 2,x.coll_completed_qty_ind,'

Line 1522: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1518: ||' 2,'
1519: ||' :v_refresh_id,'
1520: ||' :v_instance_id'
1521: ||' from MRP_AP_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
1522: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1523: ||' AND x.BY_PROD_QUANTITY <> 0'
1524: || lv_cond_sql
1525: --||' AND DECODE(:V_COLLECT_COMPLETED_JOBS,'
1526: --||' 2,x.coll_completed_qty_ind,'

Line 1594: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1590: ||' 2,'
1591: ||' :v_refresh_id,'
1592: ||' :v_instance_id'
1593: ||' from MRP_AP_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
1594: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1595: ||' AND x.BY_PROD_QUANTITY <> 0'
1596: || lv_cond_sql
1597: --||' AND DECODE(:V_COLLECT_COMPLETED_JOBS,'
1598: --||' 2,x.coll_completed_qty_ind,'

Line 1631: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

1627: --If lv_lbj_details = 1 Then
1628:
1629: IF MSC_CL_PULL.v_lrn <> -1 then /*incremental refresh*/
1630:
1631: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1632: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1633: ELSE
1634: v_temp_sql := NULL;
1635: END IF;

Line 1632: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

1628:
1629: IF MSC_CL_PULL.v_lrn <> -1 then /*incremental refresh*/
1630:
1631: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1632: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1633: ELSE
1634: v_temp_sql := NULL;
1635: END IF;
1636:

Line 1668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);

1664: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1665: MSC_CL_PULL.v_instance_id,
1666: MSC_CL_PULL.v_mps_consume_profile_value;
1667:
1668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);
1669: COMMIT;
1670:
1671:
1672: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN --bug#5684183 (bcaru)

Line 1672: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN --bug#5684183 (bcaru)

1668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);
1669: COMMIT;
1670:
1671:
1672: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN --bug#5684183 (bcaru)
1673: /* ds change start */
1674: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATION_NETWORKS';
1675: MSC_CL_PULL.v_view_name := 'MRP_AD_WOPR_NETWORKS_V';
1676:

Line 1695: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);

1691: ||' :v_instance_id'
1692: ||' from MRP_AD_WOPR_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
1693: ||' where x.RN> '||MSC_CL_PULL.v_lrn;
1694:
1695: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);
1696: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1697: MSC_CL_PULL.v_instance_id;
1698:
1699: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_WOPR_NETWORKS = '|| SQL%ROWCOUNT);

Line 1699: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_WOPR_NETWORKS = '|| SQL%ROWCOUNT);

1695: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);
1696: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1697: MSC_CL_PULL.v_instance_id;
1698:
1699: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_WOPR_NETWORKS = '|| SQL%ROWCOUNT);
1700: COMMIT;
1701:
1702: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATION_NETWORKS';
1703: MSC_CL_PULL.v_view_name := 'MRP_AD_EAM_WO_RELSHIPS_V';

Line 1723: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);

1719: ||' :v_instance_id'
1720: ||' from MRP_AD_EAM_WO_RELSHIPS_V'||MSC_CL_PULL.v_dblink||' x'
1721: ||' where x.RN> '||MSC_CL_PULL.v_lrn;
1722:
1723: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);
1724: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1725: MSC_CL_PULL.v_instance_id;
1726:
1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_EAM_WO_RELSHIPS_V = '|| SQL%ROWCOUNT);

Line 1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_EAM_WO_RELSHIPS_V = '|| SQL%ROWCOUNT);

1723: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);
1724: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1725: MSC_CL_PULL.v_instance_id;
1726:
1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_EAM_WO_RELSHIPS_V = '|| SQL%ROWCOUNT);
1728: -- opm populate job operation network in call
1729: -- to
1730:
1731: COMMIT;

Line 1733: END IF; --v_apps_ver >= MSC_UTIL.G_APPS120

1729: -- to
1730:
1731: COMMIT;
1732: /* ds change end */
1733: END IF; --v_apps_ver >= MSC_UTIL.G_APPS120
1734:
1735:
1736: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATIONS';
1737: MSC_CL_PULL.v_view_name := 'MRP_AD_JOB_OPERATIONS_V';

Line 1765: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OPERATIONS_V = '|| SQL%ROWCOUNT);

1761: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1762: MSC_CL_PULL.v_instance_id,
1763: MSC_CL_PULL.v_mps_consume_profile_value;
1764:
1765: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OPERATIONS_V = '|| SQL%ROWCOUNT);
1766: COMMIT;
1767:
1768:
1769: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_REQUIREMENT_OPS';

Line 1804: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_REQUIREMENT_OPS_V = '|| SQL%ROWCOUNT);

1800: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1801: MSC_CL_PULL.v_instance_id,
1802: MSC_CL_PULL.v_mps_consume_profile_value;
1803:
1804: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_REQUIREMENT_OPS_V = '|| SQL%ROWCOUNT);
1805: COMMIT;
1806:
1807: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OP_RESOURCES';
1808: MSC_CL_PULL.v_view_name := 'MRP_AD_JOB_OP_RESOURCES_V';

Line 1837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);

1833:
1834: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1835: MSC_CL_PULL.v_instance_id,
1836: MSC_CL_PULL.v_mps_consume_profile_value;
1837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
1838: COMMIT;
1839:
1840: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OP_RESOURCES';
1841: MSC_CL_PULL.v_view_name := 'MRP_AD_LJ_SUB_OP_RESOURCES_V';

Line 1871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_LJ_SUB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);

1867: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1868: MSC_CL_PULL.v_instance_id,
1869: MSC_CL_PULL.v_mps_consume_profile_value;
1870:
1871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_LJ_SUB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
1872: COMMIT;
1873:
1874: END IF; /*incremental refresh */
1875:

Line 1915: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1911: ||' x.TOP_WIP_ENTITY_ID,' /*ds change end */
1912: ||' 2,'
1913: ||' :v_refresh_id'
1914: ||' FROM MRP_AP_JOB_OP_NETWORKS_V '||MSC_CL_PULL.v_dblink||' x '
1915: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1916: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
1917: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
1918: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
1919:

Line 1920: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ap job network = '||v_sql_stmt);

1916: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
1917: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
1918: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
1919:
1920: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ap job network = '||v_sql_stmt);
1921: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
1922: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);
1923:
1924: COMMIT;

Line 1922: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);

1918: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
1919:
1920: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ap job network = '||v_sql_stmt);
1921: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
1922: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);
1923:
1924: COMMIT;
1925:
1926: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OPERATIONS';

Line 1977: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1973: ||' x.NET_PLANNING_PERCENT,'
1974: ||' 2,'
1975: ||' :v_refresh_id'
1976: ||' FROM MRP_AP_JOB_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1977: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1978: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
1979: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
1980: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
1981:

Line 1983: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OPERATIONS_V = '|| SQL%ROWCOUNT);

1979: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
1980: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
1981:
1982: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id;
1983: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OPERATIONS_V = '|| SQL%ROWCOUNT);
1984:
1985: COMMIT;
1986:
1987: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_REQUIREMENT_OPS';

Line 1990: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

1986:
1987: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_REQUIREMENT_OPS';
1988: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_REQUIREMENT_OPS_V';
1989:
1990: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1991: v_temp_sql1 := ' x.BASIS_TYPE, ';
1992: ELSE
1993: v_temp_sql1 := ' NULL, ';
1994: END IF;

Line 2052: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

2048: || v_temp_sql1
2049: ||' 2,'
2050: ||' :v_refresh_id'
2051: ||' FROM MRP_AP_JOB_REQUIREMENT_OPS_V'||MSC_CL_PULL.v_dblink||' x'
2052: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2053: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2054: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2055: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn || ' )';
2056:

Line 2058: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_REQUIREMENT_OPS_V = '|| SQL%ROWCOUNT);

2054: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2055: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn || ' )';
2056:
2057: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id;
2058: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_REQUIREMENT_OPS_V = '|| SQL%ROWCOUNT);
2059:
2060: COMMIT;
2061:
2062:

Line 2128: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

2124: ||' x.MAXIMUM_ASSIGNED_UNITS,'
2125: ||' 2,'
2126: ||' :v_refresh_id'
2127: ||' FROM MRP_AP_JOB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2128: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2129: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2130: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2131: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2132:

Line 2133: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap job op resources = '||v_sql_stmt);

2129: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2130: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2131: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2132:
2133: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap job op resources = '||v_sql_stmt);
2134: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id;
2135: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2136:
2137: COMMIT;

Line 2135: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);

2131: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2132:
2133: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap job op resources = '||v_sql_stmt);
2134: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id;
2135: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2136:
2137: COMMIT;
2138:
2139: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OP_RESOURCES';

Line 2193: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

2189: ||' x.SETUP_ID,' /* ds change */
2190: ||' 2,'
2191: ||' :v_refresh_id'
2192: ||' FROM MRP_AP_LJ_SUB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2193: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2194: ||' AND (x.RN1>' || MSC_CL_PULL.v_lrn
2195: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn
2196: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';
2197:

Line 2199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_LJ_SUB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);

2195: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn
2196: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';
2197:
2198: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
2199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_LJ_SUB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2200:
2201: COMMIT;
2202:
2203:

Line 2243: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

2239: ||' 2,'
2240: ||' :v_refresh_id,'
2241: ||' :v_instance_id'
2242: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
2243: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2244: ||' AND (x.RN2 > :v_lrn)'
2245: ||' UNION '
2246: ||' select'
2247: ||' x.PRIMARY_ITEM_ID,'

Line 2271: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

2267: ||' 2,'
2268: ||' :v_refresh_id,'
2269: ||' :v_instance_id'
2270: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
2271: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2272: ||' AND (x.RN3 > :v_lrn)'
2273: ||' UNION '
2274: ||' select'
2275: ||' x.PRIMARY_ITEM_ID,'

Line 2299: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

2295: ||' 2,'
2296: ||' :v_refresh_id,'
2297: ||' :v_instance_id'
2298: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
2299: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2300: ||' AND (x.RN4 > :v_lrn)';
2301:
2302: ELSE
2303:

Line 2358: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

2354: ||' 2,'
2355: ||' :v_refresh_id,'
2356: ||' :v_instance_id'
2357: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
2358: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2359: || v_union_sql;
2360:
2361: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2362: