[Home] [Help]
1959: -- bug 14278675
1960: AND NVL(lot_number, '@@@') = NVL(NVL(p_lot_number, '@@@'), NVL(lot_number, '@@@'))
1961: AND NVL(revision, '@@@') = NVL(NVL(p_revision, '@@@'), NVL(revision, '@@@'))
1962: AND msn.serial_number LIKE p_serial
1963: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, inv_globals.g_type_container_unpack, NULL, NULL, p_organization_id, msn.inventory_item_id, NULL, NULL, NULL, msn.serial_number, 'S') = 'Y'
1964: AND NOT EXISTS (select 1
1965: from mtl_reservations mr
1966: where mr.reservation_id = msn.reservation_id
1967: and mr.lpn_id = p_lpn_id)
1994: -- bug 14278675
1995: AND NVL(lot_number, '@') = NVL(NVL(p_lot_number, '@'), NVL(lot_number, '@'))
1996: AND NVL(revision, '@') = NVL(NVL(p_revision, '@'), NVL(revision, '@'))
1997: AND msn.serial_number LIKE (p_serial)
1998: AND (inv_material_status_grp.is_status_applicable('TRUE', NULL, inv_globals.g_type_container_split, NULL, NULL, p_organization_id, msn.inventory_item_id, NULL, NULL, NULL, msn.serial_number, 'S') = 'Y')
1999: AND NOT EXISTS (select 1
2000: from mtl_reservations mr
2001: where mr.reservation_id = msn.reservation_id
2002: and mr.lpn_id = p_lpn_id)
2017: AND NVL(line_mark_id, -9) <> 1
2018: AND NVL(lot_number, '@') = NVL(NVL(p_lot_number, '@'), NVL(lot_number, '@'))
2019: AND NVL(revision, '@') = NVL(NVL(p_revision, '@'), NVL(revision, '@'))
2020: AND msn.serial_number LIKE (p_serial)
2021: AND (inv_material_status_grp.is_status_applicable('TRUE', NULL, inv_globals.g_type_container_split, NULL, NULL, p_organization_id, msn.inventory_item_id, NULL, NULL, NULL, msn.serial_number, 'S') = 'Y')
2022: ORDER BY LPAD(msn.serial_number, 20);
2023: END IF;
2024: END get_split_cont_serial_lov;
2025:
2140: AND serial_number LIKE p_serial_number
2141: AND inv_material_status_grp.is_status_applicable
2142: (
2143: 'TRUE', NULL,
2144: inv_globals.g_type_container_pack,
2145: NULL, NULL,
2146: p_organization_id, inventory_item_id,
2147: NULL, NULL, NULL, serial_number, 'S') = 'Y'
2148: AND NOT EXISTS (SELECT 1
2220: AND serial_number LIKE (l_prefix || '%')
2221: AND lpn_id IS NULL
2222: AND serial_number >= NVL(p_from_serial_number, serial_number)
2223: AND serial_number LIKE (p_serial_number)
2224: AND (inv_material_status_grp.is_status_applicable('TRUE', NULL, inv_globals.g_type_container_pack, NULL, NULL, p_organization_id, inventory_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y')
2225: ORDER BY LPAD(serial_number, 20);
2226: END get_inv_serial_lov_bulk;
2227:
2228: -- Name: GET_CGUPDATE_SERIAL_LOV
3687: AND mms.language (+) = userenv('LANG')
3688: AND serial_number LIKE (p_serial_number)
3689: AND inv_material_status_grp.is_status_applicable('TRUE',
3690: NULL,
3691: INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
3692: NULL,
3693: NULL,
3694: p_organization_id,
3695: p_item_id,
3730: AND mms.language (+) = userenv('LANG')
3731: AND serial_number LIKE (p_serial_number)
3732: AND inv_material_status_grp.is_status_applicable('TRUE',
3733: NULL,
3734: INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
3735: NULL,
3736: NULL,
3737: p_organization_id,
3738: p_item_id,