APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_CC_SERIAL_NUMBERS

Line 1154: FROM mtl_cc_serial_numbers mcsn, mtl_cycle_count_entries mcce

1150: AND mcce.entry_status_code = 2
1151: AND NVL(mcce.export_flag, 2) = 2)
1152: AND msn.serial_number NOT IN
1153: (SELECT mcsn.serial_number
1154: FROM mtl_cc_serial_numbers mcsn, mtl_cycle_count_entries mcce
1155: WHERE mcsn.cycle_count_entry_id = mcce.cycle_count_entry_id
1156: AND mcce.cycle_count_header_id = p_cycle_count_header_id
1157: AND mcce.inventory_item_id = p_inventory_item_id
1158: AND mcce.organization_id = p_organization_id

Line 1240: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

1236: , msn.lot_number
1237: , 0
1238: , msn.current_status
1239: , mms.status_code
1240: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
1241: mtl_material_statuses_tl mms, mtl_cycle_count_entries mcce
1242: WHERE msn.inventory_item_id = p_inventory_item_id
1243: AND (msn.group_mark_id IS NULL
1244: OR msn.group_mark_id = -1

Line 1389: FROM mtl_cc_serial_numbers mcsn, mtl_cycle_count_entries mcce

1385: AND mcce.entry_status_code = 2
1386: AND NVL(mcce.export_flag, 2) = 2)
1387: AND msn.serial_number NOT IN
1388: (SELECT mcsn.serial_number
1389: FROM mtl_cc_serial_numbers mcsn, mtl_cycle_count_entries mcce
1390: WHERE mcsn.cycle_count_entry_id = mcce.cycle_count_entry_id
1391: AND mcce.cycle_count_header_id = p_cycle_count_header_id
1392: AND mcce.inventory_item_id = p_inventory_item_id
1393: AND mcce.organization_id = p_organization_id

Line 1478: mtl_material_statuses_tl mms, mtl_cc_serial_numbers mcsn

1474: , 0
1475: , msn.current_status
1476: , mms.status_code
1477: FROM mtl_serial_numbers msn, mtl_cycle_count_entries mcce,
1478: mtl_material_statuses_tl mms, mtl_cc_serial_numbers mcsn
1479: WHERE msn.inventory_item_id = p_inventory_item_id
1480: AND (msn.group_mark_id IS NULL
1481: OR msn.group_mark_id = -1
1482: )