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

907: '@'||M2A_DBLINK),
908: LAST_TGT_CONT_COLL_TIME
909: INTO v_dblink,
910: lv_last_tgt_cont_coll_time
911: FROM MSC_APPS_INSTANCES
912: WHERE INSTANCE_ID= p_instance_id;
913:
914: EXCEPTION
915: WHEN NO_DATA_FOUND THEN

Line 1036: FROM MSC_APPS_INSTANCES

1032: --then append all the OPM orgs
1033: BEGIN
1034: SELECT DECODE(M2A_DBLINK,NULL,NULL_DBLINK,'@'||M2A_DBLINK)
1035: INTO lv_dblink
1036: FROM MSC_APPS_INSTANCES
1037: WHERE INSTANCE_ID= p_instance_id;
1038:
1039: EXCEPTION
1040: WHEN NO_DATA_FOUND THEN

Line 1286: FROM MSC_APPS_INSTANCES

1282: v_distributed_config_flag,
1283: lv_apps_ver,
1284: v_lrnn,
1285: v_so_lrn
1286: FROM MSC_APPS_INSTANCES
1287: WHERE INSTANCE_ID= pINSTANCE_ID;
1288:
1289: EXCEPTION
1290:

Line 2181: FROM MSC_APPS_INSTANCES

2177: v_instance_type,
2178: v_apps_ver,
2179: lv_last_tgt_cont_coll_time,
2180: v_instance_code
2181: FROM MSC_APPS_INSTANCES
2182: WHERE INSTANCE_ID= pINSTANCE_ID;
2183:
2184: IF (v_apps_ver = MSC_UTIL.G_APPS120) THEN --bug#5684183 (bcaru)
2185: prec.payback_demand_supply_flag := MSC_UTIL.SYS_NO;

Line 2271: 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' || ' ) '

2267: END IF;
2268:
2269: If pRTYPE = MSC_UTIL.G_COMPLETE Then
2270: IF v_apps_ver >= MSC_UTIL.G_APPS115 Then
2271: 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' || ' ) '
2272: || ' where instance_id = ' || pINSTANCE_ID ;
2273: ELSE
2274: lv_sql_stmt:= 'update msc_apps_instances set LBJ_DETAILS = 2 '
2275: || ' where instance_id = ' || pINSTANCE_ID ;

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

2270: IF v_apps_ver >= MSC_UTIL.G_APPS115 Then
2271: 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' || ' ) '
2272: || ' where instance_id = ' || pINSTANCE_ID ;
2273: ELSE
2274: lv_sql_stmt:= 'update msc_apps_instances set LBJ_DETAILS = 2 '
2275: || ' where instance_id = ' || pINSTANCE_ID ;
2276: END IF;
2277:
2278: EXECUTE IMMEDIATE lv_sql_stmt;

Line 2346: FROM MSC_APPS_INSTANCES

2342:
2343:
2344: SELECT FND_GLOBAL.USER_ID
2345: INTO v_current_user
2346: FROM MSC_APPS_INSTANCES
2347: WHERE INSTANCE_ID= pINSTANCE_ID;
2348:
2349: -- To be called only at the first run.
2350: IF (v_req_data is null) THEN -- for the fix 2351297

Line 2363: UPDATE msc_apps_instances

2359: WHEN OTHERS THEN
2360: lv_pjm_enabled := NULL;
2361: END;
2362:
2363: UPDATE msc_apps_instances
2364: SET lrtype = DECODE ( pRTYPE, MSC_UTIL.G_COMPLETE, 'C',
2365: MSC_UTIL.G_INCREMENTAL, 'I',
2366: MSC_UTIL.G_PARTIAL, 'P',
2367: MSC_UTIL.G_CONT, 'T'),

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

2367: MSC_UTIL.G_CONT, 'T'),
2368: pjm_enabled = lv_pjm_enabled
2369: WHERE instance_id = pINSTANCE_ID;
2370:
2371: -- Indicate the data pull type in MSC_APPS_INSTANCES
2372:
2373: SELECT count(*)
2374: INTO lv_param_rec_count
2375: FROM msc_coll_parameters

Line 2423: FROM msc_apps_instances

2419: ELSE
2420:
2421: SELECT st_status
2422: INTO lv_coll_stat
2423: FROM msc_apps_instances
2424: WHERE instance_id = pINSTANCE_ID;
2425:
2426: IF lv_coll_stat = MSC_UTIL.G_ST_EMPTY THEN
2427:

Line 2506: FROM MSC_APPS_INSTANCES

2502: INSTANCE_TYPE
2503: INTO v_dblink,
2504: lv_dest_a2m, -- bug fix for 2320600
2505: v_instance_type
2506: FROM MSC_APPS_INSTANCES
2507: WHERE INSTANCE_ID= pINSTANCE_ID;
2508:
2509: -- To Check if the refresh type is partial(ie Targetted)
2510: -- the a2m_dblink on the destination should be in sync with

Line 2615: UPDATE MSC_APPS_INSTANCES

2611: COMMIT;
2612: END IF;
2613:
2614: IF lv_check_point =2 THEN
2615: UPDATE MSC_APPS_INSTANCES
2616: SET SO_TBL_STATUS = decode(pSalesOrder_RTYPE,MSC_UTIL.SYS_YES
2617: ,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),
2618: SO_TBL_STATUS)
2619: WHERE INSTANCE_ID= pINSTANCE_ID;

Line 2653: UPDATE MSC_APPS_INSTANCES

2649: ||' AND nvl(mar.A2M_DBLINK, '''||NULL_DBLINK||''' ) = '''||v_dest_a2m||'''';
2650:
2651: EXECUTE IMMEDIATE v_sql_stmt INTO v_crn, v_validation_org_id;
2652:
2653: UPDATE MSC_APPS_INSTANCES
2654: SET VALIDATION_ORG_ID = v_validation_org_id
2655: WHERE INSTANCE_ID = pINSTANCE_ID;
2656:
2657: ELSE

Line 2832: UPDATE msc_apps_instances

2828: nosnap_flag = prec.nosnap_flag,
2829: trip_sn_flag = prec.trip_sn_flag
2830: WHERE INSTANCE_ID=pINSTANCE_ID;
2831:
2832: UPDATE msc_apps_instances
2833: SET SO_TBL_STATUS = decode (prec.so_sn_flag,MSC_UTIL.SYS_TGT,MSC_UTIL.SYS_NO,SO_TBL_STATUS)
2834: WHERE INSTANCE_ID=pINSTANCE_ID;
2835:
2836: COMMIT;

Line 2983: UPDATE MSC_APPS_INSTANCES

2979: COMMIT;
2980: END IF;
2981:
2982: IF lv_check_point =2 THEN
2983: UPDATE MSC_APPS_INSTANCES
2984: SET SO_TBL_STATUS = decode(pSalesOrder_RTYPE,MSC_UTIL.SYS_YES
2985: ,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),
2986: SO_TBL_STATUS)
2987: WHERE INSTANCE_ID= pINSTANCE_ID;

Line 3330: UPDATE MSC_APPS_INSTANCES

3326: pINSTANCE_ID, MSC_UTIL.G_ST_EMPTY) THEN
3327: COMMIT;
3328: END IF;
3329:
3330: UPDATE MSC_APPS_INSTANCES
3331: SET SO_TBL_STATUS = decode(pSalesOrder_RTYPE,MSC_UTIL.SYS_YES
3332: ,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),
3333: SO_TBL_STATUS)
3334: WHERE INSTANCE_ID= pINSTANCE_ID;

Line 3420: UPDATE MSC_APPS_INSTANCES

3416: pINSTANCE_ID, MSC_UTIL.G_ST_EMPTY) THEN
3417: COMMIT;
3418: END IF;
3419:
3420: UPDATE MSC_APPS_INSTANCES
3421: SET SO_TBL_STATUS = decode(pSalesOrder_RTYPE,MSC_UTIL.SYS_YES
3422: ,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),
3423: SO_TBL_STATUS)
3424: WHERE INSTANCE_ID= pINSTANCE_ID;

Line 3449: UPDATE MSC_APPS_INSTANCES

3445: pINSTANCE_ID, MSC_UTIL.G_ST_EMPTY) THEN
3446: COMMIT;
3447: END IF;
3448:
3449: UPDATE MSC_APPS_INSTANCES
3450: SET SO_TBL_STATUS = decode(pSalesOrder_RTYPE,MSC_UTIL.SYS_YES
3451: ,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),
3452: SO_TBL_STATUS)
3453: WHERE INSTANCE_ID= pINSTANCE_ID;

Line 3951: from msc_apps_instances

3947: /* We will pass apps_lrn for the entity lrn, if it is NULL */
3948:
3949: select apps_lrn
3950: into lv_apps_lrn
3951: from msc_apps_instances
3952: where instance_id = p_instance_id;
3953:
3954: select min(nvl(supplier_capacity_lrn,lv_apps_lrn)),
3955: min(nvl(bom_lrn,lv_apps_lrn)),

Line 4309: FROM MSC_APPS_INSTANCES mai

4305: SELECT mai.ENABLE_FLAG,
4306: mai.ST_STATUS,
4307: DECODE(mai.LRTYPE,'C',MSC_UTIL.G_COMPLETE,'P',MSC_UTIL.G_PARTIAL,'I',MSC_UTIL.G_INCREMENTAL,'T',MSC_UTIL.G_CONT)
4308: INTO lv_instance_enabled, lv_staging_table_status,lv_refresh_type
4309: FROM MSC_APPS_INSTANCES mai
4310: WHERE mai.INSTANCE_ID= pINSTANCE_ID
4311: FOR UPDATE;
4312:
4313: IF lv_instance_enabled= MSC_UTIL.SYS_YES THEN

Line 4331: UPDATE MSC_APPS_INSTANCES

4327: END;
4328: END IF;
4329: /* for bug:2605884 ,added the decode in updating so_tbl_status=2 if ODS ATP and complete
4330: refresh of the sales orders */
4331: UPDATE MSC_APPS_INSTANCES
4332: SET ST_STATUS= MSC_UTIL.G_ST_PULLING,
4333: SO_TBL_STATUS= DECODE( pSO_RTYPE,MSC_UTIL.SYS_YES
4334: ,decode(lv_refresh_type,MSC_UTIL.G_INCREMENTAL,MSC_UTIL.SYS_YES,
4335: decode(lv_inv_ctp_val,5,decode(lv_refresh_type,

Line 4389: UPDATE MSC_APPS_INSTANCES

4385:
4386: ---===================== EMPTY ====================
4387: ELSIF pST_STATUS= MSC_UTIL.G_ST_EMPTY THEN
4388:
4389: UPDATE MSC_APPS_INSTANCES
4390: SET ST_STATUS= MSC_UTIL.G_ST_EMPTY,
4391: LAST_UPDATE_DATE= SYSDATE,
4392: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4393: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

Line 4402: UPDATE MSC_APPS_INSTANCES

4398:
4399: ---===================== READY ====================
4400: ELSIF pST_STATUS= MSC_UTIL.G_ST_READY THEN
4401:
4402: UPDATE MSC_APPS_INSTANCES
4403: SET ST_STATUS= MSC_UTIL.G_ST_READY,
4404: LAST_UPDATE_DATE= SYSDATE,
4405: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4406: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

Line 4445: UPDATE MSC_APPS_INSTANCES

4441: BEGIN
4442:
4443: --- PREPLACE CHANGE START ---
4444: /*
4445: UPDATE MSC_APPS_INSTANCES
4446: SET APPS_LRN= pLRN,
4447: LRTYPE= DECODE( pRTYPE, MSC_UTIL.SYS_YES, 'C', 'I'),
4448: SO_LRTYPE= DECODE( pSO_RTYPE, MSC_UTIL.SYS_YES, 'C', 'I'),
4449: LRID= msc_cl_refresh_s.currval,

Line 4458: UPDATE MSC_APPS_INSTANCES

4454: LR_SOURCING_FLAG = pSOURCING_ENABLED
4455: WHERE INSTANCE_ID= pINSTANCE_ID;
4456: */
4457:
4458: UPDATE MSC_APPS_INSTANCES
4459: SET APPS_LRN= pLRN,
4460: LRTYPE= DECODE( pRTYPE, MSC_UTIL.G_COMPLETE, 'C',
4461: MSC_UTIL.G_INCREMENTAL, 'I',
4462: MSC_UTIL.G_PARTIAL, 'P',

Line 5168: FROM MSC_APPS_INSTANCES

5164: lv_task_start_time,
5165: v_current_user,
5166: v_current_date,
5167: v_instance_type
5168: FROM MSC_APPS_INSTANCES
5169: WHERE INSTANCE_ID= pIID;
5170:
5171:
5172: /* added code so that for 107/110 source this profile option = 0 */

Line 5218: FROM msc_apps_instances

5214:
5215:
5216: SELECT DECODE(LRTYPE, 'P', MSC_UTIL.SYS_YES, MSC_UTIL.SYS_NO)
5217: INTO v_is_partial_refresh
5218: FROM msc_apps_instances
5219: WHERE instance_id = pIID;
5220:
5221:
5222: -- IF v_is_partial_refresh = MSC_UTIL.SYS_YES THEN

Line 5238: FROM msc_apps_instances

5234:
5235: SELECT DECODE(LRTYPE,'C',MSC_UTIL.G_COMPLETE,'P',MSC_UTIL.G_PARTIAL,'I',MSC_UTIL.G_INCREMENTAL,'T',MSC_UTIL.G_CONT)
5236: INTO
5237: lv_refresh_type
5238: FROM msc_apps_instances
5239: WHERE instance_id = pIID;
5240:
5241: if (get_entity_lrn (pIID, pTASKNUM, prec, pLRN, lv_refresh_type,prec.org_group_flag ,lv_entity_lrn)) then
5242: v_lrnn := lv_entity_lrn;

Line 5248: FROM msc_apps_instances

5244: end if;
5245:
5246: SELECT DECODE(LRTYPE, 'T', MSC_UTIL.SYS_YES, MSC_UTIL.SYS_NO)
5247: INTO v_is_cont_refresh
5248: FROM msc_apps_instances
5249: WHERE instance_id = pIID;
5250:
5251:
5252: if (v_is_cont_refresh = MSC_UTIL.SYS_YES) then