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 983: FROM mtl_material_statuses_vl

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

Line 997: FROM mtl_material_statuses_vl

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

Line 1010: FROM mtl_material_statuses_vl

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