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_DEMAND_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_msc_so_offset_days NUMBER := NVL(FND_PROFILE.VALUE('MSC_SO_OFFSET_DAYS'),99999);
19: v_msc_x_vmi_om_order_type varchar2(50) := FND_PROFILE.VALUE('MSC_X_VMI_OM_ORDER_TYPE');
20:

Line 27: IF MSC_CL_PULL.FORECAST_ENABLED= MSC_UTIL.SYS_YES THEN

23: PROCEDURE LOAD_FORECASTS IS
24:
25: BEGIN
26:
27: IF MSC_CL_PULL.FORECAST_ENABLED= MSC_UTIL.SYS_YES THEN
28:
29: MSC_CL_PULL.v_table_name:= 'MSC_ST_DESIGNATORS';
30: MSC_CL_PULL.v_view_name := 'MRP_AP_FORECAST_DSGN_V';
31:

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

74: ||' 2,'
75: ||' :v_refresh_id,'
76: ||' :v_instance_id'
77: ||' from MRP_AP_FORECAST_DSGN_V'||MSC_CL_PULL.v_dblink||' x'
78: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
79: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;
80:
81: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
82:

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

102: ||' 1,'
103: ||' :v_refresh_id,'
104: ||' :v_instance_id'
105: ||' from MRP_AD_FORECAST_DSGN_V'||MSC_CL_PULL.v_dblink||' x'
106: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
107: ||' AND x.RN> '||MSC_CL_PULL.v_lrn
108: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
109:
110:

Line 108: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

104: ||' :v_instance_id'
105: ||' from MRP_AD_FORECAST_DSGN_V'||MSC_CL_PULL.v_dblink||' x'
106: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
107: ||' AND x.RN> '||MSC_CL_PULL.v_lrn
108: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
109:
110:
111: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
112:

Line 124: IF MSC_CL_PULL.FORECAST_ENABLED = MSC_UTIL.SYS_YES THEN

120:
121: PROCEDURE LOAD_ITEM_FORECASTS IS
122: BEGIN
123:
124: IF MSC_CL_PULL.FORECAST_ENABLED = MSC_UTIL.SYS_YES THEN
125:
126: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
127:
128: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';

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

147: ||' 1,'
148: ||' :v_refresh_id,'
149: ||' :v_instance_id'
150: ||' from MRP_AD_FORECAST_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'
151: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
152: ||' AND x.RN>'||MSC_CL_PULL.v_lrn;
153:
154: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
155:

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

225: ||' x.PLANNING_GROUP,'
226: ||' :v_instance_id,'
227: ||' x.TRANSACTION_ID '
228: ||' from MRP_AP_FORECAST_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'
229: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
230: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;
231:
232:
233: EXECUTE IMMEDIATE v_sql_stmt

Line 249: IF MSC_CL_PULL.MDS_ENABLED= MSC_UTIL.SYS_YES THEN

245:
246: PROCEDURE LOAD_MDS_DEMAND IS
247: BEGIN
248:
249: IF MSC_CL_PULL.MDS_ENABLED= MSC_UTIL.SYS_YES THEN
250:
251: --=================== Net Change Mode: Delete ==================
252:
253: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 279: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

275: ||' :v_refresh_id,'
276: ||' :v_instance_id'
277: ||' from MRP_AD_MDS_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
278: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
279: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
280:
281: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
282:
283: COMMIT;

Line 287: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN

283: COMMIT;
284:
285: END IF;
286:
287: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
288:
289: v_temp_sql := 'x.original_system_line_reference,x.original_system_reference,x.demand_source_type,x.demand_class,x.PROMISE_DATE,x.LINK_TO_LINE_ID,x.ORDER_DATE_TYPE_CODE,x.SCHEDULE_ARRIVAL_DATE,x.LATEST_ACCEPTABLE_DATE,x.SHIPPING_METHOD_CODE, ';
290:
291:

Line 312: IF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS110) THEN

308: ||' 15, x.Attribute15,NULL),'
309: ||' 3,x.LATE_DEMAND_PENALTY_FACTOR) ), ';
310: ELSE
311:
312: IF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS110) THEN
313: v_temp_sql :='x.original_system_line_reference ,x.original_system_reference,x.demand_source_type,NULL,x.PROMISE_DATE,NULL,';
314: ELSE
315: v_temp_sql :=' NULL, NULL,NULL,NULL,NULL,NULL,NULL, NULL,NULL,NULL, ';
316: END IF;

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

407: || v_temp_sql
408: ||' :v_refresh_id,'
409: ||' :v_instance_id'
410: ||' from MRP_AP_MDS_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
411: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
412: ||' AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')'; --NCP: changed to RN3
413:
414: ELSE
415: v_union_sql :=

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

527: || v_temp_sql
528: ||' :v_refresh_id,'
529: ||' :v_instance_id'
530: ||' from MRP_AP_MDS_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
531: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
532: || v_union_sql ;
533:
534: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
535: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN

Line 535: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN

531: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
532: || v_union_sql ;
533:
534: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
535: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
536: EXECUTE IMMEDIATE v_sql_stmt
537: USING MSC_CL_PULL.v_dgmt,
538: MSC_CL_PULL.v_dgmt,
539: MSC_CL_PULL.v_dgmt,

Line 576: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN

572: MSC_CL_PULL.v_instance_id;
573: END IF;
574:
575: ELSE -- Targeted - Complete Refresh collections
576: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
577: EXECUTE IMMEDIATE v_sql_stmt
578: USING MSC_CL_PULL.v_dgmt,
579: MSC_CL_PULL.v_dgmt,
580: MSC_CL_PULL.v_dgmt,

Line 616: if(MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) then

612:
613: v_union_sql := ' ';
614: v_temp_sql4 := NULL;
615:
616: if(MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) then
617: v_temp_sql1:='x.SCHEDULE_ARRIVAL_DATE,x.LATEST_ACCEPTABLE_DATE,x.SHIPPING_METHOD_CODE,x.ATO_LINE_ID,x.ORDER_DATE_TYPE_CODE,x.DELIVERY_LEAD_TIME ';
618: else
619: v_temp_sql1:='NULL,NULL,NULL,NULL,NULL,NULL ';
620: end if;

Line 632: IF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS107 THEN

628: MSC_CL_PULL.v_view_name := 'MRP_AD_SALES_ORDERS_V';
629:
630: Begin
631:
632: IF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS107 THEN
633: v_temp_sql:= ' 2 ,';
634: ELSE
635: v_temp_sql:= ' x.CTO_FLAG,';
636: END IF ;

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

638:
639: End;
640: /*Added By raraghav */
641:
642: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
643: lv_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
644: ELSE
645: lv_temp_sql := NULL;
646: END IF;

Line 643: lv_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

639: End;
640: /*Added By raraghav */
641:
642: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
643: lv_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
644: ELSE
645: lv_temp_sql := NULL;
646: END IF;
647:

Line 671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_sql_stmt);

667: ||' from MRP_AD_HARD_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'
668: ||' where x.RN> :v_lrn '
669: || lv_temp_sql;
670:
671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_sql_stmt);
672: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
673:
674: COMMIT;
675:

Line 698: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_sql_stmt);

694: ||' :v_instance_id'
695: ||' from MRP_AD_SALES_ORDERS_V'||MSC_CL_PULL.v_dblink||' x'
696: ||' WHERE x.RN> :v_lrn '
697: || lv_temp_sql;
698: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_sql_stmt);
699: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
700:
701: COMMIT;
702:

Line 707: IF MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS115 THEN -- 107 or 110 source instance

703: END IF; --- MSC_CL_PULL.v_lrnn<> -1
704:
705: MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';
706:
707: IF MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS115 THEN -- 107 or 110 source instance
708: MSC_CL_PULL.v_view_name := 'MRP_AP_SALES_ORDERS_V';
709: v_temp_sql3 := ' AND (x.RN1 > :v_lrn OR x.RN2> :v_lrn OR x.RN3> :v_lrn )';
710:
711: /* Changed for the fix 2521038, */

Line 789: if MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 then

785: ||' x.FORECAST_VISIBLE,'
786: ||' x.DEMAND_VISIBLE,'
787: ||' x.SALESREP_CONTACT,';
788:
789: if MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 then
790: v_union_sql := v_union_sql ||' x.SALESREP_ID,';
791: else
792: v_union_sql := v_union_sql ||' NULL,';
793: end if;

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

824: ||' :v_refresh_id,'
825: ||' :v_instance_id, '
826: || v_temp_sql1
827: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
828: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
829: || v_temp_sql2
830: ||' and ( x.rn2 > :v_lrn ) ' ;
831:
832: v_temp_sql3 := ' AND (x.RN1 > :v_lrn ) ';

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

842: v_temp_sql := ' x.END_ITEM_UNIT_NUMBER , x.ordered_item_id,x.ORIGINAL_INVENTORY_ITEM_ID , '
843: ||' x.LINK_TO_LINE_ID, x.cust_po_number,x.customer_line_number,x.MFG_LEAD_TIME,x.FIRM_DEMAND_FLAG,x.SHIP_SET_ID,x.ARRIVAL_SET_ID,x.SHIP_SET_NAME,x.ARRIVAL_SET_NAME, ';
844:
845: IF (p_worker_num = 2 AND -- Bug 4245915
846: MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS120) THEN --bug#5684183 (bcaru)
847: v_temp_sql4 := ' AND ( x.visible_demand_flag = ''Y'' OR (x.visible_demand_flag = ''N'' AND x.order_type='''||v_msc_x_vmi_om_order_type||''')) ';
848: END IF;
849:
850: END IF; --- (p_worker_num = 4 ) condition

Line 853: IF (MSC_CL_PULL.v_apps_ver= MSC_UTIL.G_APPS110 OR

849:
850: END IF; --- (p_worker_num = 4 ) condition
851:
852:
853: IF (MSC_CL_PULL.v_apps_ver= MSC_UTIL.G_APPS110 OR
854: MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) THEN
855:
856: /* Changed for the fix 2521038, note the views MRP_AP_SALES_ORDERS_V and MRP_AN_SALES_ORDERS_V
857: have also been changed for this. Only if the source is 115 the new columns ORIGINAL_ORDERED_QUANTITY,

Line 854: MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) THEN

850: END IF; --- (p_worker_num = 4 ) condition
851:
852:
853: IF (MSC_CL_PULL.v_apps_ver= MSC_UTIL.G_APPS110 OR
854: MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) THEN
855:
856: /* Changed for the fix 2521038, note the views MRP_AP_SALES_ORDERS_V and MRP_AN_SALES_ORDERS_V
857: have also been changed for this. Only if the source is 115 the new columns ORIGINAL_ORDERED_QUANTITY,
858: ORIGINAL_COMPLETED_QUANTITY are applicable.

Line 861: IF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS110 THEN

857: have also been changed for this. Only if the source is 115 the new columns ORIGINAL_ORDERED_QUANTITY,
858: ORIGINAL_COMPLETED_QUANTITY are applicable.
859: */
860:
861: IF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS110 THEN
862:
863: v_temp_sql2 := ' AND (x.PRIMARY_UOM_QUANTITY > x.COMPLETED_QUANTITY '
864: ||' OR (x.PRIMARY_UOM_QUANTITY = x.COMPLETED_QUANTITY ';
865:

Line 868: END IF; /* MSC_UTIL.G_APPS110 */

864: ||' OR (x.PRIMARY_UOM_QUANTITY = x.COMPLETED_QUANTITY ';
865:
866: v_temp_sql2 := v_temp_sql2 ||' AND x.requirement_date >= trunc( sysdate - (' || v_msc_so_offset_days ||' )))) ';
867:
868: END IF; /* MSC_UTIL.G_APPS110 */
869:
870: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 AND (p_worker_num <> 2) THEN
871: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections
872: v_temp_sql2 := ' AND (x.ORIGINAL_ORDERED_QUANTITY >= x.ORIGINAL_COMPLETED_QUANTITY) ';

Line 870: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 AND (p_worker_num <> 2) THEN

866: v_temp_sql2 := v_temp_sql2 ||' AND x.requirement_date >= trunc( sysdate - (' || v_msc_so_offset_days ||' )))) ';
867:
868: END IF; /* MSC_UTIL.G_APPS110 */
869:
870: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 AND (p_worker_num <> 2) THEN
871: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections
872: v_temp_sql2 := ' AND (x.ORIGINAL_ORDERED_QUANTITY >= x.ORIGINAL_COMPLETED_QUANTITY) ';
873:
874: ELSE

Line 988: if MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 then

984: ||' x.FORECAST_VISIBLE,'
985: ||' x.DEMAND_VISIBLE,'
986: ||' x.SALESREP_CONTACT,';
987:
988: if MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 then
989: v_sql_stmt := v_sql_stmt ||' x.SALESREP_ID,';
990: else
991: v_sql_stmt := v_sql_stmt ||' NULL,';
992: end if;

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

1012: ||' :v_refresh_id,'
1013: ||' :v_instance_id,'
1014: || v_temp_sql1
1015: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
1016: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1017: || v_temp_sql2
1018: || v_temp_sql3
1019: || v_temp_sql4
1020: || v_union_sql ;

Line 1022: IF MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS115 THEN

1018: || v_temp_sql3
1019: || v_temp_sql4
1020: || v_union_sql ;
1021:
1022: IF MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS115 THEN
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_sql_stmt);
1024: EXECUTE IMMEDIATE v_sql_stmt
1025: USING MSC_CL_PULL.v_refresh_id,
1026: MSC_CL_PULL.v_instance_id,

Line 1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_sql_stmt);

1019: || v_temp_sql4
1020: || v_union_sql ;
1021:
1022: IF MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS115 THEN
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_sql_stmt);
1024: EXECUTE IMMEDIATE v_sql_stmt
1025: USING MSC_CL_PULL.v_refresh_id,
1026: MSC_CL_PULL.v_instance_id,
1027: MSC_CL_PULL.v_lrn,

Line 1035: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);

1031: ELSE -- 11i source instance
1032:
1033: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections
1034: if (p_worker_num = 2) then
1035: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1036: EXECUTE IMMEDIATE v_sql_stmt
1037: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1038: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1039: elsif (p_worker_num in (3)) then

Line 1040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);

1036: EXECUTE IMMEDIATE v_sql_stmt
1037: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1038: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1039: elsif (p_worker_num in (3)) then
1040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1041: EXECUTE IMMEDIATE v_sql_stmt USING
1042: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id
1043: ,MSC_CL_PULL.v_lrn,MSC_CL_PULL.v_lrn;
1044:

Line 1046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);

1042: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id
1043: ,MSC_CL_PULL.v_lrn,MSC_CL_PULL.v_lrn;
1044:
1045: else
1046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1047: EXECUTE IMMEDIATE v_sql_stmt
1048: USING MSC_CL_PULL.v_refresh_id,
1049: MSC_CL_PULL.v_instance_id,
1050: MSC_CL_PULL.v_lrn,

Line 1056: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);

1052: MSC_CL_PULL.v_lrn;
1053: end if;
1054:
1055: ELSE --- complete/targeted collections
1056: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1057: EXECUTE IMMEDIATE v_sql_stmt
1058: USING MSC_CL_PULL.v_refresh_id,
1059: MSC_CL_PULL.v_instance_id;
1060: END IF;

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

1123: ||' x.TASK_ID,'
1124: ||' x.PLANNING_GROUP,'
1125: ||' :v_instance_id'
1126: ||' FROM MRP_AP_SALES_ORDERS_V'||MSC_CL_PULL.v_dblink||' x'
1127: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1128: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1129: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1130: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1131:

Line 1132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);

1128: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1129: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1130: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1131:
1132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1133: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1134:
1135: END IF;
1136: COMMIT;

Line 1145: IF MSC_CL_PULL.HARD_RESRVS_ENABLED= MSC_UTIL.SYS_YES THEN

1141:
1142: PROCEDURE LOAD_HARD_RESERVATION IS
1143: BEGIN
1144:
1145: IF MSC_CL_PULL.HARD_RESRVS_ENABLED= MSC_UTIL.SYS_YES THEN
1146:
1147: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1148:
1149: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';

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

1148:
1149: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
1150: MSC_CL_PULL.v_view_name := 'MRP_AD_HARD_RESERVATIONS_V';
1151:
1152: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1153: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1154: ELSE
1155: v_temp_sql := NULL;
1156: END IF;

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

1149: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
1150: MSC_CL_PULL.v_view_name := 'MRP_AD_HARD_RESERVATIONS_V';
1151:
1152: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1153: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1154: ELSE
1155: v_temp_sql := NULL;
1156: END IF;
1157:

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

1175: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1176:
1177: COMMIT;
1178: /* Changes For Bug 6147734 */
1179: if (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) Then
1180: v_sql_stmt:=
1181: 'insert into MSC_ST_RESERVATIONS'
1182: ||' ( TRANSACTION_ID,'
1183: ||' SUPPLY_SOURCE_TYPE_ID,'

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

1211: COMMIT;
1212: End If; -- Srp Profile Check
1213: END IF; -- Incremental Refresh
1214:
1215: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1216: v_temp_sql := ' AND x.GET_ORDERED_QUANTITY > x.GET_SHIPPED_QUANTITY ';
1217: ELSE
1218: v_temp_sql := ' ';
1219: END IF;

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

1217: ELSE
1218: v_temp_sql := ' ';
1219: END IF;
1220:
1221: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1222: v_temp_sql1 := ' AND x.RN1 > :v_lrn';
1223: /* ds change */
1224: v_temp_sql2 := ' SUPPLY_SOURCE_HEADER_ID,SUPPLY_SOURCE_TYPE_ID, ';
1225: v_temp_sql3 := ' x.SUPPLY_SOURCE_HEADER_ID,x.SUPPLY_SOURCE_TYPE_ID, ';

Line 1282: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str|| v_temp_sql || v_temp_sql1;

1278: ||' 2,'
1279: ||' :v_refresh_id,'
1280: ||' :v_instance_id'
1281: ||' from MRP_AP_HARD_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1282: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str|| v_temp_sql || v_temp_sql1;
1283:
1284: /*||' AND (' -- NCP: x.RN1>'||MSC_CL_PULL.v_lrn
1285: ||' x.RN2>'||MSC_CL_PULL.v_lrn||')';
1286:

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

1291:
1292: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1293: -- EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1294:
1295: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1296: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1297: ELSE
1298: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn;
1299: END IF;

Line 1304: if (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) Then -- SRP Changes For Bug 5988024

1300:
1301: COMMIT;
1302:
1303:
1304: if (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) Then -- SRP Changes For Bug 5988024
1305:
1306: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1307: v_temp_sql1 := ' OR x.date1 > :date1 OR x.date2 > :date2 ';
1308: ELSE

Line 1346: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_depot_org_str

1342: ||' 2,'
1343: ||' :v_refresh_id,'
1344: ||' :v_instance_id'
1345: ||' from MRP_AP_REPAIR_TRANSFERS_RESV_V'||MSC_CL_PULL.v_dblink||' x'
1346: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_depot_org_str
1347: ||' AND x.RN1 > :v_lrn'
1348: || v_temp_sql1;
1349:
1350:

Line 1383: ||' where x.organization_id '||MSC_UTIL.v_depot_org_str

1379: ||' 1,'
1380: ||' :v_refresh_id,'
1381: ||' :v_instance_id'
1382: ||' from MRP_AP_REPAIR_ORDERS_V'||MSC_CL_PULL.v_dblink ||' x'
1383: ||' where x.organization_id '||MSC_UTIL.v_depot_org_str
1384: || ' AND x.RO_STATUS_CODE = '||'''C'''
1385: ||' AND x. LAST_UPDATE_DATE > :date1' ;
1386:
1387:

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

1432: ||' 2,'
1433: ||' :v_refresh_id,'
1434: ||' :v_instance_id'
1435: ||' from MRP_AP_EXT_REP_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1436: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
1437: ||' AND ((x.RN > :v_lrn) OR (x.RN1 > :v_lrn) OR (x.RN2 > :v_lrn) OR (x.RN3 > :v_lrn)
1438: OR (x.RN4 > :v_lrn) OR (x.RN5 > :v_lrn) OR (x.RN6 > :v_lrn))'
1439: ;
1440:

Line 1464: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND

1460:
1461: PROCEDURE LOAD_USER_DEMAND IS
1462: BEGIN
1463:
1464: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
1465: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
1466:
1467: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1468:

Line 1465: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN

1461: PROCEDURE LOAD_USER_DEMAND IS
1462: BEGIN
1463:
1464: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
1465: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
1466:
1467: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1468:
1469: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';

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

1468:
1469: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
1470: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_DEMANDS_V';
1471:
1472: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1473: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1474: ELSE
1475: v_temp_sql := NULL;
1476: END IF;

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

1469: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
1470: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_DEMANDS_V';
1471:
1472: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1473: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1474: ELSE
1475: v_temp_sql := NULL;
1476: END IF;
1477:

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

1533: ||' 2,'
1534: ||' :v_refresh_id,'
1535: ||' :v_instance_id'
1536: ||' FROM MRP_AP_USER_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
1537: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1538: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1539: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
1540:
1541: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

1694: -- ||' x.SHIPPING_METHOD_CODE,'
1695: -- ||' x.ATO_LINE_ID,'
1696: -- ||' x.ORDER_DATE_TYPE_CODE '
1697: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
1698: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1699: ||' AND x.ORIGINAL_ORDERED_QUANTITY > x.ORIGINAL_COMPLETED_QUANTITY '
1700: || v_temp_sql3 ;
1701:
1702:

Line 1725: IF MSC_CL_PULL.v_lrn = -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

1721:
1722: PROCEDURE LOAD_OPEN_PAYBACKS IS
1723: BEGIN
1724:
1725: IF MSC_CL_PULL.v_lrn = -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1726:
1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'PROCEDURE LOAD_OPEN_PAYBACKS');
1728: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPEN_PAYBACKS';
1729: MSC_CL_PULL.v_view_name := 'MRP_AP_OPEN_PAYBACK_QTY_V';

Line 1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'PROCEDURE LOAD_OPEN_PAYBACKS');

1723: BEGIN
1724:
1725: IF MSC_CL_PULL.v_lrn = -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1726:
1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'PROCEDURE LOAD_OPEN_PAYBACKS');
1728: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPEN_PAYBACKS';
1729: MSC_CL_PULL.v_view_name := 'MRP_AP_OPEN_PAYBACK_QTY_V';
1730:
1731: v_sql_stmt:=

Line 1759: ' WHERE ORGANIZATION_ID '|| MSC_UTIL.v_in_org_str;

1755: PLANNING_GROUP,
1756: LENDING_PROJ_PLANNING_GROUP,
1757: END_ITEM_UNIT_NUMBER
1758: FROM MRP_AP_OPEN_PAYBACK_QTY_V'||MSC_CL_PULL.v_dblink||
1759: ' WHERE ORGANIZATION_ID '|| MSC_UTIL.v_in_org_str;
1760:
1761: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id;
1762: COMMIT;
1763: