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 79: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

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

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

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

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

175: ||' :v_refresh_id,'
176: ||' :v_instance_id'
177: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
178: ||' 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 311: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

307: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
308: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_RCV_SUPPLY_V';
309:
310: /* Added this code for VMI changes */
311: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
312: v_temp_sql := 'x.VMI_FLAG,';
313: ELSE
314: v_temp_sql := ' NULL, ';
315: END IF;

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

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

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

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

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

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

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

474:
475:
476: -- ====================== 6: On Hand ====================
477:
478: IF MSC_CL_PULL.OH_ENABLED= MSC_UTIL.SYS_YES THEN
479:
480: --=================== Net Change Mode: Delete ==================
481:
482: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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

481:
482: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
483:
484: -- delete
485: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
486: v_temp_sql := ' x.QUANTITY, x.PROJECT_ID,x.TASK_ID,x.END_ITEM_UNIT_NUMBER,
487: decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),
488: decode(x.PLANNING_TP_TYPE, -1, NULL, x.PLANNING_TP_TYPE),
489: decode(x.OWNING_ORGANIZATION_ID, -1, NULL, x.OWNING_ORGANIZATION_ID),

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

528: || v_temp_sql --for 11i sources
529: ||' :v_refresh_id,'
530: ||' :v_instance_id'
531: ||' from MRP_AD_ONHAND_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
532: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
533: ||' AND x.RN>'||MSC_CL_PULL.v_lrn;
534:
535: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
536:

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

538:
539: -- insert/update
540:
541: /* Added this code for VMI changes */
542: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
543: v_temp_sql := ' decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),
544: decode(x.PLANNING_TP_TYPE, -1, NULL, x.PLANNING_TP_TYPE),
545: decode(x.OWNING_ORGANIZATION_ID, -1, NULL, x.OWNING_ORGANIZATION_ID),
546: decode(x.OWNING_TP_TYPE, -1, NULL, x.OWNING_TP_TYPE), ';

Line 554: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159

550: END IF;
551:
552: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
553:
554: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
555: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
556: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';
557: v_temp_sql := v_temp_sql ||'x.SR_CUSTOMER_ACCT_ID,'||v_item_type_id ||v_Decode;
558:

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

612: ||' organization_id,'
613: ||' subinventory_code,'
614: ||' lot_number'
615: ||' FROM MRP_AN_ONHAND_SUPPLIES_V'||MSC_CL_PULL.v_dblink
616: ||' WHERE ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
617: ||' AND rn>'||MSC_CL_PULL.v_lrn||') a'
618: ||' WHERE a.inventory_item_id= x.inventory_item_id'
619: ||' AND a.organization_id= x.organization_id'
620: ||' AND NVL(a.subinventory_code,'' '')= NVL( x.subinventory_code,'' '')'

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

618: ||' WHERE a.inventory_item_id= x.inventory_item_id'
619: ||' AND a.organization_id= x.organization_id'
620: ||' AND NVL(a.subinventory_code,'' '')= NVL( x.subinventory_code,'' '')'
621: ||' AND NVL(a.lot_number,'' '')= NVL( x.lot_number,'' '')';*/
622: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
623: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
624: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
625:
626: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

632: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
633: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_V';
634:
635: /* Added this code for VMI changes */
636: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
637: v_temp_sql := ' decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),
638: decode(x.PLANNING_TP_TYPE, -1, NULL, x.PLANNING_TP_TYPE),
639: decode(x.OWNING_ORGANIZATION_ID, -1, NULL, x.OWNING_ORGANIZATION_ID),
640: decode(x.OWNING_TP_TYPE, -1, NULL, x.OWNING_TP_TYPE), ';

Line 649: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159

645:
646:
647: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
648:
649: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
650: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
651: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';
652: v_temp_sql := v_temp_sql ||'x.SR_CUSTOMER_ACCT_ID,'||v_item_type_id ||v_Decode;
653:

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

700: ||' 2,'
701: ||' :v_refresh_id,'
702: ||' :v_instance_id'
703: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
704: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
705:
706: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
707:
708: COMMIT;

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

719: BEGIN
720:
721: -- ====================== 8: MPS ====================
722:
723: IF MSC_CL_PULL.MPS_ENABLED= MSC_UTIL.SYS_YES THEN
724:
725: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
726:
727: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

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

745: ||' :v_refresh_id,'
746: ||' :v_instance_id'
747: ||' from MRP_AD_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
748: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
749: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
750:
751: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
752:
753: COMMIT;

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

803: ||' :v_refresh_id,'
804: ||' :v_instance_id,'
805: ||' x.schedule_origination_type '
806: ||' from MRP_AP_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
807: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
808: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
809: ||' x.RN2>'||MSC_CL_PULL.v_lrn
810: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
811: --||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';

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

824:
825: PROCEDURE LOAD_USER_SUPPLY IS
826: BEGIN
827:
828: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
829: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
830:
831: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
832:

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

825: PROCEDURE LOAD_USER_SUPPLY IS
826: BEGIN
827:
828: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
829: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
830:
831: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
832:
833: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

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

832:
833: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
834: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_SUPPLIES_V';
835:
836: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
837: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
838: ELSE
839: v_temp_sql := NULL;
840: END IF;

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

833: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
834: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_SUPPLIES_V';
835:
836: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
837: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
838: ELSE
839: v_temp_sql := NULL;
840: END IF;
841:

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

895: ||' 2,'
896: ||' :v_refresh_id,'
897: ||' :v_instance_id'
898: ||' FROM MRP_AP_USER_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
899: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
900: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
901: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
902:
903: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

920: BEGIN
921:
922: lv_task_start_time := sysdate;
923:
924: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
925: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
926: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
927:
928: /* Added this code for VMI changes */

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

925: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
926: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
927:
928: /* Added this code for VMI changes */
929: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
930: v_temp_sql := 'x.VMI_FLAG,x.PO_LINE_LOCATION_ID,x.PO_DISTRIBUTION_ID, ';
931: ELSE
932: v_temp_sql := ' NULL,NULL,NULL, ';
933: END IF;

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

932: v_temp_sql := ' NULL,NULL,NULL, ';
933: END IF;
934:
935: /* Added this code for SRP changes Bug 6324690 */
936: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 6324690
937: v_view_name := 'MRP_AP_PO_CSP_SUPPLY_V';
938: v_order_type := 'x.order_type,';
939: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
940: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';

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

935: /* Added this code for SRP changes Bug 6324690 */
936: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 6324690
937: v_view_name := 'MRP_AP_PO_CSP_SUPPLY_V';
938: v_order_type := 'x.order_type,';
939: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
940: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
941: v_order_type := ' decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'',''),'
942: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'')''),'
943: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'',''),'

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

937: v_view_name := 'MRP_AP_PO_CSP_SUPPLY_V';
938: v_order_type := 'x.order_type,';
939: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
940: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
941: v_order_type := ' decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'',''),'
942: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'')''),'
943: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'',''),'
944: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'')''),'
945: || '0,1,74),74),74),74), ';

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

938: v_order_type := 'x.order_type,';
939: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
940: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
941: v_order_type := ' decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'',''),'
942: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'')''),'
943: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'',''),'
944: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'')''),'
945: || '0,1,74),74),74),74), ';
946: ELSE

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

939: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
940: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
941: v_order_type := ' decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'',''),'
942: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'')''),'
943: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'',''),'
944: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'')''),'
945: || '0,1,74),74),74),74), ';
946: ELSE
947: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';

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

940: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
941: v_order_type := ' decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'',''),'
942: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'')''),'
943: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'',''),'
944: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'')''),'
945: || '0,1,74),74),74),74), ';
946: ELSE
947: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
948: v_order_type := '1,';

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

1056: /* CP-ACK ends */
1057: ||' :v_instance_id'
1058: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
1059: ||v_view_name||MSC_CL_PULL.v_dblink||' x'
1060: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1061: ||' AND mpp.project_id (+)= x.project_id'
1062: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'
1063: ||' 1, x.MRP_TO_Organization_ID,'
1064: ||' x.Organization_ID)'

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

1068: ||' AND (' -- x.RN1>'||MSC_CL_PULL.v_lrn
1069: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1070: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1071:
1072: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql :'||v_sql_stmt);
1073:
1074: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1075: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1076: MSC_CL_PULL.v_mps_consume_profile_value,

Line 1081: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,

1077: MSC_CL_PULL.v_mps_consume_profile_value,
1078: MSC_CL_PULL.v_mps_consume_profile_value,
1079: MSC_CL_PULL.v_dgmt,
1080: MSC_CL_PULL.v_refresh_id,
1081: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1082: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1083: MSC_CL_PULL.v_instance_id,
1084: MSC_CL_PULL.v_mps_consume_profile_value,
1085: MSC_CL_PULL.v_mps_consume_profile_value;

Line 1082: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,

1078: MSC_CL_PULL.v_mps_consume_profile_value,
1079: MSC_CL_PULL.v_dgmt,
1080: MSC_CL_PULL.v_refresh_id,
1081: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1082: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1083: MSC_CL_PULL.v_instance_id,
1084: MSC_CL_PULL.v_mps_consume_profile_value,
1085: MSC_CL_PULL.v_mps_consume_profile_value;
1086:

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

1097: BEGIN
1098:
1099: lv_task_start_time := sysdate;
1100:
1101: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
1102: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1103: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_REQ_SUPPLY_V';
1104:
1105: /* Added this code for VMI changes */

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

1103: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_REQ_SUPPLY_V';
1104:
1105: /* Added this code for VMI changes */
1106: /*Begin
1107: Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS120,'x.VMI_FLAG,',MSC_UTIL.G_APPS115,'x.VMI_FLAG,',' NULL, ')
1108: into v_temp_sql
1109: from dual;
1110: End;*/
1111:

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

1108: into v_temp_sql
1109: from dual;
1110: End;*/
1111:
1112: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1113: v_temp_sql := ' x.VMI_FLAG, x.POSTPROCESSING_LEAD_TIME, ';
1114: ELSE
1115: v_temp_sql := ' NULL, NULL, ';
1116: END IF;

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

1122: Order_type is 2.4 - Normal Ireq From Good Sub inv --- Cond Good
1123: Order_type is 2.5 - Normal Ireq From BAD Sub inv --- Cond Bad
1124: Order_type is 2 - Normal Ireq without any Subinv attached --- Cond N/A
1125: */
1126: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1127: v_temp_sql := v_temp_sql||' decode(x.order_type,2.2,73,2.3,87,2) , ';
1128: v_temp_sql := v_temp_sql ||' decode(x.order_type,
1129: 2.1,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1130: ||',2.2,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID

Line 1129: 2.1,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID

1125: */
1126: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1127: v_temp_sql := v_temp_sql||' decode(x.order_type,2.2,73,2.3,87,2) , ';
1128: v_temp_sql := v_temp_sql ||' decode(x.order_type,
1129: 2.1,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1130: ||',2.2,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1131: ||',2.3,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1132: ||',2.4,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1133: ||',2.5,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID

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

1126: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1127: v_temp_sql := v_temp_sql||' decode(x.order_type,2.2,73,2.3,87,2) , ';
1128: v_temp_sql := v_temp_sql ||' decode(x.order_type,
1129: 2.1,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1130: ||',2.2,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1131: ||',2.3,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1132: ||',2.4,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1133: ||',2.5,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1134: ||') ,';

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

1127: v_temp_sql := v_temp_sql||' decode(x.order_type,2.2,73,2.3,87,2) , ';
1128: v_temp_sql := v_temp_sql ||' decode(x.order_type,
1129: 2.1,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1130: ||',2.2,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1131: ||',2.3,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1132: ||',2.4,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1133: ||',2.5,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1134: ||') ,';
1135: v_temp_sql :=v_temp_sql ||' decode(x.order_type,

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

1128: v_temp_sql := v_temp_sql ||' decode(x.order_type,
1129: 2.1,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1130: ||',2.2,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1131: ||',2.3,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1132: ||',2.4,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1133: ||',2.5,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1134: ||') ,';
1135: v_temp_sql :=v_temp_sql ||' decode(x.order_type,
1136: 2.1,'||MSC_UTIL.G_PARTCONDN_BAD

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

1129: 2.1,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1130: ||',2.2,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1131: ||',2.3,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1132: ||',2.4,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1133: ||',2.5,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1134: ||') ,';
1135: v_temp_sql :=v_temp_sql ||' decode(x.order_type,
1136: 2.1,'||MSC_UTIL.G_PARTCONDN_BAD
1137: ||',2.2,'||MSC_UTIL.G_PARTCONDN_GOOD

Line 1136: 2.1,'||MSC_UTIL.G_PARTCONDN_BAD

1132: ||',2.4,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1133: ||',2.5,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1134: ||') ,';
1135: v_temp_sql :=v_temp_sql ||' decode(x.order_type,
1136: 2.1,'||MSC_UTIL.G_PARTCONDN_BAD
1137: ||',2.2,'||MSC_UTIL.G_PARTCONDN_GOOD
1138: ||',2.3,'||MSC_UTIL.G_PARTCONDN_GOOD
1139: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD
1140: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD

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

1133: ||',2.5,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1134: ||') ,';
1135: v_temp_sql :=v_temp_sql ||' decode(x.order_type,
1136: 2.1,'||MSC_UTIL.G_PARTCONDN_BAD
1137: ||',2.2,'||MSC_UTIL.G_PARTCONDN_GOOD
1138: ||',2.3,'||MSC_UTIL.G_PARTCONDN_GOOD
1139: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD
1140: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD
1141: || '), ';

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

1134: ||') ,';
1135: v_temp_sql :=v_temp_sql ||' decode(x.order_type,
1136: 2.1,'||MSC_UTIL.G_PARTCONDN_BAD
1137: ||',2.2,'||MSC_UTIL.G_PARTCONDN_GOOD
1138: ||',2.3,'||MSC_UTIL.G_PARTCONDN_GOOD
1139: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD
1140: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD
1141: || '), ';
1142: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN

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

1135: v_temp_sql :=v_temp_sql ||' decode(x.order_type,
1136: 2.1,'||MSC_UTIL.G_PARTCONDN_BAD
1137: ||',2.2,'||MSC_UTIL.G_PARTCONDN_GOOD
1138: ||',2.3,'||MSC_UTIL.G_PARTCONDN_GOOD
1139: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD
1140: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD
1141: || '), ';
1142: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1143: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'

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

1136: 2.1,'||MSC_UTIL.G_PARTCONDN_BAD
1137: ||',2.2,'||MSC_UTIL.G_PARTCONDN_GOOD
1138: ||',2.3,'||MSC_UTIL.G_PARTCONDN_GOOD
1139: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD
1140: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD
1141: || '), ';
1142: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1143: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'
1144: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'')''), '

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

1138: ||',2.3,'||MSC_UTIL.G_PARTCONDN_GOOD
1139: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD
1140: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD
1141: || '), ';
1142: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1143: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'
1144: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'')''), '
1145: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'',''), '
1146: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'')''), '

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

1139: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD
1140: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD
1141: || '), ';
1142: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1143: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'
1144: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'')''), '
1145: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'',''), '
1146: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'')''), '
1147: || '0,2,73),73),73),73) , NULL,NULL, ';

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

1140: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD
1141: || '), ';
1142: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1143: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'
1144: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'')''), '
1145: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'',''), '
1146: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'')''), '
1147: || '0,2,73),73),73),73) , NULL,NULL, ';
1148: ELSE

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

1141: || '), ';
1142: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1143: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'
1144: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'')''), '
1145: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'',''), '
1146: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'')''), '
1147: || '0,2,73),73),73),73) , NULL,NULL, ';
1148: ELSE
1149: v_temp_sql := v_temp_sql||' 2,NULL,NULL, ';

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

1142: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1143: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'
1144: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'')''), '
1145: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'',''), '
1146: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'')''), '
1147: || '0,2,73),73),73),73) , NULL,NULL, ';
1148: ELSE
1149: v_temp_sql := v_temp_sql||' 2,NULL,NULL, ';
1150: END IF;

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

1235: /* CP change starts */
1236: ||' :v_instance_id'
1237: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
1238: ||' MRP_AP_PO_REQ_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
1239: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1240: ||' AND mpp.project_id (+)= x.project_id'
1241: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'
1242: ||' 1, x.MRP_TO_Organization_ID,'
1243: ||' x.Organization_ID)'

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

1246: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
1247: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
1248: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1249: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);
1251: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1252: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1253: MSC_CL_PULL.v_mps_consume_profile_value,
1254: MSC_CL_PULL.v_mps_consume_profile_value,