APPS.INV_OBJECT_GENEALOGY dependencies on MTL_MATERIAL_STATUSES_VL

Line 129: FROM mtl_material_statuses_vl

125:
126: BEGIN
127: SELECT status_code
128: INTO p_material_status
129: FROM mtl_material_statuses_vl
130: WHERE status_id = l_status_id;
131:
132: IF (l_debug = 1) THEN
133: inv_trx_util_pub.TRACE('object type is 1 and status code is ' || p_material_status, 'INV_OBJECT_GENEALOGY', 9);

Line 176: FROM mtl_material_statuses_vl

172: IF l_status_id IS NOT NULL THEN
173: BEGIN
174: SELECT status_code
175: INTO p_material_status
176: FROM mtl_material_statuses_vl
177: WHERE status_id = l_status_id;
178:
179: IF (l_debug = 1) THEN
180: inv_trx_util_pub.TRACE(

Line 181: 'object type is 2 and status code from mtl_material_statuses_vl for status_id ' || l_status_id || ' : ' || p_material_status

177: WHERE status_id = l_status_id;
178:
179: IF (l_debug = 1) THEN
180: inv_trx_util_pub.TRACE(
181: 'object type is 2 and status code from mtl_material_statuses_vl for status_id ' || l_status_id || ' : ' || p_material_status
182: , 'INV_OBJECT_GENEALOGY'
183: , 9
184: );
185: END IF;

Line 302: FROM mtl_material_statuses_vl

298:
299: BEGIN
300: SELECT status_code
301: INTO p_material_status
302: FROM mtl_material_statuses_vl
303: WHERE status_id = l_status_id;
304:
305: IF (l_debug = 1) THEN
306: inv_trx_util_pub.TRACE('object type is 1 and status code is ' || p_material_status, 'INV_OBJECT_GENEALOGY', 9);

Line 369: FROM mtl_material_statuses_vl

365: IF l_status_id IS NOT NULL THEN
366: BEGIN
367: SELECT status_code
368: INTO p_material_status
369: FROM mtl_material_statuses_vl
370: WHERE status_id = l_status_id;
371:
372: IF (l_debug = 1) THEN
373: inv_trx_util_pub.TRACE(

Line 374: 'object type is 2 and status code from mtl_material_statuses_vl for status_id ' || l_status_id || ' : ' || p_material_status

370: WHERE status_id = l_status_id;
371:
372: IF (l_debug = 1) THEN
373: inv_trx_util_pub.TRACE(
374: 'object type is 2 and status code from mtl_material_statuses_vl for status_id ' || l_status_id || ' : ' || p_material_status
375: , 'INV_OBJECT_GENEALOGY'
376: , 9
377: );
378: END IF;