APPS.GME_GANTT_LOV_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 30: ,mtl_system_items_vl itd

26: ,batch_status, itd.concatenated_segments
27: ,itd.description
28: FROM gme_batch_header b
29: ,gme_material_details d
30: ,mtl_system_items_vl itd
31: WHERE b.organization_id = p_organization_id
32: AND UPPER (batch_no) LIKE p_input_field
33: AND b.batch_id = d.batch_id
34: AND ( ( batch_type = p_batch_type

Line 66: ,mtl_system_items_vl itd

62: ,batch_status, itd.concatenated_segments
63: ,itd.description
64: FROM gme_batch_header b
65: ,gme_material_details d
66: ,mtl_system_items_vl itd
67: WHERE b.organization_id = p_organization_id
68: AND UPPER (batch_no) LIKE p_input_field
69: AND b.batch_id = d.batch_id
70: AND ( ( batch_type = p_batch_type

Line 197: FROM mtl_system_items_vl i

193:
194: /*CURSOR item_lov
195: IS
196: SELECT i.inventory_item_id, i.concatenated_segments, i.description
197: FROM mtl_system_items_vl i
198: WHERE i.concatenated_segments LIKE p_input_field
199: ORDER BY 2; */
200:
201: l_max_rows BINARY_INTEGER;

Line 211: ||' FROM mtl_system_items_vl i '

207: serial_control_flag BINARY_INTEGER := 1;
208: BEGIN
209: --FPBug#4911946 Begin
210: sqlstmt := 'SELECT i.inventory_item_id, i.concatenated_segments, i.description '
211: ||' FROM mtl_system_items_vl i '
212: ||' WHERE i.concatenated_segments LIKE :p_input_field '
213: ||' AND organization_id = :org_id '
214: ||' AND process_execution_enabled_flag = :flag '
215: ||' AND serial_number_control_code = :serial_flag ' --Bug#5350221