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_SUPPLY_PULL dependencies on MSC_UTIL

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

13: v_temp_sql4 VARCHAR2(1000);
14:
15:
16: --NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
17: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
18:
19: v_item_type_id NUMBER := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
20: v_item_type_good NUMBER := MSC_UTIL.G_PARTCONDN_GOOD;
21: v_item_type_bad NUMBER := MSC_UTIL.G_PARTCONDN_BAD;

Line 19: v_item_type_id NUMBER := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;

15:
16: --NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
17: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
18:
19: v_item_type_id NUMBER := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
20: v_item_type_good NUMBER := MSC_UTIL.G_PARTCONDN_GOOD;
21: v_item_type_bad NUMBER := MSC_UTIL.G_PARTCONDN_BAD;
22: --==================================================================
23:

Line 20: v_item_type_good NUMBER := MSC_UTIL.G_PARTCONDN_GOOD;

16: --NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
17: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
18:
19: v_item_type_id NUMBER := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
20: v_item_type_good NUMBER := MSC_UTIL.G_PARTCONDN_GOOD;
21: v_item_type_bad NUMBER := MSC_UTIL.G_PARTCONDN_BAD;
22: --==================================================================
23:
24: PROCEDURE LOAD_PO_SUPPLY IS

Line 21: v_item_type_bad NUMBER := MSC_UTIL.G_PARTCONDN_BAD;

17: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
18:
19: v_item_type_id NUMBER := MSC_UTIL.G_PARTCONDN_ITEMTYPEID;
20: v_item_type_good NUMBER := MSC_UTIL.G_PARTCONDN_GOOD;
21: v_item_type_bad NUMBER := MSC_UTIL.G_PARTCONDN_BAD;
22: --==================================================================
23:
24: PROCEDURE LOAD_PO_SUPPLY IS
25:

Line 32: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN

28: BEGIN
29:
30: lv_task_start_time := sysdate;
31:
32: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
33:
34: -- =================== DELETED DATA ======================
35:
36: --=================== Net Change Mode: Delete ==================

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

39:
40: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
41: MSC_CL_PULL.v_view_name := 'MRP_AD_PO_SUPPLIES_V';
42:
43: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
44: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
45: ELSE
46: v_temp_sql := NULL;
47: END IF;

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

40: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
41: MSC_CL_PULL.v_view_name := 'MRP_AD_PO_SUPPLIES_V';
42:
43: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
44: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
45: ELSE
46: v_temp_sql := NULL;
47: END IF;
48:

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

76:
77: /* Added this code for VMI changes */
78: Begin
79:
80: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
81: v_temp_sql := 'x.VMI_FLAG,x.VENDOR_ID,x.VENDOR_SITE_ID,x.POSTPROCESSING_LEAD_TIME,';
82: ELSE
83: v_temp_sql := 'NULL,NULL,NULL,NULL,';
84: END IF;

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

84: END IF;
85:
86: End;
87:
88: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
89: v_temp_sql1 := 'ITEM_TYPE_VALUE,';
90: v_temp_sql2 := 'DECODE(nvl(x.CONDITION_TYPE,''G''),''G'',1,''B'',2),';
91: ELSE
92: v_temp_sql1 :=NULL;

Line 179: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

175: ||' x.REQUISITION_LINE_ID,'
176: ||' :v_refresh_id,'
177: ||' :v_instance_id'
178: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'||'MRP_AP_PO_SHIP_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
179: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
180: ||' AND mpp.project_id (+)= x.project_id'
181: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'
182: ||' 1, x.MRP_TO_Organization_ID,'
183: ||' x.Organization_ID)'

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

207: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_SHIP_RCV_SUPPLY_V';
208:
209:
210: /* Added this code for VMI changes */
211: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
212: v_temp_sql := 'x.VMI_FLAG,';
213: ELSE
214: v_temp_sql := ' NULL, ';
215: END IF;

Line 286: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

282: ||' :v_refresh_id,'
283: ||' :v_instance_id'
284: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
285: ||' MRP_AP_PO_SHIP_RCV_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
286: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
287: ||' AND mpp.project_id (+)= x.project_id'
288: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'
289: ||' 1, x.MRP_TO_Organization_ID,'
290: ||' x.Organization_ID)'

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

308: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_RCV_SUPPLY_V';
309:
310: /* Added this code for VMI changes */
311: -- bug#8426490 Add postprocessing LT for Supply-(PO in Receiving), Ord Type=8
312: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
313: v_temp_sql := 'x.VMI_FLAG,x.POSTPROCESSING_LEAD_TIME,';
314: ELSE
315: v_temp_sql := ' NULL,NULL, ';
316: END IF;

Line 390: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

386: ||' :v_refresh_id,'
387: ||' :v_instance_id'
388: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
389: ||' MRP_AP_PO_RCV_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
390: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
391: ||' AND mpp.project_id (+)= x.project_id'
392: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'
393: ||' 1, x.MRP_TO_Organization_ID,'
394: ||' x.Organization_ID)'

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

410:
411: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
412: MSC_CL_PULL.v_view_name := 'MRP_AP_INTRANSIT_SUPPLIES_V';
413:
414: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
415: v_temp_sql := 'x.POSTPROCESSING_LEAD_TIME,';
416: ELSE
417: v_temp_sql := 'NULL,';
418: END IF;

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

452: ||' 2,'
453: ||' :v_refresh_id,'
454: ||' :v_instance_id'
455: ||' from MRP_AP_INTRANSIT_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
456: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
457: ||' AND (DECODE( :v_so_ship_arrive_value,'
458: ||' 1, NVL(x.arrived_flag, 2), 2)= 2)'
459: ||' AND (x.RN2>'||MSC_CL_PULL.v_lrn||')';
460:

Line 465: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 THEN

461:
462: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
463: MSC_CL_PULL.v_so_ship_arrive_value;
464:
465: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 THEN
466: v_temp_sql := ' decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),
467: decode(x.PLANNING_TP_TYPE, -1, NULL, x.PLANNING_TP_TYPE),
468: decode(x.OWNING_ORGANIZATION_ID, -1, NULL, x.OWNING_ORGANIZATION_ID),
469: decode(x.OWNING_TP_TYPE, -1, NULL, x.OWNING_TP_TYPE), ';

Line 515: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

511: ||' 2,'
512: ||' :v_refresh_id,'
513: ||' :v_instance_id'
514: ||' from MRP_AP_OH_PO_RCV_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
515: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
516:
517: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
518:
519: COMMIT;

Line 535: IF MSC_CL_PULL.OH_ENABLED= MSC_UTIL.SYS_YES THEN

531:
532:
533: -- ====================== 6: On Hand ====================
534:
535: IF MSC_CL_PULL.OH_ENABLED= MSC_UTIL.SYS_YES THEN
536:
537: --=================== Net Change Mode: Delete ==================
538:
539: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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

538:
539: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
540:
541: -- delete
542: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
543: v_temp_sql := ' x.QUANTITY, x.PROJECT_ID,x.TASK_ID,x.END_ITEM_UNIT_NUMBER,
544: decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),
545: decode(x.PLANNING_TP_TYPE, -1, NULL, x.PLANNING_TP_TYPE),
546: decode(x.OWNING_ORGANIZATION_ID, -1, NULL, x.OWNING_ORGANIZATION_ID),

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

585: || v_temp_sql --for 11i sources
586: ||' :v_refresh_id,'
587: ||' :v_instance_id'
588: ||' from MRP_AD_ONHAND_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
589: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
590: ||' AND x.RN>'||MSC_CL_PULL.v_lrn;
591:
592: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
593:

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

595:
596: -- insert/update
597:
598: /* Added this code for VMI changes */
599: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
600: v_temp_sql := ' decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),
601: decode(x.PLANNING_TP_TYPE, -1, NULL, x.PLANNING_TP_TYPE),
602: decode(x.OWNING_ORGANIZATION_ID, -1, NULL, x.OWNING_ORGANIZATION_ID),
603: decode(x.OWNING_TP_TYPE, -1, NULL, x.OWNING_TP_TYPE), ';

Line 612: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159

608:
609: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
610:
611:
612: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
613: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580
614: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
615: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN
616: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_FLEX_V';

Line 613: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580

609: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
610:
611:
612: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
613: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580
614: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
615: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN
616: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_FLEX_V';
617: END IF;

Line 615: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN

611:
612: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
613: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580
614: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
615: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN
616: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_FLEX_V';
617: END IF;
618:
619: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';

Line 627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP VIew Onhand is- incr ' || MSC_CL_PULL.v_view_name);

623: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_V';
624: v_temp_sql := v_temp_sql || ' NULL, NULL, NULL,';
625: end if;
626:
627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP VIew Onhand is- incr ' || MSC_CL_PULL.v_view_name);
628:
629:
630: v_sql_stmt:=
631: 'insert into MSC_ST_SUPPLIES'

Line 681: ||' WHERE ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

677: ||' organization_id,'
678: ||' subinventory_code,'
679: ||' lot_number'
680: ||' FROM MRP_AN_ONHAND_SUPPLIES_V'||MSC_CL_PULL.v_dblink
681: ||' WHERE ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
682: ||' AND rn>'||MSC_CL_PULL.v_lrn||') a'
683: ||' WHERE a.inventory_item_id= x.inventory_item_id'
684: ||' AND a.organization_id= x.organization_id'
685: ||' AND NVL(a.subinventory_code,'' '')= NVL( x.subinventory_code,'' '')'

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

683: ||' WHERE a.inventory_item_id= x.inventory_item_id'
684: ||' AND a.organization_id= x.organization_id'
685: ||' AND NVL(a.subinventory_code,'' '')= NVL( x.subinventory_code,'' '')'
686: ||' AND NVL(a.lot_number,'' '')= NVL( x.lot_number,'' '')';*/
687: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
688: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
689: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
690:
691: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP SQL stmt Onhand is ' || v_sql_stmt);

Line 691: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP SQL stmt Onhand is ' || v_sql_stmt);

687: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
688: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
689: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
690:
691: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP SQL stmt Onhand is ' || v_sql_stmt);
692:
693: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
694:
695: COMMIT;

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

699: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
700: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_V';
701:
702: /* Added this code for VMI changes */
703: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
704: v_temp_sql := ' decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),
705: decode(x.PLANNING_TP_TYPE, -1, NULL, x.PLANNING_TP_TYPE),
706: decode(x.OWNING_ORGANIZATION_ID, -1, NULL, x.OWNING_ORGANIZATION_ID),
707: decode(x.OWNING_TP_TYPE, -1, NULL, x.OWNING_TP_TYPE), ';

Line 716: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159

712:
713:
714: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
715:
716: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
717:
718: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580
719: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
720: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN

Line 718: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580

714: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
715:
716: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
717:
718: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580
719: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
720: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN
721: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_FLEX_V';
722: END IF;

Line 720: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN

716: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
717:
718: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580
719: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
720: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN
721: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_FLEX_V';
722: END IF;
723:
724: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';

Line 730: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP v_temp_sql ' || v_temp_sql);

726:
727: ELSE
728: v_temp_sql := v_temp_sql || ' NULL, NULL, NULL,';
729: end if;
730: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP v_temp_sql ' || v_temp_sql);
731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP VIew Onhand is targ/comp ' || MSC_CL_PULL.v_view_name);
732: v_sql_stmt:=
733: 'insert into MSC_ST_SUPPLIES'
734: ||' ( INVENTORY_ITEM_ID,'

Line 731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP VIew Onhand is targ/comp ' || MSC_CL_PULL.v_view_name);

727: ELSE
728: v_temp_sql := v_temp_sql || ' NULL, NULL, NULL,';
729: end if;
730: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP v_temp_sql ' || v_temp_sql);
731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP VIew Onhand is targ/comp ' || MSC_CL_PULL.v_view_name);
732: v_sql_stmt:=
733: 'insert into MSC_ST_SUPPLIES'
734: ||' ( INVENTORY_ITEM_ID,'
735: ||' ORGANIZATION_ID,'

Line 776: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

772: ||' 2,'
773: ||' :v_refresh_id,'
774: ||' :v_instance_id'
775: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
776: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
777:
778: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
779: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP v_sql_stmt ' || v_sql_stmt);
780: COMMIT;

Line 779: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP v_sql_stmt ' || v_sql_stmt);

775: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
776: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
777:
778: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
779: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP v_sql_stmt ' || v_sql_stmt);
780: COMMIT;
781:
782: END IF; -- incremental refresh
783:

Line 795: IF MSC_CL_PULL.MPS_ENABLED= MSC_UTIL.SYS_YES THEN

791: BEGIN
792:
793: -- ====================== 8: MPS ====================
794:
795: IF MSC_CL_PULL.MPS_ENABLED= MSC_UTIL.SYS_YES THEN
796:
797: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
798:
799: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

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

817: ||' :v_refresh_id,'
818: ||' :v_instance_id'
819: ||' from MRP_AD_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
820: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
821: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
822:
823: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
824:
825: COMMIT;

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

875: ||' :v_refresh_id,'
876: ||' :v_instance_id,'
877: ||' x.schedule_origination_type '
878: ||' from MRP_AP_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
879: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
880: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
881: ||' x.RN2>'||MSC_CL_PULL.v_lrn
882: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
883: --||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';

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

896:
897: PROCEDURE LOAD_USER_SUPPLY IS
898: BEGIN
899:
900: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
901: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
902:
903: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
904:

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

897: PROCEDURE LOAD_USER_SUPPLY IS
898: BEGIN
899:
900: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
901: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
902:
903: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
904:
905: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

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

904:
905: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
906: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_SUPPLIES_V';
907:
908: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
909: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
910: ELSE
911: v_temp_sql := NULL;
912: END IF;

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

905: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
906: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_SUPPLIES_V';
907:
908: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
909: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
910: ELSE
911: v_temp_sql := NULL;
912: END IF;
913:

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

967: ||' 2,'
968: ||' :v_refresh_id,'
969: ||' :v_instance_id'
970: ||' FROM MRP_AP_USER_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
971: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
972: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
973: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
974:
975: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 998: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN

994: BEGIN
995:
996: lv_task_start_time := sysdate;
997:
998: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
999: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1000: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
1001:
1002: /* Added this code for VMI changes */

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

999: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1000: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
1001:
1002: /* Added this code for VMI changes */
1003: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1004: v_temp_sql := 'x.VMI_FLAG,x.PO_LINE_LOCATION_ID,x.PO_DISTRIBUTION_ID, ';
1005: ELSE
1006: v_temp_sql := ' NULL,NULL,NULL, ';
1007: END IF;

Line 1010: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 6324690

1006: v_temp_sql := ' NULL,NULL,NULL, ';
1007: END IF;
1008:
1009: /* Added this code for SRP changes Bug 6324690 */
1010: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 6324690
1011: v_view_name := 'MRP_AP_PO_CSP_SUPPLY_V';
1012: v_order_type := 'x.order_type,';
1013: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1014: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';

Line 1013: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN

1009: /* Added this code for SRP changes Bug 6324690 */
1010: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 6324690
1011: v_view_name := 'MRP_AP_PO_CSP_SUPPLY_V';
1012: v_order_type := 'x.order_type,';
1013: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1014: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
1015: v_order_type := ' decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'',''),'
1016: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'')''),'
1017: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'',''),'

Line 1015: v_order_type := ' decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'',''),'

1011: v_view_name := 'MRP_AP_PO_CSP_SUPPLY_V';
1012: v_order_type := 'x.order_type,';
1013: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1014: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
1015: v_order_type := ' decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'',''),'
1016: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'')''),'
1017: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'',''),'
1018: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'')''),'
1019: || '0,1,74),74),74),74), ';

Line 1016: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'')''),'

1012: v_order_type := 'x.order_type,';
1013: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1014: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
1015: v_order_type := ' decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'',''),'
1016: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'')''),'
1017: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'',''),'
1018: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'')''),'
1019: || '0,1,74),74),74),74), ';
1020: ELSE

Line 1017: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'',''),'

1013: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1014: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
1015: v_order_type := ' decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'',''),'
1016: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'')''),'
1017: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'',''),'
1018: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'')''),'
1019: || '0,1,74),74),74),74), ';
1020: ELSE
1021: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';

Line 1018: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'')''),'

1014: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
1015: v_order_type := ' decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'',''),'
1016: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'')''),'
1017: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'',''),'
1018: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'')''),'
1019: || '0,1,74),74),74),74), ';
1020: ELSE
1021: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
1022: v_order_type := '1,';

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

1021: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
1022: v_order_type := '1,';
1023: END IF;
1024:
1025: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1026: v_coll_order_type := ' x.ORDER_TYPE, ';
1027:
1028: ELSE
1029: v_coll_order_type := ' NULL ,';

Line 1144: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1140: /* CP-ACK ends */
1141: ||' :v_instance_id'
1142: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
1143: ||v_view_name||MSC_CL_PULL.v_dblink||' x'
1144: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1145: ||' AND mpp.project_id (+)= x.project_id'
1146: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'
1147: ||' 1, x.MRP_TO_Organization_ID,'
1148: ||' x.Organization_ID)'

Line 1156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql :'||v_sql_stmt);

1152: ||' AND (' -- x.RN1>'||MSC_CL_PULL.v_lrn
1153: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1154: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1155:
1156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql :'||v_sql_stmt);
1157:
1158: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1159: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1160: MSC_CL_PULL.v_mps_consume_profile_value,

Line 1165: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,

1161: MSC_CL_PULL.v_mps_consume_profile_value,
1162: MSC_CL_PULL.v_mps_consume_profile_value,
1163: MSC_CL_PULL.v_dgmt,
1164: MSC_CL_PULL.v_refresh_id,
1165: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1166: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1167: MSC_CL_PULL.v_instance_id,
1168: MSC_CL_PULL.v_mps_consume_profile_value,
1169: MSC_CL_PULL.v_mps_consume_profile_value;

Line 1166: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,

1162: MSC_CL_PULL.v_mps_consume_profile_value,
1163: MSC_CL_PULL.v_dgmt,
1164: MSC_CL_PULL.v_refresh_id,
1165: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1166: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1167: MSC_CL_PULL.v_instance_id,
1168: MSC_CL_PULL.v_mps_consume_profile_value,
1169: MSC_CL_PULL.v_mps_consume_profile_value;
1170:

Line 1185: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN

1181: BEGIN
1182:
1183: lv_task_start_time := sysdate;
1184:
1185: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
1186: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1187: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_REQ_SUPPLY_V';
1188:
1189: /* Added this code for VMI changes */

Line 1191: Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS120,'x.VMI_FLAG,',MSC_UTIL.G_APPS115,'x.VMI_FLAG,',' NULL, ')

1187: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_REQ_SUPPLY_V';
1188:
1189: /* Added this code for VMI changes */
1190: /*Begin
1191: Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS120,'x.VMI_FLAG,',MSC_UTIL.G_APPS115,'x.VMI_FLAG,',' NULL, ')
1192: into v_temp_sql
1193: from dual;
1194: End;*/
1195:

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

1192: into v_temp_sql
1193: from dual;
1194: End;*/
1195:
1196: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1197: v_temp_sql := ' x.VMI_FLAG, x.POSTPROCESSING_LEAD_TIME, ';
1198: ELSE
1199: v_temp_sql := ' NULL, NULL, ';
1200: END IF;

Line 1210: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- condition MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 changed to MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 for 8819580

1206: Order_type is 2.4 - Normal Ireq From Good Sub inv --- Cond Good
1207: Order_type is 2.5 - Normal Ireq From BAD Sub inv --- Cond Bad
1208: Order_type is 2 - Normal Ireq without any Subinv attached --- Cond N/A
1209: */
1210: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- condition MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 changed to MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 for 8819580
1211: v_temp_sql := v_temp_sql||' decode(x.order_type,2.2,73,2.3,87,2) , ';
1212: v_temp_sql := v_temp_sql ||' decode(x.order_type,
1213: 2.1,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1214: ||',2.2,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID

Line 1213: 2.1,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID

1209: */
1210: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- condition MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 changed to MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 for 8819580
1211: v_temp_sql := v_temp_sql||' decode(x.order_type,2.2,73,2.3,87,2) , ';
1212: v_temp_sql := v_temp_sql ||' decode(x.order_type,
1213: 2.1,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1214: ||',2.2,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1215: ||',2.3,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1216: ||',2.4,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1217: ||',2.5,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID

Line 1214: ||',2.2,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID

1210: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- condition MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 changed to MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 for 8819580
1211: v_temp_sql := v_temp_sql||' decode(x.order_type,2.2,73,2.3,87,2) , ';
1212: v_temp_sql := v_temp_sql ||' decode(x.order_type,
1213: 2.1,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1214: ||',2.2,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1215: ||',2.3,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1216: ||',2.4,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1217: ||',2.5,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1218: ||') ,';

Line 1215: ||',2.3,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID

1211: v_temp_sql := v_temp_sql||' decode(x.order_type,2.2,73,2.3,87,2) , ';
1212: v_temp_sql := v_temp_sql ||' decode(x.order_type,
1213: 2.1,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1214: ||',2.2,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1215: ||',2.3,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1216: ||',2.4,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1217: ||',2.5,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1218: ||') ,';
1219: v_temp_sql :=v_temp_sql ||' decode(x.order_type,

Line 1216: ||',2.4,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID

1212: v_temp_sql := v_temp_sql ||' decode(x.order_type,
1213: 2.1,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1214: ||',2.2,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1215: ||',2.3,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1216: ||',2.4,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1217: ||',2.5,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1218: ||') ,';
1219: v_temp_sql :=v_temp_sql ||' decode(x.order_type,
1220: 2.1,'||MSC_UTIL.G_PARTCONDN_BAD

Line 1217: ||',2.5,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID

1213: 2.1,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1214: ||',2.2,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1215: ||',2.3,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1216: ||',2.4,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1217: ||',2.5,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1218: ||') ,';
1219: v_temp_sql :=v_temp_sql ||' decode(x.order_type,
1220: 2.1,'||MSC_UTIL.G_PARTCONDN_BAD
1221: ||',2.2,'||MSC_UTIL.G_PARTCONDN_GOOD

Line 1220: 2.1,'||MSC_UTIL.G_PARTCONDN_BAD

1216: ||',2.4,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1217: ||',2.5,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1218: ||') ,';
1219: v_temp_sql :=v_temp_sql ||' decode(x.order_type,
1220: 2.1,'||MSC_UTIL.G_PARTCONDN_BAD
1221: ||',2.2,'||MSC_UTIL.G_PARTCONDN_GOOD
1222: ||',2.3,'||MSC_UTIL.G_PARTCONDN_GOOD
1223: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD
1224: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD

Line 1221: ||',2.2,'||MSC_UTIL.G_PARTCONDN_GOOD

1217: ||',2.5,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1218: ||') ,';
1219: v_temp_sql :=v_temp_sql ||' decode(x.order_type,
1220: 2.1,'||MSC_UTIL.G_PARTCONDN_BAD
1221: ||',2.2,'||MSC_UTIL.G_PARTCONDN_GOOD
1222: ||',2.3,'||MSC_UTIL.G_PARTCONDN_GOOD
1223: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD
1224: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD
1225: || '), ';

Line 1222: ||',2.3,'||MSC_UTIL.G_PARTCONDN_GOOD

1218: ||') ,';
1219: v_temp_sql :=v_temp_sql ||' decode(x.order_type,
1220: 2.1,'||MSC_UTIL.G_PARTCONDN_BAD
1221: ||',2.2,'||MSC_UTIL.G_PARTCONDN_GOOD
1222: ||',2.3,'||MSC_UTIL.G_PARTCONDN_GOOD
1223: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD
1224: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD
1225: || '), ';
1226: /* ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN

Line 1223: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD

1219: v_temp_sql :=v_temp_sql ||' decode(x.order_type,
1220: 2.1,'||MSC_UTIL.G_PARTCONDN_BAD
1221: ||',2.2,'||MSC_UTIL.G_PARTCONDN_GOOD
1222: ||',2.3,'||MSC_UTIL.G_PARTCONDN_GOOD
1223: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD
1224: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD
1225: || '), ';
1226: /* ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1227: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'

Line 1224: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD

1220: 2.1,'||MSC_UTIL.G_PARTCONDN_BAD
1221: ||',2.2,'||MSC_UTIL.G_PARTCONDN_GOOD
1222: ||',2.3,'||MSC_UTIL.G_PARTCONDN_GOOD
1223: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD
1224: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD
1225: || '), ';
1226: /* ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1227: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'
1228: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'')''), '

Line 1226: /* ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN

1222: ||',2.3,'||MSC_UTIL.G_PARTCONDN_GOOD
1223: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD
1224: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD
1225: || '), ';
1226: /* ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1227: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'
1228: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'')''), '
1229: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'',''), '
1230: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'')''), '

Line 1227: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'

1223: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD
1224: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD
1225: || '), ';
1226: /* ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1227: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'
1228: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'')''), '
1229: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'',''), '
1230: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'')''), '
1231: || '0,2,73),73),73),73) , NULL,NULL, '; */ --- commented for 8819580

Line 1228: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'')''), '

1224: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD
1225: || '), ';
1226: /* ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1227: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'
1228: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'')''), '
1229: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'',''), '
1230: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'')''), '
1231: || '0,2,73),73),73),73) , NULL,NULL, '; */ --- commented for 8819580
1232: ELSE

Line 1229: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'',''), '

1225: || '), ';
1226: /* ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1227: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'
1228: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'')''), '
1229: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'',''), '
1230: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'')''), '
1231: || '0,2,73),73),73),73) , NULL,NULL, '; */ --- commented for 8819580
1232: ELSE
1233: v_temp_sql := v_temp_sql||' 2,NULL,NULL, ';

Line 1230: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'')''), '

1226: /* ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1227: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'
1228: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'')''), '
1229: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'',''), '
1230: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'')''), '
1231: || '0,2,73),73),73),73) , NULL,NULL, '; */ --- commented for 8819580
1232: ELSE
1233: v_temp_sql := v_temp_sql||' 2,NULL,NULL, ';
1234: END IF;

Line 1323: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1319: /* CP change starts */
1320: ||' :v_instance_id'
1321: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
1322: ||' MRP_AP_PO_REQ_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
1323: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1324: ||' AND mpp.project_id (+)= x.project_id'
1325: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'
1326: ||' 1, x.MRP_TO_Organization_ID,'
1327: ||' x.Organization_ID)'

Line 1334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);

1330: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
1331: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
1332: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1333: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);
1335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1336: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1337: MSC_CL_PULL.v_mps_consume_profile_value,
1338: MSC_CL_PULL.v_mps_consume_profile_value,