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 2041: lv_tbl:= 'MSC_BOM_COMPONENTS';

2037:
2038: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2039: lv_tbl:= 'BOM_COMPONENTS_'||MSC_CL_COLLECTION.v_instance_code;
2040: ELSE
2041: lv_tbl:= 'MSC_BOM_COMPONENTS';
2042: END IF;
2043:
2044: lv_sql_stmt:=
2045: ' insert into '||lv_tbl

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

2126: --fix for the bug#3283959
2127: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2128:
2129: if (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO) then
2130: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
2131: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2132: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
2133: ELSE
2134: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

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

2128:
2129: if (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO) then
2130: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
2131: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2132: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
2133: ELSE
2134: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2135: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2136: END IF;

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

2131: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2132: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
2133: ELSE
2134: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2135: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2136: END IF;
2137: end if;
2138:
2139: BEGIN

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

2242:
2243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2244: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2245: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2246: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2247: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2248:
2249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2250: RAISE;

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

2252: ELSE
2253: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2254: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2255: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2256: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2257: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2258:
2259: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2260:

Line 2280: lv_sql_stmt1 := ' UPDATE MSC_BOM_COMPONENTS '

2276: -- set SR_INSTANCE_ID to negative to indicate a SOFT delete
2277:
2278: FOR c_rec IN c1_d LOOP
2279: ---5470477
2280: lv_sql_stmt1 := ' UPDATE MSC_BOM_COMPONENTS '
2281: ||' SET USAGE_QUANTITY= 0, '
2282: ||' REFRESH_NUMBER= :v_last_collection_id , '
2283: ||' LAST_UPDATE_DATE= :v_current_date , '
2284: ||' LAST_UPDATED_BY= :v_current_user '

Line 2321: UPDATE MSC_BOM_COMPONENTS

2317: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------------------------');
2318: END;
2319:
2320: /*
2321: UPDATE MSC_BOM_COMPONENTS
2322: SET USAGE_QUANTITY= 0,
2323: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
2324: LAST_UPDATE_DATE= v_current_date,
2325: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 2405: UPDATE MSC_BOM_COMPONENTS

2401: BEGIN
2402:
2403: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
2404:
2405: UPDATE MSC_BOM_COMPONENTS
2406: SET
2407: ORGANIZATION_ID= lb_ORGANIZATION_ID(j),
2408: INVENTORY_ITEM_ID= lb_INVENTORY_ITEM_ID(j),
2409: USING_ASSEMBLY_ID= lb_USING_ASSEMBLY_ID(j),

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

2496:
2497: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2498: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2499: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2500: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2502:
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2504: RAISE;

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

2509:
2510: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2511: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2512: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOM_COMPONENTS');
2513: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOM_COMPONENTS');
2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2515:
2516: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2517: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');

Line 2547: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_BOM_COMPONENTS'

2543: lv_tbl:= 'BOM_COMPONENTS_'||MSC_CL_COLLECTION.v_instance_code;
2544:
2545: lv_sql_stmt:=
2546: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
2547: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_BOM_COMPONENTS'
2548: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2549: ||' AND plan_id = -1 '
2550: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2551:

Line 2562: 'MSC_BOM_COMPONENTS',

2558:
2559: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2560: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2561: lv_retcode,
2562: 'MSC_BOM_COMPONENTS',
2563: MSC_CL_COLLECTION.v_instance_code,
2564: MSC_UTIL.G_WARNING
2565: );
2566: