APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_CC_SERIAL_NUMBERS

Line 1217: FROM mtl_cc_serial_numbers mcsn, mtl_cycle_count_entries mcce

1213: AND mcce.entry_status_code = 2
1214: AND NVL(mcce.export_flag, 2) = 2)
1215: AND msn.serial_number NOT IN
1216: (SELECT mcsn.serial_number
1217: FROM mtl_cc_serial_numbers mcsn, mtl_cycle_count_entries mcce
1218: WHERE mcsn.cycle_count_entry_id = mcce.cycle_count_entry_id
1219: AND mcce.cycle_count_header_id = p_cycle_count_header_id
1220: AND mcce.inventory_item_id = p_inventory_item_id
1221: AND mcce.organization_id = p_organization_id

Line 1303: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

1299: , msn.lot_number
1300: , 0
1301: , msn.current_status
1302: , mms.status_code
1303: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
1304: mtl_material_statuses_tl mms, mtl_cycle_count_entries mcce
1305: WHERE msn.inventory_item_id = p_inventory_item_id
1306: AND (msn.group_mark_id IS NULL
1307: OR msn.group_mark_id = -1

Line 1452: FROM mtl_cc_serial_numbers mcsn, mtl_cycle_count_entries mcce

1448: AND mcce.entry_status_code = 2
1449: AND NVL(mcce.export_flag, 2) = 2)
1450: AND msn.serial_number NOT IN
1451: (SELECT mcsn.serial_number
1452: FROM mtl_cc_serial_numbers mcsn, mtl_cycle_count_entries mcce
1453: WHERE mcsn.cycle_count_entry_id = mcce.cycle_count_entry_id
1454: AND mcce.cycle_count_header_id = p_cycle_count_header_id
1455: AND mcce.inventory_item_id = p_inventory_item_id
1456: AND mcce.organization_id = p_organization_id

Line 1541: mtl_material_statuses_tl mms, mtl_cc_serial_numbers mcsn

1537: , 0
1538: , msn.current_status
1539: , mms.status_code
1540: FROM mtl_serial_numbers msn, mtl_cycle_count_entries mcce,
1541: mtl_material_statuses_tl mms, mtl_cc_serial_numbers mcsn
1542: WHERE msn.inventory_item_id = p_inventory_item_id
1543: AND (msn.group_mark_id IS NULL
1544: OR msn.group_mark_id = -1
1545: )