APPS.INV_STATUS_LOVS dependencies on MTL_MATERIAL_STATUSES_VL

Line 21: FROM mtl_material_statuses_vl

17: p_status_code IN VARCHAR2) IS
18: BEGIN
19: OPEN x_status FOR
20: SELECT status_code, status_id
21: FROM mtl_material_statuses_vl
22: WHERE zone_control = 1
23: and enabled_flag = 1
24: and status_code like (p_status_code)
25: order by status_code;

Line 34: FROM mtl_material_statuses_vl

30: p_status_code IN VARCHAR2) IS
31: BEGIN
32: OPEN x_status FOR
33: SELECT status_code, status_id
34: FROM mtl_material_statuses_vl
35: WHERE locator_control = 1
36: and enabled_flag = 1
37: and status_code like (p_status_code)
38: order by status_code;

Line 47: FROM mtl_material_statuses_vl

43: p_status_code IN VARCHAR2) IS
44: BEGIN
45: OPEN x_status FOR
46: SELECT status_code, status_id
47: FROM mtl_material_statuses_vl
48: WHERE lot_control = 1
49: and enabled_flag = 1
50: and status_code like (p_status_code)
51: order by status_code;

Line 60: FROM mtl_material_statuses_vl

56: p_status_code IN VARCHAR2) IS
57: BEGIN
58: OPEN x_status FOR
59: SELECT status_code, status_id
60: FROM mtl_material_statuses_vl
61: WHERE serial_control = 1
62: and enabled_flag = 1
63: and status_code like (p_status_code)
64: order by status_code;

Line 74: FROM mtl_material_statuses_vl

70: p_status_code IN VARCHAR2) IS
71: BEGIN
72: OPEN x_status FOR
73: SELECT status_code, status_id
74: FROM mtl_material_statuses_vl
75: WHERE onhand_control = 1
76: and enabled_flag = 1
77: and status_code like (p_status_code)
78: order by status_code;

Line 91: FROM mtl_material_statuses_vl mms, mtl_status_transaction_control mstc

87:
88: IF (p_trx_type_id IS NOT NULL) THEN
89: OPEN x_status FOR
90: SELECT mms.status_code, mms.status_id
91: FROM mtl_material_statuses_vl mms, mtl_status_transaction_control mstc
92: WHERE mms.status_id = mstc.status_id
93: and mms.lot_control = 1
94: and mms.enabled_flag = 1
95: and mms.status_code like (p_status_code)

Line 102: FROM mtl_material_statuses_vl

98: order by mms.status_code;
99: ELSE
100: OPEN x_status FOR
101: SELECT status_code, status_id
102: FROM mtl_material_statuses_vl
103: WHERE lot_control = 1
104: and enabled_flag = 1
105: and status_code like (p_status_code)
106: order by status_code;