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.PA_PLANNING_RESOURCE_UTILS dependencies on MTL_CATEGORIES_B

Line 1115: FROM mtl_categories_b c, mtl_category_set_valid_cats I

1111: l_error_msg_data fnd_new_messages.message_name%TYPE;
1112:
1113: CURSOR c_ids IS
1114: SELECT c.category_id
1115: FROM mtl_categories_b c, mtl_category_set_valid_cats I
1116: WHERE i.category_set_id = p_item_category_set_id
1117: AND i.category_id = c.category_id
1118: AND nvl(c.disable_date,sysdate) >= sysdate
1119: AND fnd_Flex_ext.GET_SEGS('INV', 'MCAT', c.structure_id, c.category_id) =

Line 1131: FROM mtl_categories_b c, mtl_category_set_valid_cats I

1127: IF (p_check_id_flag = 'Y') THEN
1128: BEGIN
1129: SELECT c.category_id
1130: INTO x_item_category_id
1131: FROM mtl_categories_b c, mtl_category_set_valid_cats I
1132: WHERE i.category_set_id = p_item_category_set_id
1133: AND i.category_id = c.category_id
1134: AND NVL(c.disable_date,sysdate) >= sysdate
1135: AND c.category_id = p_item_cat_id;

Line 1188: FROM mtl_categories_b c, mtl_category_set_valid_cats I

1184: IF (p_item_cat_name IS NOT NULL) THEN
1185: BEGIN
1186: SELECT c.category_id
1187: INTO x_item_category_id
1188: FROM mtl_categories_b c, mtl_category_set_valid_cats I
1189: WHERE i.category_set_id = p_item_category_set_id
1190: AND i.category_id = c.category_id
1191: AND nvl(c.disable_date,sysdate) >= sysdate
1192: AND fnd_Flex_ext.GET_SEGS('INV', 'MCAT', c.structure_id, c.category_id) = p_item_cat_name;