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_DEMAND_ODS_LOAD dependencies on FND_PROFILE

Line 1424: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);

1420: lv_sql_stmt VARCHAR2(5000);
1421: lv_supply_tbl VARCHAR2(30);
1422: lv_supply_stmt VARCHAR2(5000);
1423: lb_FetchComplete Boolean;
1424: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
1425:
1426:
1427: TYPE CharTblTyp IS TABLE OF VARCHAR2(70);
1428: TYPE NumTblTyp IS TABLE OF NUMBER;

Line 2089: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);

2085: PROCEDURE LOAD_SALES_ORDER IS
2086:
2087: lv_tbl VARCHAR2(30);
2088: lv_supply_tbl VARCHAR2(30);
2089: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
2090: lv_exchange_mode NUMBER:= MSC_UTIL.SYS_NO;
2091: lv_sql_stmt VARCHAR2(5000);
2092: lv_sql1_1 VARCHAR2(4000);
2093: lv_sql1_2 VARCHAR2(1000);