APPS.INV_CYC_SERIALS dependencies on MTL_MATERIAL_STATUSES_VL

Line 41: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

37: 0,
38: msn.current_status,
39: mms.status_code
40: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
41: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
42: WHERE msn.inventory_item_id = p_inventory_item_id
43: AND msn.current_organization_id = p_organization_id
44: AND msn.current_status IN (1, 3)
45: AND msn.status_id = mms.status_id(+)

Line 98: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

94: 0,
95: msn.current_status,
96: mms.status_code
97: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
98: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
99: WHERE msn.inventory_item_id = p_inventory_item_id
100: AND msn.group_mark_id = 1
101: AND msn.current_organization_id = p_organization_id
102: AND msn.current_status IN (1, 3)

Line 154: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

150: AND current_organization_id = p_organization_id
151: AND serial_number IN
152: (SELECT UNIQUE msn.serial_number
153: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
154: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
155: WHERE msn.inventory_item_id = p_inventory_item_id
156: AND msn.current_organization_id = p_organization_id
157: AND msn.current_status IN (1, 3)
158: AND msn.status_id = mms.status_id(+)

Line 220: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

216: AND current_organization_id = p_organization_id
217: AND serial_number IN
218: (SELECT UNIQUE msn.serial_number
219: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
220: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
221: WHERE msn.inventory_item_id = p_inventory_item_id
222: AND msn.current_organization_id = p_organization_id
223: AND msn.current_status IN (1, 3, 4) -- For bug 14144558, added 4 in the list and commented below check
224: --OR (msn.last_txn_source_type_id in (9,10) AND msn.current_status = 4)) --Bug# 3595723 Bug11875440

Line 307: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

303: AND current_organization_id = p_organization_id
304: AND serial_number IN
305: (SELECT UNIQUE msn.serial_number
306: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
307: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
308: WHERE msn.inventory_item_id = p_inventory_item_id
309: AND msn.current_organization_id = p_organization_id
310: AND msn.current_status IN (1, 3, 4) -- For bug 14144558, added 4 in the list
311: AND msn.status_id = mms.status_id(+)

Line 379: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

375: AND current_organization_id = p_organization_id
376: AND serial_number IN
377: (SELECT UNIQUE msn.serial_number
378: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
379: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
380: WHERE msn.inventory_item_id = p_inventory_item_id
381: AND msn.current_organization_id = p_organization_id
382: AND msn.current_status IN (1, 3)
383: AND msn.status_id = mms.status_id(+)

Line 443: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

439: AND current_organization_id = p_organization_id
440: AND serial_number IN
441: (SELECT UNIQUE msn.serial_number
442: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
443: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
444: WHERE msn.inventory_item_id = p_inventory_item_id
445: AND msn.current_organization_id = p_organization_id
446: AND msn.current_status IN (1, 3)
447: AND msn.status_id = mms.status_id(+)

Line 498: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce

494: BEGIN
495: SELECT COUNT(*)
496: INTO x_number
497: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
498: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
499: WHERE msn.inventory_item_id = p_inventory_item_id
500: AND msn.group_mark_id = 1
501: AND msn.current_organization_id = p_organization_id
502: AND msn.current_status IN (1, 3)