APPS.INV_RSV_DETAIL_STAGE_PVT dependencies on MTL_MATERIAL_STATUSES_B

Line 149: -- check for the status id and get the reservable_type from mtl_material_statuses_b

145:
146: ELSE -- IF l_default_org_status_id IS NULL THEN
147:
148: -- Org is onhand material status enabled
149: -- check for the status id and get the reservable_type from mtl_material_statuses_b
150: IF (l_debug = 1) THEN
151: debug_print('Organization is onhand material status enabled');
152: debug_print('Before getting the onhand status');
153: END IF;

Line 179: FROM mtl_material_statuses_b

175: ELSE
176: BEGIN
177: SELECT reservable_type
178: INTO l_res_type
179: FROM mtl_material_statuses_b
180: WHERE status_id = l_return_status_id;
181: EXCEPTION
182: WHEN OTHERS THEN
183: IF (l_debug = 1) THEN

Line 184: debug_print('Exception occurred while querying mtl_material_statuses_b :' || l_return_status_id);

180: WHERE status_id = l_return_status_id;
181: EXCEPTION
182: WHEN OTHERS THEN
183: IF (l_debug = 1) THEN
184: debug_print('Exception occurred while querying mtl_material_statuses_b :' || l_return_status_id);
185: END IF;
186: l_res_type := 1 ; -- reservable type is set to YES in case of exception
187: END;
188: END IF;