[Home] [Help]
1888: AND NVL(line_mark_id, -999) <> 1
1889: AND NVL(lot_number, '@@@') = NVL(NVL(p_lot_number, '@@@'), NVL(lot_number, '@@@'))
1890: AND NVL(revision, '@@@') = NVL(NVL(p_revision, '@@@'), NVL(revision, '@@@'))
1891: AND msn.serial_number LIKE p_serial
1892: 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'
1893: AND NOT EXISTS (select 1
1894: from mtl_reservations mr
1895: where mr.reservation_id = msn.reservation_id
1896: and mr.lpn_id = p_lpn_id)
1915: AND NVL(line_mark_id, -9) <> 1
1916: AND NVL(lot_number, '@') = NVL(NVL(p_lot_number, '@'), NVL(lot_number, '@'))
1917: AND NVL(revision, '@') = NVL(NVL(p_revision, '@'), NVL(revision, '@'))
1918: AND msn.serial_number LIKE (p_serial)
1919: 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')
1920: AND NOT EXISTS (select 1
1921: from mtl_reservations mr
1922: where mr.reservation_id = msn.reservation_id
1923: and mr.lpn_id = p_lpn_id)
1938: AND NVL(line_mark_id, -9) <> 1
1939: AND NVL(lot_number, '@') = NVL(NVL(p_lot_number, '@'), NVL(lot_number, '@'))
1940: AND NVL(revision, '@') = NVL(NVL(p_revision, '@'), NVL(revision, '@'))
1941: AND msn.serial_number LIKE (p_serial)
1942: 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')
1943: ORDER BY LPAD(msn.serial_number, 20);
1944: END IF;
1945: END get_split_cont_serial_lov;
1946:
2061: AND serial_number LIKE p_serial_number
2062: AND inv_material_status_grp.is_status_applicable
2063: (
2064: 'TRUE', NULL,
2065: inv_globals.g_type_container_pack,
2066: NULL, NULL,
2067: p_organization_id, inventory_item_id,
2068: NULL, NULL, NULL, serial_number, 'S') = 'Y'
2069: ORDER BY LPAD(serial_number, 20);
2133: AND serial_number LIKE (l_prefix || '%')
2134: AND lpn_id IS NULL
2135: AND serial_number >= NVL(p_from_serial_number, serial_number)
2136: AND serial_number LIKE (p_serial_number)
2137: 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')
2138: ORDER BY LPAD(serial_number, 20);
2139: END get_inv_serial_lov_bulk;
2140:
2141: -- Name: GET_CGUPDATE_SERIAL_LOV
3598: AND mms.language (+) = userenv('LANG')
3599: AND serial_number LIKE (p_serial_number)
3600: AND inv_material_status_grp.is_status_applicable('TRUE',
3601: NULL,
3602: INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
3603: NULL,
3604: NULL,
3605: p_organization_id,
3606: p_item_id,
3641: AND mms.language (+) = userenv('LANG')
3642: AND serial_number LIKE (p_serial_number)
3643: AND inv_material_status_grp.is_status_applicable('TRUE',
3644: NULL,
3645: INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
3646: NULL,
3647: NULL,
3648: p_organization_id,
3649: p_item_id,