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_PULL dependencies on MSC_APPS_INSTANCES

Line 902: FROM MSC_APPS_INSTANCES

898: '@'||M2A_DBLINK),
899: LAST_TGT_CONT_COLL_TIME
900: INTO v_dblink,
901: lv_last_tgt_cont_coll_time
902: FROM MSC_APPS_INSTANCES
903: WHERE INSTANCE_ID= p_instance_id;
904:
905: EXCEPTION
906: WHEN NO_DATA_FOUND THEN

Line 1006: FROM MSC_APPS_INSTANCES

1002: --then append all the OPM orgs
1003: BEGIN
1004: SELECT DECODE(M2A_DBLINK,NULL,NULL_DBLINK,'@'||M2A_DBLINK)
1005: INTO lv_dblink
1006: FROM MSC_APPS_INSTANCES
1007: WHERE INSTANCE_ID= p_instance_id;
1008:
1009: EXCEPTION
1010: WHEN NO_DATA_FOUND THEN

Line 1256: FROM MSC_APPS_INSTANCES

1252: v_distributed_config_flag,
1253: lv_apps_ver,
1254: v_lrnn,
1255: v_so_lrn
1256: FROM MSC_APPS_INSTANCES
1257: WHERE INSTANCE_ID= pINSTANCE_ID;
1258:
1259: EXCEPTION
1260:

Line 2092: FROM MSC_APPS_INSTANCES

2088: v_instance_type,
2089: v_apps_ver,
2090: lv_last_tgt_cont_coll_time,
2091: v_instance_code
2092: FROM MSC_APPS_INSTANCES
2093: WHERE INSTANCE_ID= pINSTANCE_ID;
2094:
2095: IF (v_apps_ver = MSC_UTIL.G_APPS120) THEN --bug#5684183 (bcaru)
2096: prec.payback_demand_supply_flag := MSC_UTIL.SYS_NO;

Line 2125: lv_sql_stmt:= 'update msc_apps_instances set LBJ_DETAILS = (select decode(to_number(FND_PROFILE.VALUE' || v_dblink || '(''WSM_CREATE_LBJ_COPY_ROUTING'')),1,1,2) from dual' || ' ) '

2121: END IF;
2122:
2123: If pRTYPE = MSC_UTIL.G_COMPLETE Then
2124: IF v_apps_ver >= MSC_UTIL.G_APPS115 Then
2125: lv_sql_stmt:= 'update msc_apps_instances set LBJ_DETAILS = (select decode(to_number(FND_PROFILE.VALUE' || v_dblink || '(''WSM_CREATE_LBJ_COPY_ROUTING'')),1,1,2) from dual' || ' ) '
2126: || ' where instance_id = ' || pINSTANCE_ID ;
2127: ELSE
2128: lv_sql_stmt:= 'update msc_apps_instances set LBJ_DETAILS = 2 '
2129: || ' where instance_id = ' || pINSTANCE_ID ;

Line 2128: lv_sql_stmt:= 'update msc_apps_instances set LBJ_DETAILS = 2 '

2124: IF v_apps_ver >= MSC_UTIL.G_APPS115 Then
2125: lv_sql_stmt:= 'update msc_apps_instances set LBJ_DETAILS = (select decode(to_number(FND_PROFILE.VALUE' || v_dblink || '(''WSM_CREATE_LBJ_COPY_ROUTING'')),1,1,2) from dual' || ' ) '
2126: || ' where instance_id = ' || pINSTANCE_ID ;
2127: ELSE
2128: lv_sql_stmt:= 'update msc_apps_instances set LBJ_DETAILS = 2 '
2129: || ' where instance_id = ' || pINSTANCE_ID ;
2130: END IF;
2131:
2132: EXECUTE IMMEDIATE lv_sql_stmt;

Line 2200: FROM MSC_APPS_INSTANCES

2196:
2197:
2198: SELECT FND_GLOBAL.USER_ID
2199: INTO v_current_user
2200: FROM MSC_APPS_INSTANCES
2201: WHERE INSTANCE_ID= pINSTANCE_ID;
2202:
2203: -- To be called only at the first run.
2204: IF (v_req_data is null) THEN -- for the fix 2351297

Line 2217: UPDATE msc_apps_instances

2213: WHEN OTHERS THEN
2214: lv_pjm_enabled := NULL;
2215: END;
2216:
2217: UPDATE msc_apps_instances
2218: SET lrtype = DECODE ( pRTYPE, MSC_UTIL.G_COMPLETE, 'C',
2219: MSC_UTIL.G_INCREMENTAL, 'I',
2220: MSC_UTIL.G_PARTIAL, 'P',
2221: MSC_UTIL.G_CONT, 'T'),

Line 2225: -- Indicate the data pull type in MSC_APPS_INSTANCES

2221: MSC_UTIL.G_CONT, 'T'),
2222: pjm_enabled = lv_pjm_enabled
2223: WHERE instance_id = pINSTANCE_ID;
2224:
2225: -- Indicate the data pull type in MSC_APPS_INSTANCES
2226:
2227: SELECT count(*)
2228: INTO lv_param_rec_count
2229: FROM msc_coll_parameters

Line 2272: FROM msc_apps_instances

2268: ELSE
2269:
2270: SELECT st_status
2271: INTO lv_coll_stat
2272: FROM msc_apps_instances
2273: WHERE instance_id = pINSTANCE_ID;
2274:
2275: IF lv_coll_stat = MSC_UTIL.G_ST_EMPTY THEN
2276:

Line 2350: FROM MSC_APPS_INSTANCES

2346: INSTANCE_TYPE
2347: INTO v_dblink,
2348: lv_dest_a2m, -- bug fix for 2320600
2349: v_instance_type
2350: FROM MSC_APPS_INSTANCES
2351: WHERE INSTANCE_ID= pINSTANCE_ID;
2352:
2353: -- To Check if the refresh type is partial(ie Targetted)
2354: -- the a2m_dblink on the destination should be in sync with

Line 2459: UPDATE MSC_APPS_INSTANCES

2455: COMMIT;
2456: END IF;
2457:
2458: IF lv_check_point =2 THEN
2459: UPDATE MSC_APPS_INSTANCES
2460: SET SO_TBL_STATUS = decode(pSalesOrder_RTYPE,MSC_UTIL.SYS_YES
2461: ,decode(pRTYPE,MSC_UTIL.G_COMPLETE,decode(lv_inv_ctp_val,5,MSC_UTIL.SYS_YES,SO_TBL_STATUS),MSC_UTIL.G_PARTIAL,decode(lv_inv_ctp_val,5,MSC_UTIL.SYS_YES,SO_TBL_STATUS),SO_TBL_STATUS),
2462: SO_TBL_STATUS)
2463: WHERE INSTANCE_ID= pINSTANCE_ID;

Line 2497: UPDATE MSC_APPS_INSTANCES

2493: ||' AND nvl(mar.A2M_DBLINK, '''||NULL_DBLINK||''' ) = '''||v_dest_a2m||'''';
2494:
2495: EXECUTE IMMEDIATE v_sql_stmt INTO v_crn, v_validation_org_id;
2496:
2497: UPDATE MSC_APPS_INSTANCES
2498: SET VALIDATION_ORG_ID = v_validation_org_id
2499: WHERE INSTANCE_ID = pINSTANCE_ID;
2500:
2501: ELSE

Line 2676: UPDATE msc_apps_instances

2672: nosnap_flag = prec.nosnap_flag,
2673: trip_sn_flag = prec.trip_sn_flag
2674: WHERE INSTANCE_ID=pINSTANCE_ID;
2675:
2676: UPDATE msc_apps_instances
2677: SET SO_TBL_STATUS = decode (prec.so_sn_flag,MSC_UTIL.SYS_TGT,MSC_UTIL.SYS_NO,SO_TBL_STATUS)
2678: WHERE INSTANCE_ID=pINSTANCE_ID;
2679:
2680: COMMIT;

Line 2827: UPDATE MSC_APPS_INSTANCES

2823: COMMIT;
2824: END IF;
2825:
2826: IF lv_check_point =2 THEN
2827: UPDATE MSC_APPS_INSTANCES
2828: SET SO_TBL_STATUS = decode(pSalesOrder_RTYPE,MSC_UTIL.SYS_YES
2829: ,decode(pRTYPE,MSC_UTIL.G_COMPLETE,decode(lv_inv_ctp_val,5,MSC_UTIL.SYS_YES,SO_TBL_STATUS),MSC_UTIL.G_PARTIAL,decode(lv_inv_ctp_val,5,MSC_UTIL.SYS_YES,SO_TBL_STATUS),SO_TBL_STATUS),
2830: SO_TBL_STATUS)
2831: WHERE INSTANCE_ID= pINSTANCE_ID;

Line 3174: UPDATE MSC_APPS_INSTANCES

3170: pINSTANCE_ID, MSC_UTIL.G_ST_EMPTY) THEN
3171: COMMIT;
3172: END IF;
3173:
3174: UPDATE MSC_APPS_INSTANCES
3175: SET SO_TBL_STATUS = decode(pSalesOrder_RTYPE,MSC_UTIL.SYS_YES
3176: ,decode(pRTYPE,MSC_UTIL.G_COMPLETE,decode(lv_inv_ctp_val,5,MSC_UTIL.SYS_YES,SO_TBL_STATUS),MSC_UTIL.G_PARTIAL,decode(lv_inv_ctp_val,5,MSC_UTIL.SYS_YES,SO_TBL_STATUS),SO_TBL_STATUS),
3177: SO_TBL_STATUS)
3178: WHERE INSTANCE_ID= pINSTANCE_ID;

Line 3264: UPDATE MSC_APPS_INSTANCES

3260: pINSTANCE_ID, MSC_UTIL.G_ST_EMPTY) THEN
3261: COMMIT;
3262: END IF;
3263:
3264: UPDATE MSC_APPS_INSTANCES
3265: SET SO_TBL_STATUS = decode(pSalesOrder_RTYPE,MSC_UTIL.SYS_YES
3266: ,decode(pRTYPE,MSC_UTIL.G_COMPLETE,decode(lv_inv_ctp_val,5,MSC_UTIL.SYS_YES,SO_TBL_STATUS),MSC_UTIL.G_PARTIAL,decode(lv_inv_ctp_val,5,MSC_UTIL.SYS_YES,SO_TBL_STATUS),SO_TBL_STATUS),
3267: SO_TBL_STATUS)
3268: WHERE INSTANCE_ID= pINSTANCE_ID;

Line 3293: UPDATE MSC_APPS_INSTANCES

3289: pINSTANCE_ID, MSC_UTIL.G_ST_EMPTY) THEN
3290: COMMIT;
3291: END IF;
3292:
3293: UPDATE MSC_APPS_INSTANCES
3294: SET SO_TBL_STATUS = decode(pSalesOrder_RTYPE,MSC_UTIL.SYS_YES
3295: ,decode(pRTYPE,MSC_UTIL.G_COMPLETE,decode(lv_inv_ctp_val,5,MSC_UTIL.SYS_YES,SO_TBL_STATUS),MSC_UTIL.G_PARTIAL,decode(lv_inv_ctp_val,5,MSC_UTIL.SYS_YES,SO_TBL_STATUS),SO_TBL_STATUS),
3296: SO_TBL_STATUS)
3297: WHERE INSTANCE_ID= pINSTANCE_ID;

Line 3795: from msc_apps_instances

3791: /* We will pass apps_lrn for the entity lrn, if it is NULL */
3792:
3793: select apps_lrn
3794: into lv_apps_lrn
3795: from msc_apps_instances
3796: where instance_id = p_instance_id;
3797:
3798: select min(nvl(supplier_capacity_lrn,lv_apps_lrn)),
3799: min(nvl(bom_lrn,lv_apps_lrn)),

Line 4152: FROM MSC_APPS_INSTANCES mai

4148: SELECT mai.ENABLE_FLAG,
4149: mai.ST_STATUS,
4150: DECODE(mai.LRTYPE,'C',MSC_UTIL.G_COMPLETE,'P',MSC_UTIL.G_PARTIAL,'I',MSC_UTIL.G_INCREMENTAL,'T',MSC_UTIL.G_CONT)
4151: INTO lv_instance_enabled, lv_staging_table_status,lv_refresh_type
4152: FROM MSC_APPS_INSTANCES mai
4153: WHERE mai.INSTANCE_ID= pINSTANCE_ID
4154: FOR UPDATE;
4155:
4156: IF lv_instance_enabled= MSC_UTIL.SYS_YES THEN

Line 4174: UPDATE MSC_APPS_INSTANCES

4170: END;
4171: END IF;
4172: /* for bug:2605884 ,added the decode in updating so_tbl_status=2 if ODS ATP and complete
4173: refresh of the sales orders */
4174: UPDATE MSC_APPS_INSTANCES
4175: SET ST_STATUS= MSC_UTIL.G_ST_PULLING,
4176: SO_TBL_STATUS= DECODE( pSO_RTYPE,MSC_UTIL.SYS_YES
4177: ,decode(lv_refresh_type,MSC_UTIL.G_INCREMENTAL,MSC_UTIL.SYS_YES,
4178: decode(lv_inv_ctp_val,5,decode(lv_refresh_type,

Line 4232: UPDATE MSC_APPS_INSTANCES

4228:
4229: ---===================== EMPTY ====================
4230: ELSIF pST_STATUS= MSC_UTIL.G_ST_EMPTY THEN
4231:
4232: UPDATE MSC_APPS_INSTANCES
4233: SET ST_STATUS= MSC_UTIL.G_ST_EMPTY,
4234: LAST_UPDATE_DATE= SYSDATE,
4235: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4236: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

Line 4245: UPDATE MSC_APPS_INSTANCES

4241:
4242: ---===================== READY ====================
4243: ELSIF pST_STATUS= MSC_UTIL.G_ST_READY THEN
4244:
4245: UPDATE MSC_APPS_INSTANCES
4246: SET ST_STATUS= MSC_UTIL.G_ST_READY,
4247: LAST_UPDATE_DATE= SYSDATE,
4248: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4249: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

Line 4288: UPDATE MSC_APPS_INSTANCES

4284: BEGIN
4285:
4286: --- PREPLACE CHANGE START ---
4287: /*
4288: UPDATE MSC_APPS_INSTANCES
4289: SET APPS_LRN= pLRN,
4290: LRTYPE= DECODE( pRTYPE, MSC_UTIL.SYS_YES, 'C', 'I'),
4291: SO_LRTYPE= DECODE( pSO_RTYPE, MSC_UTIL.SYS_YES, 'C', 'I'),
4292: LRID= msc_cl_refresh_s.currval,

Line 4301: UPDATE MSC_APPS_INSTANCES

4297: LR_SOURCING_FLAG = pSOURCING_ENABLED
4298: WHERE INSTANCE_ID= pINSTANCE_ID;
4299: */
4300:
4301: UPDATE MSC_APPS_INSTANCES
4302: SET APPS_LRN= pLRN,
4303: LRTYPE= DECODE( pRTYPE, MSC_UTIL.G_COMPLETE, 'C',
4304: MSC_UTIL.G_INCREMENTAL, 'I',
4305: MSC_UTIL.G_PARTIAL, 'P',

Line 4957: FROM MSC_APPS_INSTANCES

4953: lv_task_start_time,
4954: v_current_user,
4955: v_current_date,
4956: v_instance_type
4957: FROM MSC_APPS_INSTANCES
4958: WHERE INSTANCE_ID= pIID;
4959:
4960:
4961: /* added code so that for 107/110 source this profile option = 0 */

Line 5007: FROM msc_apps_instances

5003:
5004:
5005: SELECT DECODE(LRTYPE, 'P', MSC_UTIL.SYS_YES, MSC_UTIL.SYS_NO)
5006: INTO v_is_partial_refresh
5007: FROM msc_apps_instances
5008: WHERE instance_id = pIID;
5009:
5010:
5011: -- IF v_is_partial_refresh = MSC_UTIL.SYS_YES THEN

Line 5027: FROM msc_apps_instances

5023:
5024: SELECT DECODE(LRTYPE,'C',MSC_UTIL.G_COMPLETE,'P',MSC_UTIL.G_PARTIAL,'I',MSC_UTIL.G_INCREMENTAL,'T',MSC_UTIL.G_CONT)
5025: INTO
5026: lv_refresh_type
5027: FROM msc_apps_instances
5028: WHERE instance_id = pIID;
5029:
5030: if (get_entity_lrn (pIID, pTASKNUM, prec, pLRN, lv_refresh_type,prec.org_group_flag ,lv_entity_lrn)) then
5031: v_lrnn := lv_entity_lrn;

Line 5037: FROM msc_apps_instances

5033: end if;
5034:
5035: SELECT DECODE(LRTYPE, 'T', MSC_UTIL.SYS_YES, MSC_UTIL.SYS_NO)
5036: INTO v_is_cont_refresh
5037: FROM msc_apps_instances
5038: WHERE instance_id = pIID;
5039:
5040:
5041: if (v_is_cont_refresh = MSC_UTIL.SYS_YES) then