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 123: FROM mtl_item_categories

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

Line 383: DELETE FROM mtl_item_categories

379: IF (l_request_id = p_request_id ) THEN
380: -- Delete a row from the table and create with new category
381: --Modified for bug 3255128
382: IF (l_control_level = 1) THEN
383: DELETE FROM mtl_item_categories
384: WHERE inventory_item_id = p_inventory_item_id
385: AND category_set_id = p_category_set_id;
386: ELSE
387: DELETE FROM mtl_item_categories

Line 387: DELETE FROM mtl_item_categories

383: DELETE FROM mtl_item_categories
384: WHERE inventory_item_id = p_inventory_item_id
385: AND category_set_id = p_category_set_id;
386: ELSE
387: DELETE FROM mtl_item_categories
388: WHERE organization_id = p_organization_id
389: AND inventory_item_id = p_inventory_item_id
390: AND category_set_id = p_category_set_id;
391: END IF;

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

407:
408: IF (l_the_cat_assign_count = 0) THEN
409:
410: IF (l_debug = 1) THEN
411: INV_ITEM_MSG.Debug(Mctx, 'begin INSERT INTO mtl_item_categories');
412: END IF;
413:
414: IF ((l_control_level = 1) and (p_organization_id = p_master_org_id)) THEN
415:

Line 417: INSERT INTO mtl_item_categories

413:
414: IF ((l_control_level = 1) and (p_organization_id = p_master_org_id)) THEN
415:
416: -- If the category control level is 1 and we are inserting for master record then the assignemnt should also be made for child records.
417: INSERT INTO mtl_item_categories
418: (
419: inventory_item_id
420: , organization_id
421: , category_set_id

Line 447: FROM mtl_item_categories

443: AND i.inventory_item_id = p_inventory_item_id
444: AND i.organization_id = p.organization_id
445: AND not exists
446: (SELECT 'x'
447: FROM mtl_item_categories
448: whERE inventory_item_id = p_inventory_item_id
449: AND organization_id = p.organization_id
450: AND category_set_id = p_category_set_id
451: AND category_id = p_category_id);

Line 453: INSERT INTO mtl_item_categories

449: AND organization_id = p.organization_id
450: AND category_set_id = p_category_set_id
451: AND category_id = p_category_id);
452: ELSE
453: INSERT INTO mtl_item_categories
454: (
455: inventory_item_id
456: , organization_id
457: , category_set_id

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

477: , FND_GLOBAL.conc_request_id
478: );
479: END IF;
480: IF (l_debug = 1) THEN
481: INV_ITEM_MSG.Debug(Mctx, 'end INSERT INTO mtl_item_categories');
482: END IF;
483: ELSIF (l_request_id <> p_request_id ) THEN -- Bug:3260965 Incase of Default assignment donot show error
484: --INV_ITEM_MSG.Add_Warning('INV_CAT_ASSGN_ALREADY_EXISTS');
485: INV_ITEM_MSG.Add_Message

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

659: -- Initialize API return status to success
660: x_return_status := FND_API.g_RET_STS_SUCCESS;
661:
662: --INV_ITEM_MSG.Debug(Mctx, 'NO VALIDATION IMPLEMENTED');
663: --INV_ITEM_MSG.Debug(Mctx, 'before DELETE FROM mtl_item_categories');
664:
665: OPEN category_sets_csr (p_category_set_id);
666: FETCH category_sets_csr INTO l_control_level, l_category_id;
667:

Line 735: FROM mtl_item_categories

731: end if;
732:
733: SELECT count(category_id)
734: INTO cnt_cat
735: FROM mtl_item_categories
736: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
737: AND ORGANIZATION_ID = p_organization_id
738: AND CATEGORY_SET_ID = p_category_set_id;
739:

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

791: END IF;
792:
793: IF ((l_control_level = 1) and (p_organization_id = p_master_org_id)) THEN
794: --Bug: 3561206 Added an index for performance improvement
795: DELETE /*+ INDEX(MIC MTL_ITEM_CATEGORIES_U1) */
796: FROM mtl_item_categories MIC
797: WHERE category_set_id = p_category_set_id
798: AND category_id = p_category_id
799: AND inventory_item_id = p_inventory_item_id

Line 796: FROM mtl_item_categories MIC

792:
793: IF ((l_control_level = 1) and (p_organization_id = p_master_org_id)) THEN
794: --Bug: 3561206 Added an index for performance improvement
795: DELETE /*+ INDEX(MIC MTL_ITEM_CATEGORIES_U1) */
796: FROM mtl_item_categories MIC
797: WHERE category_set_id = p_category_set_id
798: AND category_id = p_category_id
799: AND inventory_item_id = p_inventory_item_id
800: AND organization_id =

Line 808: DELETE FROM mtl_item_categories

804: AND p.organization_id = mic.organization_id);
805: ELSE
806: -- Delete a row from the table
807: --
808: DELETE FROM mtl_item_categories
809: WHERE organization_id = p_organization_id
810: AND inventory_item_id = p_inventory_item_id
811: AND category_set_id = p_category_set_id
812: AND category_id = p_category_id;

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

822: RAISE FND_API.g_EXC_ERROR;
823: END IF;
824:
825: IF (l_debug = 1) THEN
826: INV_ITEM_MSG.Debug(Mctx, 'after DELETE FROM mtl_item_categories');
827: END IF;
828:
829: -- Standard check of p_commit
830: IF (FND_API.To_Boolean (p_commit)) THEN

Line 1169: FROM mtl_item_categories

1165:
1166: --* Checking whether Category Assignment exists for old category id
1167: SELECT Count(1)
1168: INTO l_reccount
1169: FROM mtl_item_categories
1170: WHERE inventory_item_id = p_inventory_item_id
1171: AND organization_id = p_organization_id
1172: AND category_set_id = p_category_set_id
1173: AND category_id = p_old_category_id;

Line 1260: FROM mtl_item_categories

1256: INV_ITEM_MSG.Debug(Mctx, 'Checking for duplicate records');
1257: END IF;
1258: SELECT Count(1)
1259: INTO l_reccount
1260: FROM mtl_item_categories
1261: WHERE inventory_item_id = p_inventory_item_id
1262: AND organization_id = p_organization_id
1263: AND category_set_id = p_category_set_id
1264: AND category_id = p_category_id;

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

1290:
1291:
1292: --* Updating Master Org or Master Org + Child Orgs depending on Control Level
1293: IF (l_debug = 1) THEN
1294: INV_ITEM_MSG.Debug(Mctx, 'Updating Mtl_Item_Categories...');
1295: END IF;
1296:
1297: IF ((l_control_level = 1) and (p_organization_id = p_master_org_id)) THEN
1298: UPDATE /*+ INDEX(MIC MTL_ITEM_CATEGORIES_U1) */

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

1294: INV_ITEM_MSG.Debug(Mctx, 'Updating Mtl_Item_Categories...');
1295: END IF;
1296:
1297: IF ((l_control_level = 1) and (p_organization_id = p_master_org_id)) THEN
1298: UPDATE /*+ INDEX(MIC MTL_ITEM_CATEGORIES_U1) */
1299: Mtl_Item_Categories MIC
1300: SET Category_Id = p_category_id
1301: ,last_update_date = SYSDATE
1302: ,last_updated_by = FND_GLOBAL.user_id

Line 1299: Mtl_Item_Categories MIC

1295: END IF;
1296:
1297: IF ((l_control_level = 1) and (p_organization_id = p_master_org_id)) THEN
1298: UPDATE /*+ INDEX(MIC MTL_ITEM_CATEGORIES_U1) */
1299: Mtl_Item_Categories MIC
1300: SET Category_Id = p_category_id
1301: ,last_update_date = SYSDATE
1302: ,last_updated_by = FND_GLOBAL.user_id
1303: ,last_update_login = FND_GLOBAL.login_id

Line 1354: UPDATE Mtl_Item_Categories

1350: END IF;
1351: --Bug 6008273
1352:
1353: ELSE
1354: UPDATE Mtl_Item_Categories
1355: SET Category_Id = p_category_id
1356: ,last_update_date = SYSDATE
1357: ,last_updated_by = FND_GLOBAL.user_id
1358: ,last_update_login = FND_GLOBAL.login_id

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

1394:
1395: END IF;
1396:
1397: IF (l_debug = 1) THEN
1398: INV_ITEM_MSG.Debug(Mctx, 'after update FROM mtl_item_categories');
1399: END IF;
1400:
1401: -- Standard check of p_commit
1402: IF (FND_API.To_Boolean (p_commit)) THEN