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 2239: lv_table_name:= 'MSC_SYSTEM_ITEMS';

2235: 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
2236: lv_table_name:= 'SYSTEM_ITEMS_' || MSC_CL_COLLECTION.v_INSTANCE_CODE;
2237: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in LOAD_SUPPLIER_CAPACITY is ' || lv_table_name);
2238: else
2239: lv_table_name:= 'MSC_SYSTEM_ITEMS';
2240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in LOAD_SUPPLIER_CAPACITY is ' || lv_table_name);
2241: End if;
2242:
2243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name is ' || lv_table_name);

Line 3531: lv_tbl:= 'MSC_SYSTEM_ITEMS';

3527:
3528: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
3529: lv_tbl:= 'SYSTEM_ITEMS_'||MSC_CL_COLLECTION.v_INSTANCE_CODE;
3530: ELSE
3531: lv_tbl:= 'MSC_SYSTEM_ITEMS';
3532: END IF;
3533:
3534:
3535: lv_sql_stmt:=

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

3815: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) AND
3816: MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
3817:
3818: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3819: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SYSTEM_ITEMS', MSC_CL_COLLECTION.v_instance_id, -1);
3820: ELSE
3821: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3822: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SYSTEM_ITEMS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
3823: END IF;

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

3818: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3819: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SYSTEM_ITEMS', MSC_CL_COLLECTION.v_instance_id, -1);
3820: ELSE
3821: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3822: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SYSTEM_ITEMS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
3823: END IF;
3824: END IF;
3825:
3826: -- delete is not supported

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

4131:
4132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4133: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4134: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4135: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4137:
4138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4139: RAISE;

Line 4318: UPDATE MSC_SYSTEM_ITEMS

4314: BEGIN
4315:
4316: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
4317:
4318: UPDATE MSC_SYSTEM_ITEMS
4319: SET
4320: ITEM_NAME= lb_ITEM_NAME(j),
4321: LOTS_EXPIRATION= lb_LOTS_EXPIRATION(j),
4322: LOT_CONTROL_CODE= lb_LOT_CONTROL_CODE(j),

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

4620:
4621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4622: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4623: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4624: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4626:
4627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4628: RAISE;

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

4633:
4634: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4635: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4636: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4637: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4639:
4640: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4641: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

Line 4677: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_SYSTEM_ITEMS'

4673: lv_tbl:= 'SYSTEM_ITEMS_'||MSC_CL_COLLECTION.v_INSTANCE_CODE;
4674:
4675: lv_sql_stmt:=
4676: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
4677: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_SYSTEM_ITEMS'
4678: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
4679: ||' AND plan_id = -1 '
4680: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
4681:

Line 4692: 'MSC_SYSTEM_ITEMS',

4688:
4689: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
4690: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
4691: lv_retcode,
4692: 'MSC_SYSTEM_ITEMS',
4693: MSC_CL_COLLECTION.v_INSTANCE_CODE,
4694: MSC_UTIL.G_ERROR
4695: );
4696: