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 18: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;

14: v_temp_sql5 VARCHAR2(32767);
15: v_temp_sql6 VARCHAR2(32767);
16: v_temp_sql7 VARCHAR2(32767);
17: -- NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
18: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
19:
20: v_once_per_org varchar2(10) := 'NOTDONE';
21:
22: -----OSFM---------

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 588: 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 */

584: ||' AND x.NEW_REQUIRED_QUANTITY > 0'
585: || v_union_sql ;
586:
587:
588: 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 */
589:
590: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
591: lv_new_view_name := 'MRP_AP_WIP_COMP_DEMANDS_V';
592: lv_new_org_string := MSC_UTIL.v_in_org_str;

Line 592: lv_new_org_string := MSC_UTIL.v_in_org_str;

588: 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 */
589:
590: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
591: lv_new_view_name := 'MRP_AP_WIP_COMP_DEMANDS_V';
592: lv_new_org_string := MSC_UTIL.v_in_org_str;
593:
594: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
595: ||' WHERE x.ORGANIZATION_ID '||lv_new_org_string||v_temp_sql;
596: else -- Profile MSC_UTIL.G_COLLECT_SRP_DATA = 'Y'

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

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

Line 601: lv_new_org_string := MSC_UTIL.v_non_depot_org_str;

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

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

618: */
619:
620: ELSE
621:
622: if (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) Then
623: Begin
624:
625: EXECUTE IMMEDIATE v_temp_sql_stmt
626: 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 632: lv_new_org_string := MSC_UTIL.v_depot_org_str;

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

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

643: ELSE
644: EXECUTE IMMEDIATE v_temp_sql_stmt
645: 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;
646:
647: end if; -- For SRP and MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120
648: END IF;
649:
650: COMMIT;
651:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 869: IF ((MSC_UTIL.g_collect_cmro_data = 'Y' and

865:
866: COMMIT;
867:
868: --=================== CMRO Work Order DEMAND ==================
869: IF ((MSC_UTIL.g_collect_cmro_data = 'Y' and
870: MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121) OR
871: (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
872: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' )) THEN
873:

Line 870: MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121) OR

866: COMMIT;
867:
868: --=================== CMRO Work Order DEMAND ==================
869: IF ((MSC_UTIL.g_collect_cmro_data = 'Y' and
870: MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121) OR
871: (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
872: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' )) THEN
873:
874:

Line 871: (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER

867:
868: --=================== CMRO Work Order DEMAND ==================
869: IF ((MSC_UTIL.g_collect_cmro_data = 'Y' and
870: MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121) OR
871: (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
872: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' )) THEN
873:
874:
875: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 872: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' )) THEN

868: --=================== CMRO Work Order DEMAND ==================
869: IF ((MSC_UTIL.g_collect_cmro_data = 'Y' and
870: MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121) OR
871: (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
872: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' )) THEN
873:
874:
875: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
876:

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

921: ||' X.COMPONENT_YIELD_FACTOR,'
922: ||' :v_refresh_id,'
923: ||' :v_instance_id'
924: ||' from MRP_AP_CMRO_WIP_COMP_DMD_V'||MSC_CL_PULL.v_dblink||' X'
925: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
926: ||' AND DECODE(:v_collect_completed_jobs,'
927: ||' 2,x.status_code,'
928: ||' 1) <>4'
929: ||' AND x.NEW_REQUIRED_QUANTITY > 0'

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

959: ||' X.COMPONENT_YIELD_FACTOR,'
960: ||' :v_refresh_id,'
961: ||' :v_instance_id'
962: ||' from MRP_AP_CMRO_WIP_COMP_DMD_V'||MSC_CL_PULL.v_dblink||' X'
963: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
964: ||' AND DECODE(:v_collect_completed_jobs,'
965: ||' 2,x.status_code,'
966: ||' 1) <>4'
967: ||' AND x.NEW_REQUIRED_QUANTITY > 0'

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

1031: ||' X.COMPONENT_YIELD_FACTOR,'
1032: ||' :v_refresh_id,'
1033: ||' :v_instance_id'
1034: ||' from MRP_AP_CMRO_WIP_COMP_DMD_V'||MSC_CL_PULL.v_dblink||' X'
1035: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1036: ;
1037:
1038:
1039: v_temp_sql := ' AND DECODE(:v_collect_completed_jobs,'

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

1107: v_temp_sql_stmt2 VARCHAR2(32767) :=null;
1108:
1109: BEGIN
1110:
1111: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN
1112:
1113: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1114:
1115: select LBJ_DETAILS into lv_lbj_details from msc_apps_instances

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

1109: BEGIN
1110:
1111: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN
1112:
1113: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1114:
1115: select LBJ_DETAILS into lv_lbj_details from msc_apps_instances
1116: where instance_id = MSC_CL_PULL.v_instance_id ;
1117: END IF;

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

1137:
1138: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1139:
1140: -- =================== JOB/FLOW SCHEDULE =====================
1141: IF ((MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN
1142: -- Changed for Bug 6081537
1143: -- Supplies from Non Depot orgs
1144:
1145: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

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

1164: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'
1165: ||' x.WJS_NET_QTY_FLAG),'
1166: ||' x.WJS_NET_QTY_FLAG)=1'
1167: ||' AND x.RN> :v_lrn '
1168: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_non_depot_org_str;
1169:
1170: -- Supplies from Depot repair orgs
1171: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1172: MSC_CL_PULL.v_view_name := 'MRP_AD_NON_RO_WIP_JOB_SUPP_V';

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

1190: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'
1191: ||' x.WJS_NET_QTY_FLAG),'
1192: ||' x.WJS_NET_QTY_FLAG)=1'
1193: ||' AND x.RN> :v_lrn '
1194: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_depot_org_str;
1195:
1196:
1197: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1198: MSC_CL_PULL.v_instance_id,

Line 1202: 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);

1198: MSC_CL_PULL.v_instance_id,
1199: MSC_CL_PULL.v_mps_consume_profile_value,
1200: MSC_CL_PULL.v_lrn;
1201:
1202: 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);
1203: COMMIT;
1204:
1205: EXECUTE IMMEDIATE v_temp_sql2 USING MSC_CL_PULL.v_refresh_id,
1206: MSC_CL_PULL.v_instance_id,

Line 1210: 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);

1206: MSC_CL_PULL.v_instance_id,
1207: MSC_CL_PULL.v_mps_consume_profile_value,
1208: MSC_CL_PULL.v_lrn;
1209:
1210: 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);
1211: COMMIT;
1212:
1213: ELSE -- (SRP Profile is No)
1214:

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

1214:
1215: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1216: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_JOB_SUPPLIES_V';
1217:
1218: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1219: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1220: ELSE
1221: v_temp_sql := NULL;
1222: END IF;

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

1215: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1216: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_JOB_SUPPLIES_V';
1217:
1218: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1219: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1220: ELSE
1221: v_temp_sql := NULL;
1222: END IF;
1223:

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

1247: MSC_CL_PULL.v_instance_id,
1248: MSC_CL_PULL.v_mps_consume_profile_value,
1249: MSC_CL_PULL.v_lrn;
1250:
1251: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_WIP_JOB_SUPPLIES_V = '|| SQL%ROWCOUNT);
1252: COMMIT;
1253: END IF;
1254: -- =================== JOB COMPONENTS =====================
1255:

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

1257: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_COMP_SUPPLIES_V';
1258:
1259: lv_op_seq_num := 'x.OPERATION_SEQ_NUM, ';
1260:
1261: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1262: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1263:
1264: if lv_lbj_details = 1 Then
1265: lv_op_seq_num := ' x.COPY_OP_SEQ_NUM, ';

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

1258:
1259: lv_op_seq_num := 'x.OPERATION_SEQ_NUM, ';
1260:
1261: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1262: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1263:
1264: if lv_lbj_details = 1 Then
1265: lv_op_seq_num := ' x.COPY_OP_SEQ_NUM, ';
1266: end if;

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

1309:
1310: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1311: MSC_CL_PULL.v_view_name := 'MRP_AD_REPT_ITEM_SUPPLIES_V';
1312:
1313: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1314: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1315: ELSE
1316: v_temp_sql := NULL;
1317: END IF;

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

1310: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1311: MSC_CL_PULL.v_view_name := 'MRP_AD_REPT_ITEM_SUPPLIES_V';
1312:
1313: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1314: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1315: ELSE
1316: v_temp_sql := NULL;
1317: END IF;
1318:

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

1345: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_JOB_SUPPLIES_V';
1346:
1347:
1348: Begin
1349: if MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then
1350: if lv_lbj_details = 1 Then
1351: v_temp_sql := ' x.routing_reference_id,x.bom_reference_id,x.coproducts_supply,x.jd_operation_seq_num,'||
1352: 'x.JUMP_OP_SEQ_NUM,x.JOB_OP_SEQ_NUM, '||
1353: 'x.requested_start_date,x.requested_completion_date,x.schedule_priority,x.asset_item_id,x.asset_serial_number,' ||/* ds change */

Line 1362: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN

1358: 'x.ACTUAL_START_DATE,x.cfm_routing_flag, '; /* Discrete Mfg Enahancements Bug 4479276 */
1359: end if;
1360: else
1361: v_temp_sql := ' NULL, NULL, NULL, NULL, NULL, NULL, '||'NULL, NULL, NULL, ';
1362: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN
1363: v_temp_sql := v_temp_sql ||'x.asset_item_id,';
1364: ELSE
1365: v_temp_sql := v_temp_sql ||'NULL,';
1366: END IF;

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

1370:
1371: Begin
1372:
1373: --Bug#3419189
1374: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1375:
1376: v_temp_sql1 := ' x.wip_start_quantity,';
1377:
1378: ELSE

Line 1382: IF MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS121

1378: ELSE
1379: v_temp_sql1 := ' NULL,';
1380: END IF;
1381:
1382: IF MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS121
1383: THEN
1384: v_temp_sql5 := 'x.maintenance_object_source,x.description,x.asset_number,'||
1385: 'x.maintenance_object_id,x.maintenance_object_type,';
1386: ELSE

Line 1391: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN

1387: v_temp_sql5 := 'NULL,NULL,NULL,NULL,NULL,';
1388: END IF;
1389:
1390: /*USAF -- eam */
1391: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN
1392: v_temp_sql6 := 'NULL,x.CLASS_CODE,x.SHUTDOWN_TYPE,x.ACTIVITY_TYPE,'
1393: ||' decode(x.ORDER_TYPE,70, x.INVENTORY_ITEM_ID,NULL) ACTIVITY_ITEM_ID,';
1394: v_temp_sql7 := ' decode(x.ORDER_TYPE,70, x.asset_item_id, x.INVENTORY_ITEM_ID) INVENTORY_ITEM_ID, ';
1395: ELSE

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

1396: v_temp_sql6 := 'NULL,NULL,NULL,NULL,NULL,';
1397: v_temp_sql7 := ' x.INVENTORY_ITEM_ID,';
1398: END IF;
1399:
1400: /*Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS115,
1401: ' DECODE( x.wip_job_type, 1,
1402: DECODE( :v_mps_consume_profile_value,
1403: 1, x.mps_wip_start_quantity,
1404: x.wip_start_quantity),

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

1459: || v_temp_sql6
1460: ||' :v_refresh_id,'
1461: ||' :v_instance_id'
1462: ||' from MRP_AP_WIP_JOB_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
1463: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1464: /*Bug#4704457 ||' AND DECODE( x.wip_job_type,'
1465: ||' 1, DECODE( :v_mps_consume_profile_value,'
1466: ||' 1, x.mps_net_quantity,'
1467: ||' x.net_quantity),'

Line 1591: 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 */

1587:
1588: v_temp_sql2:= v_sql_stmt; -- Added For Bug 5935273
1589: v_temp_sql := lv_qty_sql_temp|| v_union_sql;
1590:
1591: 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 */
1592:
1593: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1594: lv_new_view_name := 'MRP_AP_WIP_JOB_SUPPLIES_V';
1595: lv_new_org_string := MSC_UTIL.v_in_org_str;

Line 1595: lv_new_org_string := MSC_UTIL.v_in_org_str;

1591: 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 */
1592:
1593: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1594: lv_new_view_name := 'MRP_AP_WIP_JOB_SUPPLIES_V';
1595: lv_new_org_string := MSC_UTIL.v_in_org_str;
1596:
1597: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_WIP_JOB_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'||
1598: ' where x.ORGANIZATION_ID '||lv_new_org_string||' '||v_temp_sql ;
1599: /* Changes For Bug 5909379 SRP Enhancements */

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

1597: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_WIP_JOB_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'||
1598: ' where x.ORGANIZATION_ID '||lv_new_org_string||' '||v_temp_sql ;
1599: /* Changes For Bug 5909379 SRP Enhancements */
1600:
1601: else -- Profile MSC_UTIL.G_COLLECT_SRP_DATA = 'Y'
1602: -- Repair Order Entities are No
1603:
1604: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1605: MSC_CL_PULL.v_view_name:= 'MRP_AP_NON_ERO_WIP_JOB_SUPP_V';

Line 1608: lv_new_org_string := MSC_UTIL.v_non_depot_org_str;

1604: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1605: MSC_CL_PULL.v_view_name:= 'MRP_AP_NON_ERO_WIP_JOB_SUPP_V';
1606:
1607: lv_new_view_name := 'MRP_AP_NON_ERO_WIP_JOB_SUPP_V';
1608: lv_new_org_string := MSC_UTIL.v_non_depot_org_str;
1609:
1610: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_ERO_WIP_JOB_SUPP_V'||MSC_CL_PULL.v_dblink||' x'||
1611: ' where x.ORGANIZATION_ID '||lv_new_org_string||' '||v_temp_sql ;
1612: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql-- '|| v_temp_sql_stmt);

Line 1612: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql-- '|| v_temp_sql_stmt);

1608: lv_new_org_string := MSC_UTIL.v_non_depot_org_str;
1609:
1610: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_ERO_WIP_JOB_SUPP_V'||MSC_CL_PULL.v_dblink||' x'||
1611: ' where x.ORGANIZATION_ID '||lv_new_org_string||' '||v_temp_sql ;
1612: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql-- '|| v_temp_sql_stmt);
1613:
1614: ---- Code for SRP when Repair Orders Entity is/not selected . Building v_sql_stmt
1615:
1616:

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

1613:
1614: ---- Code for SRP when Repair Orders Entity is/not selected . Building v_sql_stmt
1615:
1616:
1617: end if; /* End Profile MSC_UTIL.G_COLLECT_SRP_DATA 5909379 */
1618:
1619:
1620: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1621: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);

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

1617: end if; /* End Profile MSC_UTIL.G_COLLECT_SRP_DATA 5909379 */
1618:
1619:
1620: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1621: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);
1622: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1623: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1624: MSC_CL_PULL.v_mps_consume_profile_value,
1625: MSC_CL_PULL.v_dgmt,

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

1636: MSC_CL_PULL.v_lrn;
1637:
1638: ELSE -- For COmplete Refresh
1639:
1640: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply complete = '||v_sql_stmt);
1641:
1642:
1643: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
1644:

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

1639:
1640: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply complete = '||v_sql_stmt);
1641:
1642:
1643: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
1644:
1645:
1646: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql-- '|| v_temp_sql_stmt);
1647:

Line 1646: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql-- '|| v_temp_sql_stmt);

1642:
1643: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
1644:
1645:
1646: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql-- '|| v_temp_sql_stmt);
1647:
1648: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1649: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1650: MSC_CL_PULL.v_mps_consume_profile_value,

Line 1660: lv_new_org_string := MSC_UTIL.v_depot_org_str;

1656:
1657: begin
1658: MSC_CL_PULL.v_table_name := 'MSC_ST_SUPPLIES';
1659: lv_new_view_name := 'MRP_AP_NON_RO_WIP_JOB_SUPPLY_V';
1660: lv_new_org_string := MSC_UTIL.v_depot_org_str;
1661:
1662: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_RO_WIP_JOB_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'||
1663: ' where x.ORGANIZATION_ID '||lv_new_org_string ||' '||v_temp_sql;
1664:

Line 1666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql2-- '|| v_temp_sql_stmt);

1662: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_RO_WIP_JOB_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'||
1663: ' where x.ORGANIZATION_ID '||lv_new_org_string ||' '||v_temp_sql;
1664:
1665:
1666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql2-- '|| v_temp_sql_stmt);
1667: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1668: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1669: MSC_CL_PULL.v_mps_consume_profile_value,
1670: MSC_CL_PULL.v_dgmt,

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

1669: MSC_CL_PULL.v_mps_consume_profile_value,
1670: MSC_CL_PULL.v_dgmt,
1671: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1672: MSC_CL_PULL.v_mps_consume_profile_value;
1673: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_NON_RO_WIP_JOB_SUPPLY_V = '|| SQL%ROWCOUNT);
1674:
1675:
1676: end ; ---- Code for SRP To get the work orders not attached to repair orders:
1677:

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

1689: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1690: MSC_CL_PULL.v_mps_consume_profile_value;
1691: END IF;
1692: END IF;
1693: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_WIP_JOB_SUPPLIES_V = '|| SQL%ROWCOUNT);
1694: COMMIT;
1695:
1696: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1697: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_COMP_SUPPLIES_V';

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

1697: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_COMP_SUPPLIES_V';
1698:
1699: lv_op_seq_num := ' x.OPERATION_SEQ_NUM, ';
1700:
1701: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1702: v_temp_sql := ' x.quantity_per_assembly,x.quantity_issued, x.ACTUAL_START_DATE, ';
1703:
1704: if lv_lbj_details = 1 Then
1705: lv_op_seq_num := ' x.COPY_OP_SEQ_NUM, ';

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

1743: ||' 2,'
1744: ||' :v_refresh_id,'
1745: ||' :v_instance_id'
1746: ||' from MRP_AP_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
1747: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1748: ||' AND x.BY_PROD_QUANTITY <> 0'
1749: || lv_cond_sql
1750: --||' AND DECODE(:V_COLLECT_COMPLETED_JOBS,'
1751: --||' 2,x.coll_completed_qty_ind,'

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

1781: ||' 2,'
1782: ||' :v_refresh_id,'
1783: ||' :v_instance_id'
1784: ||' from MRP_AP_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
1785: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1786: ||' AND x.BY_PROD_QUANTITY <> 0'
1787: || lv_cond_sql
1788: --||' AND DECODE(:V_COLLECT_COMPLETED_JOBS,'
1789: --||' 2,x.coll_completed_qty_ind,'

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

1853: ||' 2,'
1854: ||' :v_refresh_id,'
1855: ||' :v_instance_id'
1856: ||' from MRP_AP_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
1857: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1858: ||' AND x.BY_PROD_QUANTITY <> 0'
1859: || lv_cond_sql
1860: --||' AND DECODE(:V_COLLECT_COMPLETED_JOBS,'
1861: --||' 2,x.coll_completed_qty_ind,'

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

1890: --If lv_lbj_details = 1 Then
1891:
1892: IF MSC_CL_PULL.v_lrn <> -1 then /*incremental refresh*/
1893:
1894: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1895: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1896: ELSE
1897: v_temp_sql := NULL;
1898: END IF;

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

1891:
1892: IF MSC_CL_PULL.v_lrn <> -1 then /*incremental refresh*/
1893:
1894: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1895: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1896: ELSE
1897: v_temp_sql := NULL;
1898: END IF;
1899:

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

1927: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1928: MSC_CL_PULL.v_instance_id,
1929: MSC_CL_PULL.v_mps_consume_profile_value;
1930:
1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);
1932: COMMIT;
1933:
1934:
1935: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN --bug#5684183 (bcaru)

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

1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);
1932: COMMIT;
1933:
1934:
1935: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN --bug#5684183 (bcaru)
1936: /* ds change start */
1937: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATION_NETWORKS';
1938: MSC_CL_PULL.v_view_name := 'MRP_AD_WOPR_NETWORKS_V';
1939:

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

1954: ||' :v_instance_id'
1955: ||' from MRP_AD_WOPR_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
1956: ||' where x.RN> '||MSC_CL_PULL.v_lrn;
1957:
1958: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);
1959: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1960: MSC_CL_PULL.v_instance_id;
1961:
1962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_WOPR_NETWORKS = '|| SQL%ROWCOUNT);

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

1958: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);
1959: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1960: MSC_CL_PULL.v_instance_id;
1961:
1962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_WOPR_NETWORKS = '|| SQL%ROWCOUNT);
1963: COMMIT;
1964:
1965: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATION_NETWORKS';
1966: MSC_CL_PULL.v_view_name := 'MRP_AD_EAM_WO_RELSHIPS_V';

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

1982: ||' :v_instance_id'
1983: ||' from MRP_AD_EAM_WO_RELSHIPS_V'||MSC_CL_PULL.v_dblink||' x'
1984: ||' where x.RN> '||MSC_CL_PULL.v_lrn;
1985:
1986: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);
1987: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1988: MSC_CL_PULL.v_instance_id;
1989:
1990: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_EAM_WO_RELSHIPS_V = '|| SQL%ROWCOUNT);

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

1986: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);
1987: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1988: MSC_CL_PULL.v_instance_id;
1989:
1990: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_EAM_WO_RELSHIPS_V = '|| SQL%ROWCOUNT);
1991: -- opm populate job operation network in call
1992: -- to
1993:
1994: COMMIT;

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

1992: -- to
1993:
1994: COMMIT;
1995: /* ds change end */
1996: END IF; --v_apps_ver >= MSC_UTIL.G_APPS120
1997:
1998:
1999: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATIONS';
2000: MSC_CL_PULL.v_view_name := 'MRP_AD_JOB_OPERATIONS_V';

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

2024: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2025: MSC_CL_PULL.v_instance_id,
2026: MSC_CL_PULL.v_mps_consume_profile_value;
2027:
2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OPERATIONS_V = '|| SQL%ROWCOUNT);
2029: COMMIT;
2030:
2031:
2032: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_REQUIREMENT_OPS';

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

2063: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2064: MSC_CL_PULL.v_instance_id,
2065: MSC_CL_PULL.v_mps_consume_profile_value;
2066:
2067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_REQUIREMENT_OPS_V = '|| SQL%ROWCOUNT);
2068: COMMIT;
2069:
2070: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OP_RESOURCES';
2071: MSC_CL_PULL.v_view_name := 'MRP_AD_JOB_OP_RESOURCES_V';

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

2096:
2097: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2098: MSC_CL_PULL.v_instance_id,
2099: MSC_CL_PULL.v_mps_consume_profile_value;
2100: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2101: COMMIT;
2102:
2103: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OP_RESOURCES';
2104: MSC_CL_PULL.v_view_name := 'MRP_AD_LJ_SUB_OP_RESOURCES_V';

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

2130: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2131: MSC_CL_PULL.v_instance_id,
2132: MSC_CL_PULL.v_mps_consume_profile_value;
2133:
2134: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_LJ_SUB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2135: COMMIT;
2136:
2137: END IF; /*incremental refresh */
2138:

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

2174: ||' x.TOP_WIP_ENTITY_ID,' /*ds change end */
2175: ||' 2,'
2176: ||' :v_refresh_id'
2177: ||' FROM MRP_AP_JOB_OP_NETWORKS_V '||MSC_CL_PULL.v_dblink||' x '
2178: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2179: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2180: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
2181: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2182:

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

2179: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2180: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
2181: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2182:
2183: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ap job network = '||v_sql_stmt);
2184: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
2185: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);
2186:
2187: COMMIT;

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

2181: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2182:
2183: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ap job network = '||v_sql_stmt);
2184: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
2185: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);
2186:
2187: COMMIT;
2188:
2189: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OPERATIONS';

Line 2216: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN

2212: ||' REVERSE_CUMULATIVE_YIELD,'
2213: ||' NET_PLANNING_PERCENT,'
2214: ||' DELETED_FLAG,'
2215: ||' REFRESH_ID';
2216: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN
2217: v_sql_stmt:= v_sql_stmt
2218: ||', Operation_Code,'
2219: ||' actual_start_date,'
2220: ||' actual_end_date ,'

Line 2247: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN

2243: ||' x.REVERSE_CUMULATIVE_YIELD,'
2244: ||' x.NET_PLANNING_PERCENT,'
2245: ||' 2,'
2246: ||' :v_refresh_id';
2247: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN
2248: v_sql_stmt:= v_sql_stmt
2249: ||', x.Operation_Code,'
2250: ||' x.actual_start_date,'
2251: ||' x.actual_end_date,'

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

2252: ||' x.Operation_desc';
2253: END IF;
2254: v_sql_stmt:= v_sql_stmt
2255: ||' FROM MRP_AP_JOB_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'
2256: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2257: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2258: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
2259: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2260:

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

2258: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
2259: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2260:
2261: 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;
2262: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OPERATIONS_V = '|| SQL%ROWCOUNT);
2263:
2264: COMMIT;
2265:
2266: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_REQUIREMENT_OPS';

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

2265:
2266: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_REQUIREMENT_OPS';
2267: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_REQUIREMENT_OPS_V';
2268:
2269: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
2270: v_temp_sql1 := ' x.BASIS_TYPE, ';
2271: ELSE
2272: v_temp_sql1 := ' NULL, ';
2273: END IF;

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

2327: || v_temp_sql1
2328: ||' 2,'
2329: ||' :v_refresh_id'
2330: ||' FROM MRP_AP_JOB_REQUIREMENT_OPS_V'||MSC_CL_PULL.v_dblink||' x'
2331: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2332: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2333: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2334: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn || ' )';
2335:

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

2333: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2334: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn || ' )';
2335:
2336: 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;
2337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_REQUIREMENT_OPS_V = '|| SQL%ROWCOUNT);
2338:
2339: COMMIT;
2340:
2341:

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

2403: ||' x.MAXIMUM_ASSIGNED_UNITS,'
2404: ||' 2,'
2405: ||' :v_refresh_id'
2406: ||' FROM MRP_AP_JOB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2407: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2408: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2409: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2410: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2411:

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

2408: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2409: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2410: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2411:
2412: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap job op resources = '||v_sql_stmt);
2413: 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;
2414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2415:
2416: COMMIT;

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

2410: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2411:
2412: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap job op resources = '||v_sql_stmt);
2413: 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;
2414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2415:
2416: COMMIT;
2417:
2418: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OP_RESOURCES';

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

2468: ||' x.SETUP_ID,' /* ds change */
2469: ||' 2,'
2470: ||' :v_refresh_id'
2471: ||' FROM MRP_AP_LJ_SUB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2472: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2473: ||' AND (x.RN1>' || MSC_CL_PULL.v_lrn
2474: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn
2475: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';
2476:

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

2474: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn
2475: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';
2476:
2477: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_LJ_SUB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2479:
2480: COMMIT;
2481:
2482:

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

2518: ||' 2,'
2519: ||' :v_refresh_id,'
2520: ||' :v_instance_id'
2521: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
2522: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2523: ||' AND (x.RN2 > :v_lrn)'
2524: ||' UNION '
2525: ||' select'
2526: ||' x.PRIMARY_ITEM_ID,'

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

2546: ||' 2,'
2547: ||' :v_refresh_id,'
2548: ||' :v_instance_id'
2549: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
2550: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2551: ||' AND (x.RN3 > :v_lrn)'
2552: ||' UNION '
2553: ||' select'
2554: ||' x.PRIMARY_ITEM_ID,'

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

2574: ||' 2,'
2575: ||' :v_refresh_id,'
2576: ||' :v_instance_id'
2577: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
2578: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2579: ||' AND (x.RN4 > :v_lrn)';
2580:
2581: ELSE
2582:

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

2633: ||' 2,'
2634: ||' :v_refresh_id,'
2635: ||' :v_instance_id'
2636: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
2637: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2638: || v_union_sql;
2639:
2640: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2641: