APPS.MSC_CL_ROUTING_PULL dependencies on MSC_APPS_INSTANCES

Line 422: FROM MSC_APPS_INSTANCES

418: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
419: BEGIN
420: SELECT APPS_VER
421: INTO v_get_apps_ver
422: FROM MSC_APPS_INSTANCES
423: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;
424: END;
425: --=================== Net Change Mode: Delete ==================
426: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 576: FROM MSC_APPS_INSTANCES

572: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
573: BEGIN
574: SELECT APPS_VER
575: INTO V_GET_APPS_VER
576: FROM MSC_APPS_INSTANCES
577: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;
578: END;
579: --=================== Net Change Mode: Delete ==================
580: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 587: FROM MSC_APPS_INSTANCES

583: MSC_CL_PULL.v_view_name := 'MRP_AD_OPERATION_RESOURCES_V';
584: BEGIN
585: SELECT APPS_VER
586: INTO V_GET_APPS_VER
587: FROM MSC_APPS_INSTANCES
588: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;
589: END;
590:
591: if v_get_apps_ver >= 3

Line 651: FROM MSC_APPS_INSTANCES

647:
648: BEGIN
649: SELECT APPS_VER
650: INTO V_GET_APPS_VER
651: FROM MSC_APPS_INSTANCES
652: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;
653: END;
654:
655: if V_GET_APPS_VER >= 3

Line 703: FROM MSC_APPS_INSTANCES

699:
700: BEGIN
701: SELECT APPS_VER
702: INTO V_GET_APPS_VER
703: FROM MSC_APPS_INSTANCES
704: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;
705: END;
706:
707: if v_get_apps_ver >= 3