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_ITEM_ODS_LOAD dependencies on MSC_SYSTEM_ITEMS

Line 57: lv_table_name:= 'MSC_SYSTEM_ITEMS';

53: IF (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES ) THEN
54: lv_table_name:= 'SYSTEM_ITEMS_' || MSC_CL_COLLECTION.v_INSTANCE_CODE;
55: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in ADD_NEW_IMPL_ITEM_ASL is ' || lv_table_name);
56: else
57: lv_table_name:= 'MSC_SYSTEM_ITEMS';
58: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in ADD_NEW_IMPL_ITEM_ASL is ' || lv_table_name);
59: End if;
60:
61: v_sql_stmt := 'Select min (nvl(LAST_SUCC_ITEM_REF_TIME,SYSDATE-365000))'

Line 255: update MSC_SYSTEM_ITEMS

251: PROCEDURE UPDATE_LEADTIME
252: IS
253: BEGIN
254:
255: update MSC_SYSTEM_ITEMS
256: set VARIABLE_LEAD_TIME=0,
257: FIXED_LEAD_TIME=0
258: where PLAN_ID=-1
259: and SR_INSTANCE_ID=MSC_CL_COLLECTION.v_instance_id

Line 265: msc_system_items model_item,

261: select current_item.inventory_item_id,current_item.organization_id
262: from
263: msc_routings model_routing,
264: msc_routings option_class_routing,
265: msc_system_items model_item,
266: msc_system_items current_item
267: where
268: current_item.bom_item_type = 2
269: and model_routing.PLAN_ID=-1

Line 266: msc_system_items current_item

262: from
263: msc_routings model_routing,
264: msc_routings option_class_routing,
265: msc_system_items model_item,
266: msc_system_items current_item
267: where
268: current_item.bom_item_type = 2
269: and model_routing.PLAN_ID=-1
270: and option_class_routing.PLAN_ID=-1

Line 2235: lv_table_name:= 'MSC_SYSTEM_ITEMS';

2231: IF (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES ) THEN
2232: lv_table_name:= 'SYSTEM_ITEMS_' || MSC_CL_COLLECTION.v_INSTANCE_CODE;
2233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in LOAD_SUPPLIER_CAPACITY is ' || lv_table_name);
2234: else
2235: lv_table_name:= 'MSC_SYSTEM_ITEMS';
2236: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in LOAD_SUPPLIER_CAPACITY is ' || lv_table_name);
2237: End if;
2238:
2239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name is ' || lv_table_name);

Line 3521: lv_tbl:= 'MSC_SYSTEM_ITEMS';

3517:
3518: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
3519: lv_tbl:= 'SYSTEM_ITEMS_'||MSC_CL_COLLECTION.v_INSTANCE_CODE;
3520: ELSE
3521: lv_tbl:= 'MSC_SYSTEM_ITEMS';
3522: END IF;
3523:
3524:
3525: lv_sql_stmt:=

Line 3804: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SYSTEM_ITEMS', MSC_CL_COLLECTION.v_instance_id, -1);

3800: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) AND
3801: MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
3802:
3803: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3804: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SYSTEM_ITEMS', MSC_CL_COLLECTION.v_instance_id, -1);
3805: ELSE
3806: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3807: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SYSTEM_ITEMS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
3808: END IF;

Line 3807: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SYSTEM_ITEMS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

3803: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3804: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SYSTEM_ITEMS', MSC_CL_COLLECTION.v_instance_id, -1);
3805: ELSE
3806: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3807: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SYSTEM_ITEMS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
3808: END IF;
3809: END IF;
3810:
3811: -- delete is not supported

Line 4114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');

4110:
4111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4112: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4116:
4117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4118: RAISE;

Line 4294: UPDATE MSC_SYSTEM_ITEMS

4290: BEGIN
4291:
4292: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
4293:
4294: UPDATE MSC_SYSTEM_ITEMS
4295: SET
4296: ITEM_NAME= lb_ITEM_NAME(j),
4297: LOTS_EXPIRATION= lb_LOTS_EXPIRATION(j),
4298: LOT_CONTROL_CODE= lb_LOT_CONTROL_CODE(j),

Line 4594: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');

4590:
4591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4592: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4593: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4594: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4596:
4597: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4598: RAISE;

Line 4607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');

4603:
4604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4605: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4606: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4609:
4610: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4611: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

Line 4647: ||' SELECT * from MSC_SYSTEM_ITEMS'

4643: lv_tbl:= 'SYSTEM_ITEMS_'||MSC_CL_COLLECTION.v_INSTANCE_CODE;
4644:
4645: lv_sql_stmt:=
4646: 'INSERT INTO '||lv_tbl
4647: ||' SELECT * from MSC_SYSTEM_ITEMS'
4648: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
4649: ||' AND plan_id = -1 '
4650: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
4651:

Line 4662: 'MSC_SYSTEM_ITEMS',

4658:
4659: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
4660: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
4661: lv_retcode,
4662: 'MSC_SYSTEM_ITEMS',
4663: MSC_CL_COLLECTION.v_INSTANCE_CODE,
4664: MSC_UTIL.G_ERROR
4665: );
4666: