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.INV_MIGRATE_PROCESS_ORG dependencies on MTL_PARAMETERS

Line 47: FROM mtl_parameters

43: AND organization_id = P_organization_id);
44:
45: CURSOR Cur_get_details(V_organization_id NUMBER) IS
46: SELECT *
47: FROM mtl_parameters
48: WHERE organization_id = V_organization_id;
49:
50: --Local Variables
51: l_migrate_count NUMBER;

Line 77: --Fetch some details from mtl_parameters table to pass the parameter values.

73: OPEN Cur_check_subinventory;
74: FETCH Cur_check_subinventory INTO l_temp;
75: IF (Cur_check_subinventory%NOTFOUND) THEN
76: CLOSE Cur_check_subinventory;
77: --Fetch some details from mtl_parameters table to pass the parameter values.
78: OPEN Cur_get_details(P_organization_id);
79: FETCH Cur_get_details INTO l_details;
80: CLOSE Cur_get_details;
81: IF (l_details.stock_locator_control_code = 4) THEN

Line 229: FROM mtl_parameters

225: P_commit IN VARCHAR2,
226: X_failure_count OUT NOCOPY NUMBER) IS
227: CURSOR Cur_get_orgn IS
228: SELECT organization_id, process_orgn_code
229: FROM mtl_parameters
230: WHERE process_enabled_flag = 'Y';
231:
232: CURSOR Cur_get_oper_unit (V_orgn_code VARCHAR2)IS
233: SELECT a.co_code

Line 265: p_table_name => 'MTL_PARAMETERS',

261: GMA_COMMON_LOGGING.gma_migration_central_log (
262: p_run_id => l_migration_id,
263: p_log_level => FND_LOG.LEVEL_PROCEDURE,
264: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
265: p_table_name => 'MTL_PARAMETERS',
266: p_context => 'ORGANIZATION',
267: p_app_short_name => 'GMA');
268:
269: /*Bug 5358112 - Setting the cost method to 1 and cost organization id to itself */

Line 270: UPDATE mtl_parameters

266: p_context => 'ORGANIZATION',
267: p_app_short_name => 'GMA');
268:
269: /*Bug 5358112 - Setting the cost method to 1 and cost organization id to itself */
270: UPDATE mtl_parameters
271: SET lot_number_uniqueness = 2,
272: primary_cost_method = 1,
273: cost_organization_id = organization_id
274: WHERE process_enabled_flag = 'Y';

Line 276: --Update some specific columns in the mtl_parameters table for existing organizations

272: primary_cost_method = 1,
273: cost_organization_id = organization_id
274: WHERE process_enabled_flag = 'Y';
275:
276: --Update some specific columns in the mtl_parameters table for existing organizations
277: FOR l_rec IN Cur_get_orgn LOOP
278: UPDATE mtl_parameters m
279: SET stock_locator_control_code = 4
280: WHERE organization_id = l_rec.organization_id

Line 278: UPDATE mtl_parameters m

274: WHERE process_enabled_flag = 'Y';
275:
276: --Update some specific columns in the mtl_parameters table for existing organizations
277: FOR l_rec IN Cur_get_orgn LOOP
278: UPDATE mtl_parameters m
279: SET stock_locator_control_code = 4
280: WHERE organization_id = l_rec.organization_id
281: AND EXISTS (SELECT 1
282: FROM IC_WHSE_MST

Line 309: /* missing - due to an issue in the gmf_mtl_parameters_biur_tg trigger code - Bug 5553034*/

305: WHERE loct_ctl > 0
306: AND mtl_organization_id = l_rec.organization_id);
307:
308: /* Update secondary inventories table for any rows that had the default cost group id */
309: /* missing - due to an issue in the gmf_mtl_parameters_biur_tg trigger code - Bug 5553034*/
310: UPDATE mtl_secondary_inventories
311: SET default_cost_group_id = (SELECT default_cost_group_id
312: FROM mtl_parameters
313: WHERE organization_id = l_rec.organization_id)

Line 312: FROM mtl_parameters

308: /* Update secondary inventories table for any rows that had the default cost group id */
309: /* missing - due to an issue in the gmf_mtl_parameters_biur_tg trigger code - Bug 5553034*/
310: UPDATE mtl_secondary_inventories
311: SET default_cost_group_id = (SELECT default_cost_group_id
312: FROM mtl_parameters
313: WHERE organization_id = l_rec.organization_id)
314: WHERE default_cost_group_id IS NULL
315: AND organization_id = l_rec.organization_id
316: AND secondary_inventory_name <> 'AX_INTRANS';

Line 347: p_table_name => 'MTL_PARAMETERS',

343: GMA_COMMON_LOGGING.gma_migration_central_log (
344: p_run_id => l_migration_id,
345: p_log_level => FND_LOG.LEVEL_PROCEDURE,
346: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
347: p_table_name => 'MTL_PARAMETERS',
348: p_context => 'ORGANIZATION',
349: p_param1 => l_migrate_count,
350: p_param2 => X_failure_count,
351: p_app_short_name => 'GMA');

Line 364: p_table_name => 'MTL_PARAMETERS',

360: GMA_COMMON_LOGGING.gma_migration_central_log (
361: p_run_id => l_migration_id,
362: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
363: p_message_token => 'GMA_MIGRATION_DB_ERROR',
364: p_table_name => 'MTL_PARAMETERS',
365: p_context => 'ORGANIZATION',
366: p_db_error => SQLERRM,
367: p_app_short_name => 'GMA');
368:

Line 373: p_table_name => 'MTL_PARAMETERS',

369: GMA_COMMON_LOGGING.gma_migration_central_log (
370: p_run_id => l_migration_id,
371: p_log_level => FND_LOG.LEVEL_PROCEDURE,
372: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
373: p_table_name => 'MTL_PARAMETERS',
374: p_context => 'ORGANIZATION',
375: p_app_short_name => 'GMA');
376:
377: END update_organization;

Line 798: FROM mtl_parameters

794: AND organization_id = V_organization_id);
795:
796: CURSOR Cur_get_details(V_orgn_id NUMBER) IS
797: SELECT *
798: FROM mtl_parameters
799: WHERE organization_id = V_orgn_id;
800:
801: --Local Variables
802: l_migration_id NUMBER;

Line 847: --Fecth some details from mtl_parameters table to pass the parameter values.

843: ELSE
844: l_organization_id := l_rec.organization_id;
845: END IF;
846:
847: --Fecth some details from mtl_parameters table to pass the parameter values.
848: OPEN Cur_get_details(l_organization_id);
849: FETCH Cur_get_details INTO l_details;
850: CLOSE Cur_get_details;
851:

Line 1088: FROM mtl_parameters m, ic_whse_mst w

1084: X_organization_id OUT NOCOPY NUMBER) IS
1085: --CURSORS
1086: CURSOR Cur_get_organization_id (V_orgn_code VARCHAR2)IS
1087: SELECT m.organization_id
1088: FROM mtl_parameters m, ic_whse_mst w
1089: WHERE w.orgn_code = V_orgn_code
1090: AND w.mtl_organization_id = m.organization_id
1091: ORDER BY whse_code;
1092:

Line 1121: FROM mtl_parameters);

1117: FROM gl_sevt_ttl t1, gl_sevt_ttl t2
1118: WHERE rownum <= decode(v_start_ch, 0, 1000, 1, 100, 10)
1119: minus
1120: SELECT organization_code
1121: FROM mtl_parameters);
1122:
1123: CURSOR Cur_get_orgn_values(V_orgn_id NUMBER) IS
1124: SELECT *
1125: FROM mtl_parameters

Line 1125: FROM mtl_parameters

1121: FROM mtl_parameters);
1122:
1123: CURSOR Cur_get_orgn_values(V_orgn_id NUMBER) IS
1124: SELECT *
1125: FROM mtl_parameters
1126: WHERE organization_id = V_orgn_id;
1127: --Bug #13981860
1128: --Check if V_oranization_code is already exist in the mtl_parameters table
1129: CURSOR Cur_unique_validation(V_oranization_code VARCHAR2) IS

Line 1128: --Check if V_oranization_code is already exist in the mtl_parameters table

1124: SELECT *
1125: FROM mtl_parameters
1126: WHERE organization_id = V_orgn_id;
1127: --Bug #13981860
1128: --Check if V_oranization_code is already exist in the mtl_parameters table
1129: CURSOR Cur_unique_validation(V_oranization_code VARCHAR2) IS
1130: SELECT 'code_exists'
1131: FROM MTL_PARAMETERS
1132: WHERE organization_code = V_oranization_code;

Line 1131: FROM MTL_PARAMETERS

1127: --Bug #13981860
1128: --Check if V_oranization_code is already exist in the mtl_parameters table
1129: CURSOR Cur_unique_validation(V_oranization_code VARCHAR2) IS
1130: SELECT 'code_exists'
1131: FROM MTL_PARAMETERS
1132: WHERE organization_code = V_oranization_code;
1133:
1134:
1135: --LOCAL VARIABLES

Line 1322: --Fetch the organization info from mtl_parameters and insert into the table.

1318: 0,
1319: 0,
1320: sysdate);
1321:
1322: --Fetch the organization info from mtl_parameters and insert into the table.
1323: OPEN Cur_get_orgn_values(l_org_id);
1324: FETCH Cur_get_orgn_values INTO l_parameter;
1325: CLOSE Cur_get_orgn_values;
1326:

Line 1377: INSERT INTO mtl_parameters(

1373: RAISE COST_GROUP_SETUP_ERR;
1374: END IF;
1375:
1376: /* Bug 5358112 changed the primary cost method to 1 */
1377: INSERT INTO mtl_parameters(
1378: organization_id, last_update_date, last_updated_by, creation_date, created_by, last_update_login,
1379: organization_code, master_organization_id, primary_cost_method, cost_organization_id,
1380: default_material_cost_id, calendar_exception_set_id, calendar_code, general_ledger_update_code,
1381: default_atp_rule_id, default_picking_rule_id, default_locator_order_value, default_subinv_order_value,

Line 1671: UPDATE mtl_parameters

1667: END IF;
1668: ELSE
1669: l_organization_id := l_rec.organization_id;
1670: --RLNAGARA Material Status Migration ME - Updating for already existing organizations
1671: UPDATE mtl_parameters
1672: SET default_status_id = l_default_status_id
1673: WHERE organization_id = l_rec.organization_id;
1674: END IF; /* IF NVL(l_rec.migrate_as_ind, 1) IN (1,3) */
1675:

Line 1698: UPDATE mtl_parameters

1694: l_migrate_count := l_migrate_count + 1;
1695: ELSE -- Fix for Bug#9143261. Added following statements in else clause
1696: IF l_rec.default_status IS NOT NULL THEN
1697:
1698: UPDATE mtl_parameters
1699: SET default_status_id = l_default_status_id
1700: WHERE organization_id = l_rec.organization_id
1701: AND default_status_id IS NULL ;
1702: