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_BOM_ODS_LOAD dependencies on MSC_BOM_COMPONENTS

Line 2022: lv_tbl:= 'MSC_BOM_COMPONENTS';

2018:
2019: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2020: lv_tbl:= 'BOM_COMPONENTS_'||MSC_CL_COLLECTION.v_instance_code;
2021: ELSE
2022: lv_tbl:= 'MSC_BOM_COMPONENTS';
2023: END IF;
2024:
2025: lv_sql_stmt:=
2026: ' insert into '||lv_tbl

Line 2111: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);

2107: --fix for the bug#3283959
2108: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2109:
2110: if (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO) then
2111: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
2112: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2113: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
2114: ELSE
2115: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 2113: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);

2109:
2110: if (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO) then
2111: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
2112: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2113: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
2114: ELSE
2115: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2116: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2117: END IF;

Line 2116: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

2112: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2113: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
2114: ELSE
2115: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2116: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2117: END IF;
2118: end if;
2119:
2120: BEGIN

Line 2227: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');

2223:
2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2225: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2226: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2227: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2228: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2229:
2230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2231: RAISE;

Line 2237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');

2233: ELSE
2234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2235: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2236: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2239:
2240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2241:

Line 2261: lv_sql_stmt1 := ' UPDATE MSC_BOM_COMPONENTS '

2257: -- set SR_INSTANCE_ID to negative to indicate a SOFT delete
2258:
2259: FOR c_rec IN c1_d LOOP
2260: ---5470477
2261: lv_sql_stmt1 := ' UPDATE MSC_BOM_COMPONENTS '
2262: ||' SET USAGE_QUANTITY= 0, '
2263: ||' REFRESH_NUMBER= :v_last_collection_id , '
2264: ||' LAST_UPDATE_DATE= :v_current_date , '
2265: ||' LAST_UPDATED_BY= :v_current_user '

Line 2302: UPDATE MSC_BOM_COMPONENTS

2298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------------------------');
2299: END;
2300:
2301: /*
2302: UPDATE MSC_BOM_COMPONENTS
2303: SET USAGE_QUANTITY= 0,
2304: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
2305: LAST_UPDATE_DATE= v_current_date,
2306: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 2386: UPDATE MSC_BOM_COMPONENTS

2382: BEGIN
2383:
2384: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
2385:
2386: UPDATE MSC_BOM_COMPONENTS
2387: SET
2388: ORGANIZATION_ID= lb_ORGANIZATION_ID(j),
2389: INVENTORY_ITEM_ID= lb_INVENTORY_ITEM_ID(j),
2390: USING_ASSEMBLY_ID= lb_USING_ASSEMBLY_ID(j),

Line 2481: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');

2477:
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2479: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2480: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2481: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2482: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2483:
2484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2485: RAISE;

Line 2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');

2490:
2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2492: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2493: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');

Line 2528: ||' SELECT * from MSC_BOM_COMPONENTS'

2524: lv_tbl:= 'BOM_COMPONENTS_'||MSC_CL_COLLECTION.v_instance_code;
2525:
2526: lv_sql_stmt:=
2527: 'INSERT INTO '||lv_tbl
2528: ||' SELECT * from MSC_BOM_COMPONENTS'
2529: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2530: ||' AND plan_id = -1 '
2531: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2532:

Line 2543: 'MSC_BOM_COMPONENTS',

2539:
2540: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2541: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2542: lv_retcode,
2543: 'MSC_BOM_COMPONENTS',
2544: MSC_CL_COLLECTION.v_instance_code,
2545: MSC_UTIL.G_WARNING
2546: );
2547: