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 577: FROM MSC_APPS_INSTANCES

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

Line 588: FROM MSC_APPS_INSTANCES

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

Line 652: FROM MSC_APPS_INSTANCES

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

Line 704: FROM MSC_APPS_INSTANCES

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