[Home] [Help]
1204: -- Do not include the serial numbers which are pending approval
1205: -- for the same cycle count header
1206: AND msn.serial_number NOT IN
1207: (SELECT mcce.serial_number
1208: FROM mtl_cycle_count_entries mcce
1209: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
1210: AND mcce.inventory_item_id = p_inventory_item_id
1211: AND mcce.organization_id = p_organization_id
1212: AND NVL(mcce.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
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
1248: , msn.lot_number
1249: , 0
1250: , msn.current_status
1251: , mms.status_code
1252: FROM mtl_serial_numbers msn, mtl_cycle_count_entries mcce, mtl_material_statuses_tl mms
1253: WHERE msn.inventory_item_id = p_inventory_item_id
1254: AND ((msn.current_organization_id = p_organization_id
1255: AND msn.current_status IN (3, 4)
1256: )
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
1308: )
1439: -- Do not include the serial numbers which are pending approval
1440: -- for the same cycle count header
1441: AND msn.serial_number NOT IN
1442: (SELECT mcce.serial_number
1443: FROM mtl_cycle_count_entries mcce
1444: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
1445: AND mcce.inventory_item_id = p_inventory_item_id
1446: AND mcce.organization_id = p_organization_id
1447: AND NVL(mcce.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
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
1483: , msn.lot_number
1484: , 0
1485: , msn.current_status
1486: , mms.status_code
1487: FROM mtl_serial_numbers msn, mtl_cycle_count_entries mcce, mtl_material_statuses_tl mms
1488: WHERE msn.inventory_item_id = p_inventory_item_id
1489: AND ((msn.current_organization_id = p_organization_id
1490: AND msn.current_status IN (3, 4)
1491: )
1536: , msn.lot_number
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
1654: AND wlpn.lpn_id(+) = msn.lpn_id
1655: -- Do not include the serial numbers which are pending approval
1656: -- for the same cycle count header
1657: AND msn.serial_number NOT IN (SELECT mcce.serial_number
1658: FROM mtl_cycle_count_entries mcce
1659: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
1660: AND mcce.organization_id = p_organization_id
1661: AND mcce.inventory_item_id = msn.inventory_item_id
1662: AND mcce.entry_status_code = 2
1690: , msn.lpn_id
1691: , wlpn.license_plate_number
1692: , msn.current_status
1693: , msik.primary_uom_code
1694: FROM mtl_serial_numbers msn, mtl_cycle_count_entries mcce,
1695: mtl_system_items_kfv msik, wms_license_plate_numbers wlpn
1696: WHERE (msn.group_mark_id IS NULL
1697: OR msn.group_mark_id = -1
1698: )