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_ITEM_SUPPLIERS

Line 91: lv_sql_stmt1:= ' INSERT INTO MSC_ITEM_SUPPLIERS '

87: IF (c1%ISOPEN ) THEN
88: LOOP
89: FETCH c1 INTO lv_inventory_item_id,lv_organization_id;
90: EXIT WHEN c1%NOTFOUND ;
91: lv_sql_stmt1:= ' INSERT INTO MSC_ITEM_SUPPLIERS '
92: || ' ( USING_ORGANIZATION_ID,'
93: || ' SUPPLIER_ID,'
94: || ' SUPPLIER_SITE_ID,'
95: || ' INVENTORY_ITEM_ID,'

Line 184: || ' FROM MSC_ITEM_SUPPLIERS '

180: || ' MIN_MINMAX_DAYS,'
181: || ' MAX_MINMAX_DAYS,'
182: || ' FORECAST_HORIZON,'
183: || ' FIXED_ORDER_QUANTITY'
184: || ' FROM MSC_ITEM_SUPPLIERS '
185: || ' WHERE SR_INSTANCE_ID =' || MSC_CL_COLLECTION.v_instance_id
186: || ' AND PLAN_ID =-1 '
187: || ' AND USING_ORGANIZATION_ID =-1 '
188: || ' AND INVENTORY_ITEM_ID =' ||lv_inventory_item_id

Line 211: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');

207:
208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
209: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
210: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'ADD_NEW_IMPL_ITEM_ASL');
211: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
212: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
213:
214: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
215: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

Line 2246: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1, 'AND nvl(COLLECTED_FLAG,1) <> 2');

2242:
2243: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2244:
2245:
2246: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1, 'AND nvl(COLLECTED_FLAG,1) <> 2');
2247:
2248: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2249: v_sub_str := 'AND nvl(COLLECTED_FLAG,1) <> 2';
2250: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line 2250: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

2246: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1, 'AND nvl(COLLECTED_FLAG,1) <> 2');
2247:
2248: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2249: v_sub_str := 'AND nvl(COLLECTED_FLAG,1) <> 2';
2250: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2251: ELSE
2252: v_sub_str := ' AND nvl(COLLECTED_FLAG,1) <> 2'
2253: ||' AND ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2254: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line 2254: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

2250: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2251: ELSE
2252: v_sub_str := ' AND nvl(COLLECTED_FLAG,1) <> 2'
2253: ||' AND ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2254: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2255: END IF;
2256:
2257: END IF;
2258:

Line 2272: UPDATE MSC_ITEM_SUPPLIERS

2268: BEGIN
2269:
2270: IF MSC_CL_COLLECTION.v_is_legacy_refresh THEN
2271:
2272: UPDATE MSC_ITEM_SUPPLIERS
2273: SET
2274: PROCESSING_LEAD_TIME= c_rec.PROCESSING_LEAD_TIME,
2275: MINIMUM_ORDER_QUANTITY= c_rec.MINIMUM_ORDER_QUANTITY,
2276: FIXED_LOT_MULTIPLIER= c_rec.FIXED_LOT_MULTIPLE,

Line 2318: INSERT INTO MSC_ITEM_SUPPLIERS

2314: END IF;
2315:
2316: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
2317:
2318: INSERT INTO MSC_ITEM_SUPPLIERS
2319: ( PLAN_ID,
2320: ORGANIZATION_ID,
2321: USING_ORGANIZATION_ID,
2322: SUPPLIER_ID,

Line 2421: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');

2417:
2418: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2419: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2420: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2421: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2423:
2424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2425: RAISE;

Line 2433: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');

2429:
2430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2431: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2432: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2433: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2434: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2435:
2436: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2437: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

Line 2489: lv_sql_stmt:= 'Delete MSC_ITEM_SUPPLIERS mis'

2485: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'last successful ASL Collection refresh time is '||lv_last_asl_collection_date);
2486: c_count:= 0;
2487: FOR del_rec in del_asl LOOP
2488: BEGIN
2489: lv_sql_stmt:= 'Delete MSC_ITEM_SUPPLIERS mis'
2490: ||' WHERE mis.inventory_item_id =' || del_rec.inventory_item_id
2491: ||' AND mis.USING_ORGANIZATION_ID=' || del_rec.USING_ORGANIZATION_ID
2492: ||' AND mis.SUPPLIER_ID = ' || del_rec.SUPPLIER_ID
2493: ||' AND nvl(mis.SUPPLIER_SITE_ID, -1) = nvl( :SUPPLIER_SITE_ID , -1)'

Line 2511: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');

2507:
2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2509: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2510: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2511: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2512: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2513:
2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2515: RAISE;

Line 2523: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');

2519:
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2521: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2522: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2523: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2524: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2525:
2526: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2527: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

Line 2552: UPDATE MSC_ITEM_SUPPLIERS

2548:
2549: /*Insert Logic */
2550: FOR c_rec in c4 LOOP
2551: BEGIN
2552: UPDATE MSC_ITEM_SUPPLIERS
2553: SET
2554: PROCESSING_LEAD_TIME= c_rec.PROCESSING_LEAD_TIME,
2555: MINIMUM_ORDER_QUANTITY= c_rec.MINIMUM_ORDER_QUANTITY,
2556: FIXED_LOT_MULTIPLIER= c_rec.FIXED_LOT_MULTIPLE,

Line 2597: lv_sql_stmt:= 'INSERT INTO MSC_ITEM_SUPPLIERS'

2593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROW UPDATED ' || SQL%ROWCOUNT);
2594:
2595: IF SQL%NOTFOUND THEN
2596: IF c_rec.using_organization_id =-1 THEN
2597: lv_sql_stmt:= 'INSERT INTO MSC_ITEM_SUPPLIERS'
2598: || ' ( PLAN_ID, '
2599: ||' ORGANIZATION_ID, '
2600: ||' USING_ORGANIZATION_ID,'
2601: ||' SUPPLIER_ID, '

Line 2718: INSERT INTO MSC_ITEM_SUPPLIERS

2714:
2715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROW INSERTED WITH USING ORG -1 ' || SQL%ROWCOUNT);
2716:
2717: ELSE
2718: INSERT INTO MSC_ITEM_SUPPLIERS
2719: ( PLAN_ID,
2720: ORGANIZATION_ID,
2721: USING_ORGANIZATION_ID,
2722: SUPPLIER_ID,

Line 2817: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');

2813:
2814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2815: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2816: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2817: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2819:
2820: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2821: RAISE;

Line 2830: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');

2826:
2827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2828: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2829: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2830: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2832:
2833: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2834: END IF;-- exception end