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_PUB dependencies on MTL_CATEGORY_SETS_B

Line 47: l_hierarchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE := NULL;

43: -- returns FALSE if the category_set_id is invalid
44: -- returns the hierarchy through the out parameter
45: --
46: -- END OF comments
47: l_hierarchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE := NULL;
48: BEGIN
49: IF p_category_set_id IS NULL THEN
50: RETURN FALSE;
51: END IF;

Line 53: FROM mtl_category_sets_b

49: IF p_category_set_id IS NULL THEN
50: RETURN FALSE;
51: END IF;
52: SELECT hierarchy_enabled INTO l_hierarchy_enabled
53: FROM mtl_category_sets_b
54: WHERE category_set_id = p_category_set_id;
55: IF (SQL%FOUND) THEN
56: x_hierarchy_enabled := l_hierarchy_enabled;
57: END IF;

Line 87: FROM mtl_categories_b cat, mtl_category_sets_b cat_set

83:
84: CURSOR c_validate_category_id (cp_category_id IN NUMBER
85: ,cp_cat_set_id IN NUMBER) IS
86: SELECT cat.category_id
87: FROM mtl_categories_b cat, mtl_category_sets_b cat_set
88: WHERE cat_set.category_set_id = cp_cat_set_id
89: AND cat_set.structure_id = cat.structure_id
90: AND cat.category_id = cp_category_id
91: AND ((cat.enabled_flag = 'Y'

Line 183: ,mtl_category_sets_b cs

179: BEGIN
180: SELECT csv.category_id, cs.hierarchy_enabled
181: INTO l_category_id, x_hrchy_enabled
182: FROM mtl_category_set_valid_cats csv
183: ,mtl_category_sets_b cs
184: WHERE csv.category_id = p_category_id
185: AND csv.category_set_id = p_category_set_id
186: AND cs.category_set_id = csv.category_set_id;
187: IF (SQL%FOUND) THEN

Line 224: l_def_category_id mtl_category_sets_b.default_category_id%TYPE;

220: -- END OF comments
221: l_api_name VARCHAR2(30) := 'Validate Params';
222: l_count NUMBER;
223: l_valid BOOLEAN := TRUE;
224: l_def_category_id mtl_category_sets_b.default_category_id%TYPE;
225: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
226: l_hierarchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE := NULL;
227: l_loop_may_occur BOOLEAN := FALSE;
228: l_category_id mtl_categories_b.category_id%TYPE;

Line 226: l_hierarchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE := NULL;

222: l_count NUMBER;
223: l_valid BOOLEAN := TRUE;
224: l_def_category_id mtl_category_sets_b.default_category_id%TYPE;
225: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
226: l_hierarchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE := NULL;
227: l_loop_may_occur BOOLEAN := FALSE;
228: l_category_id mtl_categories_b.category_id%TYPE;
229:
230: CURSOR c_check_loops (cp_parent_category_id IN NUMBER

Line 241: FROM mtl_category_sets_b cat_sets

237:
238: CURSOR c_get_default_category_id (cp_category_set_id IN NUMBER
239: ,cp_category_id IN NUMBER) IS
240: SELECT default_category_id
241: FROM mtl_category_sets_b cat_sets
242: WHERE cat_sets.category_set_id = cp_category_set_id
243: AND cat_sets.default_category_id = cp_category_id;
244:
245: CURSOR c_check_item_assocs (cp_category_set_id IN NUMBER

Line 2159: FROM mtl_category_sets_b

2155: SELECT 'x'
2156: FROM dual
2157: WHERE exists
2158: ( SELECT default_category_id
2159: FROM mtl_category_sets_b
2160: WHERE default_category_id = p_category_id
2161: );
2162:
2163:

Line 3068: l_def_category_id mtl_category_sets_b.default_category_id%TYPE;

3064: l_count NUMBER;
3065: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3066: l_description mtl_categories_vl.description%TYPE;
3067: l_category_id mtl_category_set_valid_cats.category_id%TYPE;
3068: l_def_category_id mtl_category_sets_b.default_category_id%TYPE;
3069: l_hrchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE;
3070:
3071: CURSOR c_get_cat_desc (cp_category_id IN NUMBER) IS
3072: SELECT description

Line 3069: l_hrchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE;

3065: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3066: l_description mtl_categories_vl.description%TYPE;
3067: l_category_id mtl_category_set_valid_cats.category_id%TYPE;
3068: l_def_category_id mtl_category_sets_b.default_category_id%TYPE;
3069: l_hrchy_enabled mtl_category_sets_b.hierarchy_enabled%TYPE;
3070:
3071: CURSOR c_get_cat_desc (cp_category_id IN NUMBER) IS
3072: SELECT description
3073: FROM mtl_categories_vl

Line 3107: FROM mtl_category_sets_b cat_sets

3103: --Added for bug 5219692
3104: CURSOR c_check_default_cat (cp_category_id IN NUMBER
3105: ,cp_category_set_id IN NUMBER) IS
3106: SELECT cat_sets.default_category_id
3107: FROM mtl_category_sets_b cat_sets
3108: WHERE cat_sets.category_set_id = p_category_set_id
3109: AND cat_sets.default_category_id = p_category_id
3110: AND NVL(cat_sets.validate_flag,'N') = 'Y';
3111:

Line 3115: FROM mtl_category_sets_b cat_sets

3111:
3112: CURSOR c_check_default_cat_hrchy (cp_category_id IN NUMBER
3113: ,cp_category_set_id IN NUMBER) IS
3114: SELECT cat_sets.default_category_id
3115: FROM mtl_category_sets_b cat_sets
3116: WHERE cat_sets.category_set_id = p_category_set_id
3117: AND EXISTS
3118: (SELECT 'X'
3119: FROM mtl_category_set_valid_cats check_cats