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 2250: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1, 'AND nvl(COLLECTED_FLAG,1) <> 2');

2246:
2247: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2248:
2249:
2250: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1, 'AND nvl(COLLECTED_FLAG,1) <> 2');
2251:
2252: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2253: v_sub_str := 'AND nvl(COLLECTED_FLAG,1) <> 2';
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, 'AND nvl(COLLECTED_FLAG,1) <> 2');
2251:
2252: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2253: v_sub_str := 'AND nvl(COLLECTED_FLAG,1) <> 2';
2254: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2255: ELSE
2256: v_sub_str := ' AND nvl(COLLECTED_FLAG,1) <> 2'
2257: ||' AND ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2258: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

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

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

Line 2276: UPDATE MSC_ITEM_SUPPLIERS

2272: BEGIN
2273:
2274: IF MSC_CL_COLLECTION.v_is_legacy_refresh THEN
2275:
2276: UPDATE MSC_ITEM_SUPPLIERS
2277: SET
2278: PROCESSING_LEAD_TIME= c_rec.PROCESSING_LEAD_TIME,
2279: MINIMUM_ORDER_QUANTITY= c_rec.MINIMUM_ORDER_QUANTITY,
2280: FIXED_LOT_MULTIPLIER= c_rec.FIXED_LOT_MULTIPLE,

Line 2322: INSERT INTO MSC_ITEM_SUPPLIERS

2318: END IF;
2319:
2320: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
2321:
2322: INSERT INTO MSC_ITEM_SUPPLIERS
2323: ( PLAN_ID,
2324: ORGANIZATION_ID,
2325: USING_ORGANIZATION_ID,
2326: SUPPLIER_ID,

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

2421:
2422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2423: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2424: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2425: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2426: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2427:
2428: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2429: RAISE;

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

2433:
2434: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2435: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2436: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2437: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2438: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2439:
2440: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2441: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

Line 2493: lv_sql_stmt:= 'Delete MSC_ITEM_SUPPLIERS mis'

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

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

2511:
2512: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2513: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2514: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2515: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2516: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2517:
2518: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2519: RAISE;

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

2523:
2524: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2525: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2526: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2527: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2529:
2530: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2531: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

Line 2556: UPDATE MSC_ITEM_SUPPLIERS

2552:
2553: /*Insert Logic */
2554: FOR c_rec in c4 LOOP
2555: BEGIN
2556: UPDATE MSC_ITEM_SUPPLIERS
2557: SET
2558: PROCESSING_LEAD_TIME= c_rec.PROCESSING_LEAD_TIME,
2559: MINIMUM_ORDER_QUANTITY= c_rec.MINIMUM_ORDER_QUANTITY,
2560: FIXED_LOT_MULTIPLIER= c_rec.FIXED_LOT_MULTIPLE,

Line 2601: lv_sql_stmt:= 'INSERT INTO MSC_ITEM_SUPPLIERS'

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

Line 2722: INSERT INTO MSC_ITEM_SUPPLIERS

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

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

2817:
2818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2819: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2820: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2821: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2822: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2823:
2824: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2825: RAISE;

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

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