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

Line 122: FROM mtl_item_categories

118: , p_category_set_id NUMBER
119: , p_category_id NUMBER
120: ) IS
121: SELECT COUNT( category_id ), COUNT( DECODE(category_id, p_category_id,1, NULL) )
122: FROM mtl_item_categories
123: WHERE
124: inventory_item_id = p_inventory_item_id
125: AND organization_id = p_organization_id
126: AND category_set_id = p_category_set_id;

Line 373: DELETE FROM mtl_item_categories

369: IF (l_request_id = p_request_id ) THEN
370: -- Delete a row from the table and create with new category
371: --Modified for bug 3255128
372: IF (l_control_level = 1) THEN
373: DELETE FROM mtl_item_categories
374: WHERE inventory_item_id = p_inventory_item_id
375: AND category_set_id = p_category_set_id;
376: ELSE
377: DELETE FROM mtl_item_categories

Line 377: DELETE FROM mtl_item_categories

373: DELETE FROM mtl_item_categories
374: WHERE inventory_item_id = p_inventory_item_id
375: AND category_set_id = p_category_set_id;
376: ELSE
377: DELETE FROM mtl_item_categories
378: WHERE organization_id = p_organization_id
379: AND inventory_item_id = p_inventory_item_id
380: AND category_set_id = p_category_set_id;
381: END IF;

Line 401: INV_ITEM_MSG.Debug(Mctx, 'begin INSERT INTO mtl_item_categories');

397:
398: IF (l_the_cat_assign_count = 0) THEN
399:
400: IF (l_debug = 1) THEN
401: INV_ITEM_MSG.Debug(Mctx, 'begin INSERT INTO mtl_item_categories');
402: END IF;
403:
404: IF ((l_control_level = 1) and (p_organization_id = p_master_org_id)) THEN
405:

Line 407: INSERT INTO mtl_item_categories

403:
404: IF ((l_control_level = 1) and (p_organization_id = p_master_org_id)) THEN
405:
406: -- If the category control level is 1 and we are inserting for master record then the assignemnt should also be made for child records.
407: INSERT INTO mtl_item_categories
408: (
409: inventory_item_id
410: , organization_id
411: , category_set_id

Line 437: FROM mtl_item_categories

433: AND i.inventory_item_id = p_inventory_item_id
434: AND i.organization_id = p.organization_id
435: AND not exists
436: (SELECT 'x'
437: FROM mtl_item_categories
438: whERE inventory_item_id = p_inventory_item_id
439: AND organization_id = p.organization_id
440: AND category_set_id = p_category_set_id
441: AND category_id = p_category_id);

Line 443: INSERT INTO mtl_item_categories

439: AND organization_id = p.organization_id
440: AND category_set_id = p_category_set_id
441: AND category_id = p_category_id);
442: ELSE
443: INSERT INTO mtl_item_categories
444: (
445: inventory_item_id
446: , organization_id
447: , category_set_id

Line 471: INV_ITEM_MSG.Debug(Mctx, 'end INSERT INTO mtl_item_categories');

467: , FND_GLOBAL.conc_request_id
468: );
469: END IF;
470: IF (l_debug = 1) THEN
471: INV_ITEM_MSG.Debug(Mctx, 'end INSERT INTO mtl_item_categories');
472: END IF;
473: ELSIF (l_request_id <> p_request_id ) THEN -- Bug:3260965 Incase of Default assignment donot show error
474: --INV_ITEM_MSG.Add_Warning('INV_CAT_ASSGN_ALREADY_EXISTS');
475: INV_ITEM_MSG.Add_Message

Line 653: --INV_ITEM_MSG.Debug(Mctx, 'before DELETE FROM mtl_item_categories');

649: -- Initialize API return status to success
650: x_return_status := FND_API.g_RET_STS_SUCCESS;
651:
652: --INV_ITEM_MSG.Debug(Mctx, 'NO VALIDATION IMPLEMENTED');
653: --INV_ITEM_MSG.Debug(Mctx, 'before DELETE FROM mtl_item_categories');
654:
655: OPEN category_sets_csr (p_category_set_id);
656: FETCH category_sets_csr INTO l_control_level, l_category_id;
657:

Line 725: FROM mtl_item_categories

721: end if;
722:
723: SELECT count(category_id)
724: INTO cnt_cat
725: FROM mtl_item_categories
726: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
727: AND ORGANIZATION_ID = p_organization_id
728: AND CATEGORY_SET_ID = p_category_set_id;
729:

Line 785: DELETE /+ INDEX(MIC MTL_ITEM_CATEGORIES_U1) /

781: END IF;
782:
783: IF ((l_control_level = 1) and (p_organization_id = p_master_org_id)) THEN
784: --Bug: 3561206 Added an index for performance improvement
785: DELETE /*+ INDEX(MIC MTL_ITEM_CATEGORIES_U1) */
786: FROM mtl_item_categories MIC
787: WHERE category_set_id = p_category_set_id
788: AND category_id = p_category_id
789: AND inventory_item_id = p_inventory_item_id

Line 786: FROM mtl_item_categories MIC

782:
783: IF ((l_control_level = 1) and (p_organization_id = p_master_org_id)) THEN
784: --Bug: 3561206 Added an index for performance improvement
785: DELETE /*+ INDEX(MIC MTL_ITEM_CATEGORIES_U1) */
786: FROM mtl_item_categories MIC
787: WHERE category_set_id = p_category_set_id
788: AND category_id = p_category_id
789: AND inventory_item_id = p_inventory_item_id
790: AND organization_id =

Line 798: DELETE FROM mtl_item_categories

794: AND p.organization_id = mic.organization_id);
795: ELSE
796: -- Delete a row from the table
797: --
798: DELETE FROM mtl_item_categories
799: WHERE organization_id = p_organization_id
800: AND inventory_item_id = p_inventory_item_id
801: AND category_set_id = p_category_set_id
802: AND category_id = p_category_id;

Line 814: INV_ITEM_MSG.Debug(Mctx, 'after DELETE FROM mtl_item_categories');

810: );
811: END IF;
812:
813: IF (l_debug = 1) THEN
814: INV_ITEM_MSG.Debug(Mctx, 'after DELETE FROM mtl_item_categories');
815: END IF;
816:
817: -- Standard check of p_commit
818: IF (FND_API.To_Boolean (p_commit)) THEN

Line 1157: FROM mtl_item_categories

1153:
1154: --* Checking whether Category Assignment exists for old category id
1155: SELECT Count(1)
1156: INTO l_reccount
1157: FROM mtl_item_categories
1158: WHERE inventory_item_id = p_inventory_item_id
1159: AND organization_id = p_organization_id
1160: AND category_set_id = p_category_set_id
1161: AND category_id = p_old_category_id;

Line 1248: FROM mtl_item_categories

1244: INV_ITEM_MSG.Debug(Mctx, 'Checking for duplicate records');
1245: END IF;
1246: SELECT Count(1)
1247: INTO l_reccount
1248: FROM mtl_item_categories
1249: WHERE inventory_item_id = p_inventory_item_id
1250: AND organization_id = p_organization_id
1251: AND category_set_id = p_category_set_id
1252: AND category_id = p_category_id;

Line 1282: INV_ITEM_MSG.Debug(Mctx, 'Updating Mtl_Item_Categories...');

1278:
1279:
1280: --* Updating Master Org or Master Org + Child Orgs depending on Control Level
1281: IF (l_debug = 1) THEN
1282: INV_ITEM_MSG.Debug(Mctx, 'Updating Mtl_Item_Categories...');
1283: END IF;
1284:
1285: IF ((l_control_level = 1) and (p_organization_id = p_master_org_id)) THEN
1286: UPDATE /*+ INDEX(MIC MTL_ITEM_CATEGORIES_U1) */

Line 1286: UPDATE /+ INDEX(MIC MTL_ITEM_CATEGORIES_U1) /

1282: INV_ITEM_MSG.Debug(Mctx, 'Updating Mtl_Item_Categories...');
1283: END IF;
1284:
1285: IF ((l_control_level = 1) and (p_organization_id = p_master_org_id)) THEN
1286: UPDATE /*+ INDEX(MIC MTL_ITEM_CATEGORIES_U1) */
1287: Mtl_Item_Categories MIC
1288: SET Category_Id = p_category_id
1289: ,last_update_date = SYSDATE
1290: ,last_updated_by = FND_GLOBAL.user_id

Line 1287: Mtl_Item_Categories MIC

1283: END IF;
1284:
1285: IF ((l_control_level = 1) and (p_organization_id = p_master_org_id)) THEN
1286: UPDATE /*+ INDEX(MIC MTL_ITEM_CATEGORIES_U1) */
1287: Mtl_Item_Categories MIC
1288: SET Category_Id = p_category_id
1289: ,last_update_date = SYSDATE
1290: ,last_updated_by = FND_GLOBAL.user_id
1291: ,last_update_login = FND_GLOBAL.login_id

Line 1324: UPDATE Mtl_Item_Categories

1320: END IF;
1321: --Bug 6008273
1322:
1323: ELSE
1324: UPDATE Mtl_Item_Categories
1325: SET Category_Id = p_category_id
1326: ,last_update_date = SYSDATE
1327: ,last_updated_by = FND_GLOBAL.user_id
1328: ,last_update_login = FND_GLOBAL.login_id

Line 1360: INV_ITEM_MSG.Debug(Mctx, 'after update FROM mtl_item_categories');

1356:
1357: END IF;
1358:
1359: IF (l_debug = 1) THEN
1360: INV_ITEM_MSG.Debug(Mctx, 'after update FROM mtl_item_categories');
1361: END IF;
1362:
1363: -- Standard check of p_commit
1364: IF (FND_API.To_Boolean (p_commit)) THEN