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 1111: FROM mtl_categories_b c, mtl_category_set_valid_cats I

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

Line 1127: FROM mtl_categories_b c, mtl_category_set_valid_cats I

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

Line 1184: FROM mtl_categories_b c, mtl_category_set_valid_cats I

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