[Home] [Help]
1141: -- Do not include the serial numbers which are pending approval
1142: -- for the same cycle count header
1143: AND msn.serial_number NOT IN
1144: (SELECT mcce.serial_number
1145: FROM mtl_cycle_count_entries mcce
1146: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
1147: AND mcce.inventory_item_id = p_inventory_item_id
1148: AND mcce.organization_id = p_organization_id
1149: AND NVL(mcce.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
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
1185: , msn.lot_number
1186: , 0
1187: , msn.current_status
1188: , mms.status_code
1189: FROM mtl_serial_numbers msn, mtl_cycle_count_entries mcce, mtl_material_statuses_tl mms
1190: WHERE msn.inventory_item_id = p_inventory_item_id
1191: AND ((msn.current_organization_id = p_organization_id
1192: AND msn.current_status IN (3, 4)
1193: )
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
1245: )
1376: -- Do not include the serial numbers which are pending approval
1377: -- for the same cycle count header
1378: AND msn.serial_number NOT IN
1379: (SELECT mcce.serial_number
1380: FROM mtl_cycle_count_entries mcce
1381: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
1382: AND mcce.inventory_item_id = p_inventory_item_id
1383: AND mcce.organization_id = p_organization_id
1384: AND NVL(mcce.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
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
1420: , msn.lot_number
1421: , 0
1422: , msn.current_status
1423: , mms.status_code
1424: FROM mtl_serial_numbers msn, mtl_cycle_count_entries mcce, mtl_material_statuses_tl mms
1425: WHERE msn.inventory_item_id = p_inventory_item_id
1426: AND ((msn.current_organization_id = p_organization_id
1427: AND msn.current_status IN (3, 4)
1428: )
1473: , msn.lot_number
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
1591: AND wlpn.lpn_id(+) = msn.lpn_id
1592: -- Do not include the serial numbers which are pending approval
1593: -- for the same cycle count header
1594: AND msn.serial_number NOT IN (SELECT mcce.serial_number
1595: FROM mtl_cycle_count_entries mcce
1596: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
1597: AND mcce.organization_id = p_organization_id
1598: AND mcce.inventory_item_id = msn.inventory_item_id
1599: AND mcce.entry_status_code = 2
1627: , msn.lpn_id
1628: , wlpn.license_plate_number
1629: , msn.current_status
1630: , msik.primary_uom_code
1631: FROM mtl_serial_numbers msn, mtl_cycle_count_entries mcce,
1632: mtl_system_items_kfv msik, wms_license_plate_numbers wlpn
1633: WHERE (msn.group_mark_id IS NULL
1634: OR msn.group_mark_id = -1
1635: )