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.MRP_CL_FUNCTION dependencies on MSC_IB_CONTRACTS_TEMP

Line 2264: lv_sql_stmt := 'Truncate table ' || MSC_UTIL.G_MSC_SCHEMA || '.MSC_IB_CONTRACTS_TEMP';

2260: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'End date of the Time Window '||orig_end_date);
2261:
2262: /* determine the list of contracts for each of the above item instance----- */
2263:
2264: lv_sql_stmt := 'Truncate table ' || MSC_UTIL.G_MSC_SCHEMA || '.MSC_IB_CONTRACTS_TEMP';
2265: EXECUTE IMMEDIATE lv_sql_stmt;
2266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Truncated table MSC_IB_CONTRACTS_TEMP');
2267:
2268: for t in c10(orig_st_date)

Line 2266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Truncated table MSC_IB_CONTRACTS_TEMP');

2262: /* determine the list of contracts for each of the above item instance----- */
2263:
2264: lv_sql_stmt := 'Truncate table ' || MSC_UTIL.G_MSC_SCHEMA || '.MSC_IB_CONTRACTS_TEMP';
2265: EXECUTE IMMEDIATE lv_sql_stmt;
2266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Truncated table MSC_IB_CONTRACTS_TEMP');
2267:
2268: for t in c10(orig_st_date)
2269: loop
2270: CSI_JAVA_INTERFACE_PKG.getContracts(t.item_instance_id,x_return_status,x_msg_count,x_msg_data,x_output_contracts);

Line 2300: insert into MSC_IB_CONTRACTS_TEMP(

2296: IF ( (x_output_contracts(i).service_start_date <= orig_end_date)
2297: and ((nvl(x_output_contracts(i).date_terminated,x_output_contracts(i).service_end_date)) >= orig_st_date)
2298: AND x_output_contracts(i).STS_CODE <> 'ENTERED' ) THEN
2299:
2300: insert into MSC_IB_CONTRACTS_TEMP(
2301: item_instance_id,
2302: inventory_item_id ,
2303: install_date,
2304: expiration_date,

Line 2355: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Completed inserting Data into MSC_IB_CONTRACTS_TEMP');

2351:
2352: END LOOP; /*Outer loop - Item instances*/
2353: /* ----------*/
2354:
2355: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Completed inserting Data into MSC_IB_CONTRACTS_TEMP');
2356:
2357: /* ADD the function based index*/
2358:
2359: begin

Line 2360: lv_sql_stmt := 'CREATE INDEX ' || MSC_UTIL.G_MSC_SCHEMA ||'.MSC_IB_CONTRACTS_TEMP_N1 ' ||

2356:
2357: /* ADD the function based index*/
2358:
2359: begin
2360: lv_sql_stmt := 'CREATE INDEX ' || MSC_UTIL.G_MSC_SCHEMA ||'.MSC_IB_CONTRACTS_TEMP_N1 ' ||
2361: 'ON ' || MSC_UTIL.G_MSC_SCHEMA || '.MSC_IB_CONTRACTS_TEMP( INSTALL_DATE,
2362: SERVICE_START_DATE, NVL(COTERM_DATE,SERVICE_END_DATE), EXPIRATION_DATE )
2363: STORAGE(INITIAL 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 )
2364: TABLESPACE APPS_TS_TX_DATA ';

Line 2361: 'ON ' || MSC_UTIL.G_MSC_SCHEMA || '.MSC_IB_CONTRACTS_TEMP( INSTALL_DATE,

2357: /* ADD the function based index*/
2358:
2359: begin
2360: lv_sql_stmt := 'CREATE INDEX ' || MSC_UTIL.G_MSC_SCHEMA ||'.MSC_IB_CONTRACTS_TEMP_N1 ' ||
2361: 'ON ' || MSC_UTIL.G_MSC_SCHEMA || '.MSC_IB_CONTRACTS_TEMP( INSTALL_DATE,
2362: SERVICE_START_DATE, NVL(COTERM_DATE,SERVICE_END_DATE), EXPIRATION_DATE )
2363: STORAGE(INITIAL 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 )
2364: TABLESPACE APPS_TS_TX_DATA ';
2365:

Line 2367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Index MSC_IB_CONTRACTS_TEMP_N1 on table MSC_IB_CONTRACTS_TEMP created ');

2363: STORAGE(INITIAL 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 )
2364: TABLESPACE APPS_TS_TX_DATA ';
2365:
2366: EXECUTE IMMEDIATE lv_sql_stmt;
2367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Index MSC_IB_CONTRACTS_TEMP_N1 on table MSC_IB_CONTRACTS_TEMP created ');
2368: EXCEPTION
2369: WHEN OTHERS THEN
2370: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2413: from msc_ib_contracts_temp mict

2409: -1,
2410: systimestamp,
2411: -1
2412: from ( select distinct item_instance_id, inventory_item_id, quantity qty,zone,region_id
2413: from msc_ib_contracts_temp mict
2414: where mict.install_date <= v_curr_date
2415: and nvl(mict.coterm_date,mict.service_end_date) >= v_curr_date
2416: and mict.service_start_date <=v_curr_date
2417: and nvl(mict.expiration_date,(SYSTIMESTAMP + 365000)) >= v_curr_date

Line 2434: lv_sql_stmt := 'DROP INDEX ' || MSC_UTIL.G_MSC_SCHEMA || '.MSC_IB_CONTRACTS_TEMP_N1';

2430:
2431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Completed inserting data into MSC_SR_ZN_AGGR_IBUC');
2432:
2433: BEGIN
2434: lv_sql_stmt := 'DROP INDEX ' || MSC_UTIL.G_MSC_SCHEMA || '.MSC_IB_CONTRACTS_TEMP_N1';
2435: EXECUTE IMMEDIATE lv_sql_stmt;
2436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Index MSC_IB_CONTRACTS_TEMP_N1 on table MSC_IB_CONTRACTS_TEMP Dropped ');
2437: EXCEPTION
2438: WHEN OTHERS THEN

Line 2436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Index MSC_IB_CONTRACTS_TEMP_N1 on table MSC_IB_CONTRACTS_TEMP Dropped ');

2432:
2433: BEGIN
2434: lv_sql_stmt := 'DROP INDEX ' || MSC_UTIL.G_MSC_SCHEMA || '.MSC_IB_CONTRACTS_TEMP_N1';
2435: EXECUTE IMMEDIATE lv_sql_stmt;
2436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Index MSC_IB_CONTRACTS_TEMP_N1 on table MSC_IB_CONTRACTS_TEMP Dropped ');
2437: EXCEPTION
2438: WHEN OTHERS THEN
2439: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2440: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2452: || MSC_UTIL.G_MSC_SCHEMA ||'.MSC_IB_CONTRACTS_TEMP'

2448: BEGIN
2449: prev_lb_inv_item_id := -1;
2450: lv_sql_stmt3 :=
2451: 'select inventory_item_id,item_instance_id,location_id from '
2452: || MSC_UTIL.G_MSC_SCHEMA ||'.MSC_IB_CONTRACTS_TEMP'
2453: || ' where zone is null group by inventory_item_id,item_instance_id,location_id order by inventory_item_id ' ;
2454:
2455: EXECUTE IMMEDIATE lv_sql_stmt3 BULK COLLECT into lb_inv_item_id,lb_item_instance_id,lb_location_id ;
2456: