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 IC_WHSE_MST

Line 69: -- p_table_name => 'IC_WHSE_MST',

65: -- GMA_COMMON_LOGGING.gma_migration_central_log (
66: -- p_run_id => l_migration_id,
67: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
68: -- p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
69: -- p_table_name => 'IC_WHSE_MST',
70: -- p_context => 'WHSE_SYNC',
71: -- p_app_short_name => 'GMA');
72:
73: OPEN Cur_check_subinventory;

Line 170: -- p_table_name => 'IC_WHSE_MST',

166: -- GMA_COMMON_LOGGING.gma_migration_central_log (
167: -- p_run_id => l_migration_id,
168: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
169: -- p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
170: -- p_table_name => 'IC_WHSE_MST',
171: -- p_context => 'WHSE_SYNC',
172: -- p_app_short_name => 'GMA');
173:
174: EXCEPTION

Line 181: p_table_name => 'IC_WHSE_MST',

177: GMA_COMMON_LOGGING.gma_migration_central_log (
178: p_run_id => l_migration_id,
179: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
180: p_message_token => 'GMA_MIGRATION_DB_ERROR',
181: p_table_name => 'IC_WHSE_MST',
182: p_context => 'WHSE_SYNC',
183: p_db_error => SQLERRM,
184: p_app_short_name => 'GMA');
185:

Line 192: -- p_table_name => 'IC_WHSE_MST',

188: -- GMA_COMMON_LOGGING.gma_migration_central_log (
189: -- p_run_id => l_migration_id,
190: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
191: -- p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
192: -- p_table_name => 'IC_WHSE_MST',
193: -- p_context => 'WHSE_SYNC',
194: -- p_app_short_name => 'GMA');
195:
196: END sync_whse_subinventory;

Line 241: FROM ic_whse_mst a

237: AND b.new_le_flag = 'Y';
238:
239: CURSOR Cur_get_whse (V_organization_id NUMBER) IS
240: SELECT a.whse_code, a.whse_name
241: FROM ic_whse_mst a
242: WHERE mtl_organization_id = V_organization_id
243: AND NVL(subinventory_ind_flag, 'N') = 'N'
244: AND NVL(migrated_ind,0) = 0;
245:

Line 282: FROM IC_WHSE_MST

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
283: WHERE loct_ctl > 0
284: AND mtl_organization_id = l_rec.organization_id);
285:
286: OPEN Cur_get_oper_unit(l_rec.process_orgn_code);

Line 304: FROM IC_WHSE_MST

300: UPDATE mtl_secondary_inventories
301: SET locator_type = 5
302: WHERE organization_id = l_rec.organization_id
303: AND EXISTS (SELECT 1
304: FROM IC_WHSE_MST
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 */

Line 331: UPDATE ic_whse_mst

327: IF l_failure_count > 0 THEN
328: CLOSE Cur_get_whse;
329: RAISE SYNC_WHSE_ERROR;
330: END IF;
331: UPDATE ic_whse_mst
332: SET migrated_ind = 1,
333: organization_id = mtl_organization_id
334: WHERE mtl_organization_id = l_rec.organization_id;
335: END IF;

Line 778: FROM ic_whse_mst_vw

774:
775: --CURSORS
776: CURSOR Cur_get_warehouse IS
777: SELECT *
778: FROM ic_whse_mst_vw
779: WHERE subinventory_ind_flag = 'Y'
780: AND orgn_code = P_orgn_code
781: AND NVL(migrated_ind,0) = 0;
782:

Line 829: -- p_table_name => 'IC_WHSE_MST',

825: -- GMA_COMMON_LOGGING.gma_migration_central_log (
826: -- p_run_id => l_migration_id,
827: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
828: -- p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
829: -- p_table_name => 'IC_WHSE_MST',
830: -- p_context => 'WAREHOUSE',
831: -- p_app_short_name => 'GMA');
832:
833: FOR l_rec IN Cur_get_warehouse LOOP

Line 876: p_table_name => 'IC_WHSE_MST',

872: GMA_COMMON_LOGGING.gma_migration_central_log (
873: p_run_id => l_migration_id,
874: p_log_level => FND_LOG.LEVEL_PROCEDURE,
875: p_message_token => 'GMA_WHSE_EXISTS',
876: p_table_name => 'IC_WHSE_MST',
877: p_context => 'WAREHOUSE',
878: p_token1 => 'WAREHOUSE',
879: p_param1 => l_rec.whse_code,
880: p_app_short_name => 'GMA');

Line 975: UPDATE ic_whse_mst

971: WHERE organization_id = l_rec.mtl_organization_id;
972: END IF;
973:
974: --Update the migrated ind for the warehouse.
975: UPDATE ic_whse_mst
976: SET organization_id = l_organization_id,
977: migrated_ind = 1
978: WHERE whse_code = l_rec.whse_code;
979:

Line 990: p_table_name => 'IC_WHSE_MST',

986: GMA_COMMON_LOGGING.gma_migration_central_log (
987: p_run_id => l_migration_id,
988: p_log_level => FND_LOG.LEVEL_ERROR,
989: p_message_token => 'GMD_ORG_NOT_MIGRATED',
990: p_table_name => 'IC_WHSE_MST',
991: p_context => 'WAREHOUSE',
992: p_token1 => 'ORGANIZATION',
993: p_param1 => l_rec.orgn_code,
994: p_app_short_name => 'GMA');

Line 1003: p_table_name => 'IC_WHSE_MST',

999: GMA_COMMON_LOGGING.gma_migration_central_log (
1000: p_run_id => l_migration_id,
1001: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1002: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1003: p_table_name => 'IC_WHSE_MST',
1004: p_context => 'WAREHOUSE',
1005: p_db_error => SQLERRM,
1006: p_app_short_name => 'GMA');
1007: END;

Line 1016: -- p_table_name => 'IC_WHSE_MST',

1012: -- GMA_COMMON_LOGGING.gma_migration_central_log (
1013: -- p_run_id => l_migration_id,
1014: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
1015: -- p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1016: -- p_table_name => 'IC_WHSE_MST',
1017: -- p_context => 'WAREHOUSE',
1018: -- p_app_short_name => 'GMA');
1019:
1020:

Line 1029: p_table_name => 'IC_WHSE_MST',

1025: GMA_COMMON_LOGGING.gma_migration_central_log (
1026: p_run_id => l_migration_id,
1027: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1028: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1029: p_table_name => 'IC_WHSE_MST',
1030: p_context => 'WAREHOUSE',
1031: p_db_error => SQLERRM,
1032: p_app_short_name => 'GMA');
1033:

Line 1040: -- p_table_name => 'IC_WHSE_MST',

1036: -- GMA_COMMON_LOGGING.gma_migration_central_log (
1037: -- p_run_id => l_migration_id,
1038: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
1039: -- p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
1040: -- p_table_name => 'IC_WHSE_MST',
1041: -- p_context => 'WAREHOUSE',
1042: -- p_app_short_name => 'GMA');
1043:
1044: END migrate_subinventory;

Line 1086: FROM mtl_parameters m, ic_whse_mst w

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