APPS.INVIDIT1 dependencies on MTL_MATERIAL_STATUSES_VL

Line 250: FROM mtl_material_statuses_vl

246: IF ( c_default_lot_status_id is not null ) THEN
247: BEGIN
248: SELECT status_code
249: INTO x_default_lot_status
250: FROM mtl_material_statuses_vl
251: WHERE status_id = c_default_lot_status_id
252: AND lot_control = 1;
253:
254: x_default_lot_status_id := c_default_lot_status_id;

Line 266: FROM mtl_material_statuses_vl

262: IF ( c_default_serial_status_id is not null ) THEN
263: BEGIN
264: SELECT status_code
265: INTO x_default_serial_status
266: FROM mtl_material_statuses_vl
267: WHERE status_id = c_default_serial_status_id
268: AND serial_control = 1;
269:
270: x_default_serial_status_id := c_default_serial_status_id;

Line 981: FROM mtl_material_statuses_vl

977: IF ( p_default_lot_status_id is not null ) THEN
978: BEGIN
979: SELECT status_code
980: INTO x_default_lot_status
981: FROM mtl_material_statuses_vl
982: WHERE status_id = p_default_lot_status_id
983: AND lot_control = 1;
984: EXCEPTION
985: WHEN no_data_found THEN

Line 995: FROM mtl_material_statuses_vl

991: IF ( p_default_material_status_id is not null ) THEN
992: BEGIN
993: SELECT status_code
994: INTO x_default_material_status
995: FROM mtl_material_statuses_vl
996: WHERE status_id = p_default_material_status_id
997: AND onhand_control = 1;
998: EXCEPTION
999: WHEN no_data_found THEN

Line 1008: FROM mtl_material_statuses_vl

1004: IF ( p_default_serial_status_id is not null ) THEN
1005: BEGIN
1006: SELECT status_code
1007: INTO x_default_serial_status
1008: FROM mtl_material_statuses_vl
1009: WHERE status_id = p_default_serial_status_id
1010: AND serial_control = 1;
1011: EXCEPTION
1012: WHEN no_data_found THEN