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_ITEM_CATEGORY_OI dependencies on MTL_ITEM_CATEGORIES

Line 31: SELECT category_id FROM mtl_item_categories

27: CURSOR c_cat_assign_exists (cp_item_id NUMBER,
28: cp_org_id NUMBER,
29: cp_cat_set_id NUMBER)
30: IS
31: SELECT category_id FROM mtl_item_categories
32: WHERE inventory_item_id = cp_item_id
33: AND organization_id = cp_org_id
34: AND category_set_id = cp_cat_set_id;
35:

Line 78: UPDATE mtl_item_categories_interface

74: , p_transaction_id => p_transaction_id
75: , p_column_name => l_column_name
76: );
77:
78: UPDATE mtl_item_categories_interface
79: SET process_flag = 3
80: WHERE rowid = p_row_id;
81:
82: ELSE

Line 83: UPDATE mtl_item_categories_interface

79: SET process_flag = 3
80: WHERE rowid = p_row_id;
81:
82: ELSE
83: UPDATE mtl_item_categories_interface
84: SET old_category_id = l_category_id,
85: transaction_type = 'UPDATE'
86: WHERE rowid = p_row_id;
87:

Line 92: UPDATE mtl_item_categories_interface

88: l_transaction_type := 'UPDATE';
89: l_old_category_id := l_category_id;
90: END IF;
91: ELSE
92: UPDATE mtl_item_categories_interface
93: SET transaction_type = 'CREATE'
94: WHERE rowid = p_row_id;
95:
96: l_transaction_type := 'CREATE';

Line 141: mtl_item_categories_interface mici

137: , mici.category_set_id, mici.category_id
138: , mici.organization_code, mici.item_number
139: , mici.category_set_name, mici.category_name
140: FROM
141: mtl_item_categories_interface mici
142: WHERE
143: set_process_id = g_xset_id
144: AND process_flag = 1
145: AND ( organization_id IS NULL

Line 172: mtl_item_categories_interface mici

168: , mici.category_set_name, mici.category_name
169: , mici.old_category_id, mici.old_category_name --* Added for Bug #3991044
170: , mici.created_by
171: FROM
172: mtl_item_categories_interface mici
173: , mtl_parameters mp
174: WHERE
175: mici.set_process_id = g_xset_id
176: AND mici.organization_id = mp.organization_id

Line 224: FROM mtl_item_categories_interface

220: IS
221: -- SELECT DISTINCT item_number, organization_id
222: SELECT rowid, transaction_id
223: , item_number, organization_id
224: FROM mtl_item_categories_interface
225: WHERE set_process_id = g_xset_id
226: AND inventory_item_id IS NULL
227: AND item_number IS NOT NULL
228: AND category_set_id IS NOT NULL

Line 237: FROM mtl_item_categories_interface

233: CURSOR miss_category_id_csr
234: IS
235: SELECT rowid, transaction_id
236: , category_name, organization_id, category_set_id
237: FROM mtl_item_categories_interface
238: WHERE set_process_id = g_xset_id
239: AND category_id IS NULL
240: AND category_name IS NOT NULL
241: AND category_set_id IS NOT NULL

Line 252: FROM mtl_item_categories_interface i

248: -- (not used)
249: /*
250: CURSOR miss_id_csr IS
251: SELECT i.transaction_id, i.organization_id
252: FROM mtl_item_categories_interface i
253: WHERE i.process_flag = l_process_flag_2
254: AND set_process_id = g_xset_id
255: AND ( i.organization_id = org_id OR all_org = l_All_Org )
256: AND (

Line 292: FROM MTL_ITEM_CATEGORIES_INTERFACE mic

288: ,mic.CREATED_BY
289: ,mic.LAST_UPDATE_DATE
290: ,mic.LAST_UPDATED_BY
291: ,mic.LAST_UPDATE_LOGIN
292: FROM MTL_ITEM_CATEGORIES_INTERFACE mic
293: WHERE REQUEST_ID = cp_request_id
294: AND set_process_id = cp_set_id
295: AND process_flag = 7;
296:

Line 356: FROM mtl_item_categories_interface

352: -- IF NVL(fnd_global.conc_program_id,-1) <> -1 THEN Bug:3547401
353: IF NVL(p_prog_id,-1) <> -1 THEN
354:
355: SELECT count(*) INTO l_records
356: FROM mtl_item_categories_interface
357: WHERE set_process_id = p_rec_set_id
358: AND process_flag IN (1,2,4); --R12C
359:
360: -- Bug 6983407 Collect statistics only if the no. of records is bigger than the profile

Line 364: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');

360: -- Bug 6983407 Collect statistics only if the no. of records is bigger than the profile
361: -- option threshold
362: IF l_records > nvl(fnd_profile.value('EGO_GATHER_STATS'),100) AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema) THEN
363: IF l_schema IS NOT NULL THEN
364: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');
365: END IF;
366: END IF;
367: END IF;
368: --End 2698140 : Gather stats before running

Line 413: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';

409: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
410: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
411: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
412:
413: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';
414:
415: INV_ITEM_MSG.g_User_id := g_User_id;
416: INV_ITEM_MSG.g_Login_id := g_Login_id;
417: INV_ITEM_MSG.g_Prog_appid := g_Prog_appid;

Line 441: UPDATE mtl_item_categories_interface mici

437: IF (l_debug = 1) THEN
438: INV_ITEM_MSG.Debug(Mctx, 'assign all missing organization_id');
439: END IF;
440:
441: UPDATE mtl_item_categories_interface mici
442: SET
443: ( mici.organization_id
444: , process_flag
445: ) =

Line 470: UPDATE mtl_item_categories_interface

466: SELECT mtl_system_items_interface_s.NEXTVAL
467: INTO l_transaction_id
468: FROM dual;
469:
470: UPDATE mtl_item_categories_interface
471: SET
472: -- transaction_id = mtl_system_items_interface_s.NEXTVAL
473: transaction_id = l_transaction_id
474: , request_id = g_request_id

Line 1255: UPDATE mtl_item_categories_interface

1251: IF (l_debug = 1) THEN
1252: INV_ITEM_MSG.Debug(Mctx, 'update interface record');
1253: END IF;
1254:
1255: UPDATE mtl_item_categories_interface
1256: SET
1257: transaction_id = l_transaction_id
1258: , transaction_type = l_transaction_type
1259: , process_flag = l_process_flag

Line 1280: FROM mtl_item_categories_interface mici

1276: /* Bug 4527222*/
1277: BEGIN
1278: SELECT 'Y'
1279: INTO l_records_updated
1280: FROM mtl_item_categories_interface mici
1281: WHERE mici.set_process_id = g_xset_id
1282: AND mici.process_flag = 7
1283: AND ROWNUM = 1;
1284:

Line 1506: DELETE FROM mtl_item_categories_interface

1502: -- Initialize API return status to success
1503: x_return_status := FND_API.g_RET_STS_SUCCESS;
1504:
1505: LOOP
1506: DELETE FROM mtl_item_categories_interface
1507: WHERE set_process_id = p_rec_set_id
1508: AND process_flag = l_del_process_flag
1509: AND rownum < G_ROWS_TO_COMMIT;
1510: