eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_UI_ITEM_ATT_LOVS dependencies on INV_MATERIAL_STATUS_GRP

Line 30: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'

26: )
27: AND msn.status_id = mms.status_id(+)
28: AND mms.language (+) = userenv('LANG')
29: AND serial_number LIKE (p_serial)
30: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'
31: ORDER BY LPAD(serial_number, 20);
32: END get_serial_lov_rcv;
33:
34: -- This is equivalent to inv_serial3 in the serial entry form INVTTESR

Line 115: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'

111: )
112: AND current_status = 4
113: AND msn.status_id = mms.status_id(+)
114: AND mms.language (+) = userenv('LANG')
115: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'
116: AND msn.serial_number LIKE (p_serial)
117: AND EXISTS ( select 'x' from mtl_rma_serial_temp msrt
118: where msrt.organization_id = p_organization_id
119: and msrt.inventory_item_id = p_item_id

Line 143: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'

139: )
140: AND current_status = 4
141: AND msn.status_id = mms.status_id(+)
142: AND mms.language (+) = userenv('LANG')
143: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'
144: AND serial_number LIKE (p_serial)
145: ORDER BY LPAD(serial_number, 20);
146: End if;
147: END get_serial_lov_rma_rcv;

Line 242: AND inv_material_status_grp.is_status_applicable(

238: (Nvl(rss.lot_num,'@@@') = Nvl(p_lot_num,'@@@')))
239: )
240: AND msn.status_id = mms.status_id(+)
241: AND mms.language (+) = userenv('LANG')
242: AND inv_material_status_grp.is_status_applicable(
243: p_wms_installed
244: , p_transaction_type_id
245: , NULL
246: , NULL

Line 287: AND inv_material_status_grp.is_status_applicable(

283: AND rsl.to_organization_id = p_organization_id
284: AND rsl.item_id = p_item_id
285: AND msn.status_id = mms.status_id(+)
286: AND mms.language (+) = userenv('LANG')
287: AND inv_material_status_grp.is_status_applicable(
288: p_wms_installed
289: , p_transaction_type_id
290: , NULL
291: , NULL

Line 360: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, p_subinv_code, msn.current_locator_id, msn.lot_number, msn.serial_number, 'S') = 'Y'

356: AND NVL(current_locator_id, 0) = NVL(DECODE(p_locator_id, -1, current_locator_id, p_locator_id), 0)
357: AND msn.status_id = mms.status_id(+)
358: AND mms.language (+) = userenv('LANG')
359: AND serial_number LIKE (p_serial)
360: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, p_subinv_code, msn.current_locator_id, msn.lot_number, msn.serial_number, 'S') = 'Y'
361: ORDER BY LPAD(serial_number, 20);
362: END;
363:
364: PROCEDURE get_lot_info(

Line 607: AND inv_material_status_grp.is_status_applicable(

603: OR owning_organization_id = p_owning_org_id)
604: AND (p_owning_tp_type IS NULL
605: OR owning_tp_type = p_owning_tp_type)
606: AND a.serial_number LIKE (p_serial_number)
607: AND inv_material_status_grp.is_status_applicable(
608: p_wms_installed
609: , NULL
610: , p_transaction_type_id
611: , NULL

Line 662: AND inv_material_status_grp.is_status_applicable(

658: OR owning_organization_id = p_owning_org_id)
659: AND (p_owning_tp_type IS NULL
660: OR owning_tp_type = p_owning_tp_type)
661: AND a.serial_number LIKE (p_serial_number)
662: AND inv_material_status_grp.is_status_applicable(
663: p_wms_installed
664: , NULL
665: , p_transaction_type_id
666: , NULL

Line 859: AND inv_material_status_grp.is_status_applicable

855: AND msn.status_id = mms.status_id(+)
856: AND mms.LANGUAGE(+) = USERENV ('LANG')
857: AND serial_number > p_from_serial_number
858: -- Bug# 2770853. Honor the serial material status for physical inventory adjustments.
859: AND inv_material_status_grp.is_status_applicable
860: (NULL,
861: NULL,
862: 8,
863: NULL,

Line 890: AND inv_material_status_grp.is_status_applicable

886: AND msn.status_id = mms.status_id(+)
887: AND mms.LANGUAGE(+) = USERENV ('LANG')
888: AND serial_number > p_from_serial_number
889: -- Bug# 2770853. Honor the serial material status for physical inventory adjustments.
890: AND inv_material_status_grp.is_status_applicable
891: (NULL,
892: NULL,
893: 8,
894: NULL,

Line 945: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

941: AND organization_id = p_organization_id
942: AND approval_status IS NULL)
943: -- Bug# 2770853
944: -- Honor the serial material status for physical inventory adjustments
945: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
946: NULL,
947: 8,
948: NULL,
949: 'Y',

Line 999: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

995: AND msn.current_organization_id = msik.organization_id
996: AND wlpn.lpn_id(+) = msn.lpn_id
997: -- Bug# 2770853
998: -- Honor the serial material status for physical inventory adjustments
999: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1000: NULL,
1001: 8,
1002: NULL,
1003: 'Y',

Line 1052: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1048: AND msn.current_organization_id = msik.organization_id
1049: AND wlpn.lpn_id(+) = msn.lpn_id
1050: -- Bug# 2770853
1051: -- Honor the serial material status for physical inventory adjustments
1052: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1053: NULL,
1054: 8,
1055: NULL,
1056: 'Y',

Line 1164: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1160: AND mcce.entry_status_code = 2
1161: AND NVL(mcce.export_flag, 2) = 2)
1162: -- Bug# 2770853
1163: -- Honor the serial material status for cycle count adjustments
1164: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1165: NULL,
1166: 4,
1167: NULL,
1168: 'Y',

Line 1217: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1213: AND mcce.entry_status_code IN (1, 3)
1214: AND NVL(mcce.export_flag, 2) = 2
1215: -- Bug# 2770853
1216: -- Honor the serial material status for cycle count adjustments
1217: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1218: NULL,
1219: 4,
1220: NULL,
1221: 'Y',

Line 1273: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1269: AND mcce.entry_status_code IN (1, 3)
1270: AND NVL(mcce.export_flag, 2) = 2
1271: -- Bug# 2770853
1272: -- Honor the serial material status for cycle count adjustments
1273: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1274: NULL,
1275: 4,
1276: NULL,
1277: 'Y',

Line 1399: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1395: AND mcce.entry_status_code = 2
1396: AND NVL(mcce.export_flag, 2) = 2)
1397: -- Bug# 2770853
1398: -- Honor the serial material status for cycle count adjustments
1399: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1400: NULL,
1401: 4,
1402: NULL,
1403: 'Y',

Line 1454: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1450: AND mcce.entry_status_code IN (1, 3)
1451: AND NVL(mcce.export_flag, 2) = 2
1452: -- Bug# 2770853
1453: -- Honor the serial material status for cycle count adjustments
1454: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1455: NULL,
1456: 4,
1457: NULL,
1458: 'Y',

Line 1512: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1508: AND mcce.entry_status_code IN (1, 3)
1509: AND NVL(mcce.export_flag, 2) = 2
1510: -- Bug# 2770853
1511: -- Honor the serial material status for cycle count adjustments
1512: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1513: NULL,
1514: 4,
1515: NULL,
1516: 'Y',

Line 1603: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1599: AND mcce.entry_status_code = 2
1600: AND NVL(mcce.export_flag, 2) = 2)
1601: -- Bug# 2770853
1602: -- Honor the serial material status for cycle count adjustments
1603: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1604: NULL,
1605: 4,
1606: NULL,
1607: 'Y',

Line 1655: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1651: AND msn.current_organization_id = msik.organization_id
1652: AND wlpn.lpn_id(+) = msn.lpn_id
1653: -- Bug# 2770853
1654: -- Honor the serial material status for cycle count adjustments
1655: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1656: NULL,
1657: 4,
1658: NULL,
1659: 'Y',

Line 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'

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)

Line 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')

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)

Line 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')

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:

Line 1975: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, NULL, NULL, p_organization_id, NULL, NULL, NULL, NULL, p_serial, 'S') = 'Y'

1971: AND NVL(lot_number, '@@@') = NVL(NVL(p_lot_number, '@@@'), NVL(lot_number, '@@@'))
1972: AND NVL(revision, '@@@') = NVL(NVL(p_revision, '@@@'), NVL(revision, '@@@'))
1973: AND msn.serial_number LIKE (p_serial)
1974: AND current_status = 3
1975: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, NULL, NULL, p_organization_id, NULL, NULL, NULL, NULL, p_serial, 'S') = 'Y'
1976: ORDER BY LPAD(msn.serial_number, 20);
1977: END get_pupcont_serial_lov;
1978:
1979: -- Name: GET_INV_SERIAL_LOV

Line 2062: AND inv_material_status_grp.is_status_applicable

2058: AND NVL(revision, '@@@') = NVL(NVL(p_revision, '@@@'), NVL(revision, '@@@'))
2059: AND current_status = 3
2060: AND lpn_id IS NULL
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,

Line 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')

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

Line 2189: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, 86, NULL, NULL, p_organization_id, p_inventory_item_id, msn.current_subinventory_code, msn.current_locator_id, msn.lot_number, msn.serial_number, 'A') = 'Y'

2185: AND mms.language (+) = userenv('LANG')
2186: AND ccg.cost_group_id = msn.cost_group_id
2187: AND msn.current_locator_id = mil.inventory_location_id
2188: AND mil.organization_id = p_organization_id
2189: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, 86, NULL, NULL, p_organization_id, p_inventory_item_id, msn.current_subinventory_code, msn.current_locator_id, msn.lot_number, msn.serial_number, 'A') = 'Y'
2190: AND msn.current_status = 3
2191: AND (msn.group_mark_id IS NULL
2192: OR (msn.group_mark_id <> 1)
2193: )

Line 2227: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, 86, NULL, NULL, p_organization_id, p_inventory_item_id, msn.current_subinventory_code, msn.current_locator_id, msn.lot_number, msn.serial_number, 'A') = 'Y'

2223: AND mms.language (+) = userenv('LANG')
2224: AND ccg.cost_group_id = msn.cost_group_id
2225: AND msn.current_locator_id = mil.inventory_location_id
2226: AND mil.organization_id = p_organization_id
2227: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, 86, NULL, NULL, p_organization_id, p_inventory_item_id, msn.current_subinventory_code, msn.current_locator_id, msn.lot_number, msn.serial_number, 'A') = 'Y'
2228: AND msn.current_status = 3
2229: AND (msn.group_mark_id IS NULL
2230: OR (msn.group_mark_id <> 1)
2231: )

Line 2338: AND inv_material_status_grp.is_status_applicable(l_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, p_subinv_code, msn.current_locator_id, msn.lot_number, msn.serial_number, 'S') = 'Y'

2334: AND msn.status_id = mms.status_id(+)
2335: AND mms.language (+) = userenv('LANG')
2336: AND serial_number LIKE (p_serial)
2337: AND NVL(msn.lot_number, 0) = NVL(p_lot_number, 0) --retrict to lot numbers
2338: AND inv_material_status_grp.is_status_applicable(l_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, p_subinv_code, msn.current_locator_id, msn.lot_number, msn.serial_number, 'S') = 'Y'
2339: ORDER BY LPAD(serial_number, 20);
2340: END get_serial_lov_picking;
2341:
2342: -- Name: GET_SERIAL_LOV_ALLOC_PICKING

Line 2399: AND inv_material_status_grp.is_status_applicable(l_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, p_subinv_code, msn.current_locator_id, msn.lot_number, msnt.fm_serial_number, 'S') = 'Y'

2395: AND NVL(msn.lpn_id, 0) = NVL(p_lpn_id, 0)
2396: AND NVL(msn.current_locator_id, 0) = NVL(DECODE(p_locator_id, -1, msn.current_locator_id, p_locator_id), 0)
2397: AND msn.status_id = mms.status_id(+)
2398: AND mms.language (+) = userenv('LANG')
2399: AND inv_material_status_grp.is_status_applicable(l_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, p_subinv_code, msn.current_locator_id, msn.lot_number, msnt.fm_serial_number, 'S') = 'Y'
2400: AND msn.serial_number = msnt.fm_serial_number
2401: AND msnt.fm_serial_number LIKE (p_serial)
2402: AND msnt.transaction_temp_id = p_transaction_temp_id
2403: ORDER BY LPAD(msnt.fm_serial_number, 20);

Line 2423: AND inv_material_status_grp.is_status_applicable(l_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, p_subinv_code, msn.current_locator_id, msn.lot_number, msnt.fm_serial_number, 'S') = 'Y'

2419: AND NVL(msn.lpn_id, 0) = NVL(p_lpn_id, 0)
2420: AND NVL(msn.current_locator_id, 0) = NVL(DECODE(p_locator_id, -1, msn.current_locator_id, p_locator_id), 0)
2421: AND msn.status_id = mms.status_id(+)
2422: AND mms.language (+) = userenv('LANG')
2423: AND inv_material_status_grp.is_status_applicable(l_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, p_subinv_code, msn.current_locator_id, msn.lot_number, msnt.fm_serial_number, 'S') = 'Y'
2424: AND msn.serial_number = msnt.fm_serial_number
2425: AND msnt.fm_serial_number LIKE (p_serial)
2426: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
2427: AND mtlt.lot_number = p_lot_number

Line 2473: AND inv_material_status_grp.is_status_applicable(l_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, p_subinv_code, msn.current_locator_id, msn.lot_number, msn.serial_number, 'S') = 'Y'

2469: AND (p_revision IS NULL
2470: OR (msn.revision = p_revision)
2471: )
2472: AND NVL(msn.lot_number, 0) = NVL(p_lot_number, 0) --retrict to lot numbers
2473: AND inv_material_status_grp.is_status_applicable(l_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, p_subinv_code, msn.current_locator_id, msn.lot_number, msn.serial_number, 'S') = 'Y'
2474: ORDER BY LPAD(serial_number, 20);
2475: END get_serial_lov_apl_picking;
2476:
2477:

Line 2520: AND inv_material_status_grp.is_status_applicable(l_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, p_subinv_code, msn.current_locator_id, msn.lot_number, mag.serial_number, 'S') = 'Y'

2516: --AND NVL(msn.lpn_id, 0) = NVL(p_lpn_id, 0)
2517: AND NVL(msn.current_locator_id, 0) = NVL(DECODE(p_locator_id, -1, msn.current_locator_id, p_locator_id), 0)
2518: AND msn.status_id = mms.status_id(+)
2519: AND mms.language (+) = userenv('LANG')
2520: AND inv_material_status_grp.is_status_applicable(l_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, p_subinv_code, msn.current_locator_id, msn.lot_number, mag.serial_number, 'S') = 'Y'
2521: AND msn.serial_number = mag.serial_number
2522: AND mag.serial_number LIKE (p_serial)
2523: AND (p_revision IS NULL
2524: OR (msn.revision = p_revision)

Line 2546: AND inv_material_status_grp.is_status_applicable(l_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, p_subinv_code, msn.current_locator_id, msn.lot_number, mag.serial_number, 'S') = 'Y'

2542: --AND NVL(msn.lpn_id, 0) = NVL(p_lpn_id, 0)
2543: AND NVL(msn.current_locator_id, 0) = NVL(DECODE(p_locator_id, -1, msn.current_locator_id, p_locator_id), 0)
2544: AND msn.status_id = mms.status_id(+)
2545: AND mms.language (+) = userenv('LANG')
2546: AND inv_material_status_grp.is_status_applicable(l_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, p_subinv_code, msn.current_locator_id, msn.lot_number, mag.serial_number, 'S') = 'Y'
2547: AND msn.serial_number = mag.serial_number
2548: AND mag.serial_number LIKE (p_serial)
2549: AND mag.lot_number = p_lot_number
2550: AND (p_revision IS NULL

Line 2801: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, msn.current_subinventory_code, msn.current_locator_id, msn.lot_number, msn.serial_number, 'A') = 'Y'

2797: AND msn.lpn_id IS NULL
2798: AND msn.status_id = mms.status_id(+)
2799: AND mms.language (+) = userenv('LANG')
2800: AND serial_number LIKE (p_serial)
2801: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, msn.current_subinventory_code, msn.current_locator_id, msn.lot_number, msn.serial_number, 'A') = 'Y'
2802: ORDER BY LPAD(serial_number, 20);
2803: END get_serial_lov_mo;
2804:
2805: -- Name: GET_SERIAL_LOV_WMA_NEGISS

Line 2850: AND (inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, current_organization_id, inventory_item_id, current_subinventory_code, current_locator_id, lot_number, serial_number, 'S')) = 'Y'

2846: AND last_txn_source_type_id = 5 -- returned to WIP
2847: AND (NVL(lot_number, '%') LIKE l_lot_number)))
2848: AND serial_number LIKE (p_serial)
2849: AND (group_mark_id IS NULL OR group_mark_id = -1)
2850: AND (inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, current_organization_id, inventory_item_id, current_subinventory_code, current_locator_id, lot_number, serial_number, 'S')) = 'Y'
2851: ORDER BY LPAD(serial_number, 20);
2852: END get_serial_lov_wma_negiss;
2853:
2854: -- Name: GET_SERIAL_LOV_WMA_ISS

Line 2908: AND (inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, current_organization_id, inventory_item_id, current_subinventory_code, current_locator_id, lot_number, serial_number, 'S')) =

2904: AND serial_number LIKE (p_serial)
2905: AND (group_mark_id IS NULL
2906: OR group_mark_id = -1
2907: )
2908: AND (inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, current_organization_id, inventory_item_id, current_subinventory_code, current_locator_id, lot_number, serial_number, 'S')) =
2909: 'Y'
2910: ORDER BY LPAD(serial_number, 20);
2911: END get_serial_lov_wma_iss;
2912:

Line 2984: AND (inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, current_organization_id, inventory_item_id, current_subinventory_code, current_locator_id, lot_number, serial_number, 'S')) = 'Y'

2980: AND serial_number LIKE (p_serial)
2981: AND (group_mark_id IS NULL
2982: OR group_mark_id = -1
2983: )
2984: AND (inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, current_organization_id, inventory_item_id, current_subinventory_code, current_locator_id, lot_number, serial_number, 'S')) = 'Y'
2985: ORDER BY LPAD(serial_number, 20);
2986: END get_serial_lov_wma_rcv;
2987:
2988: -- Name: GET_SERIAL_LOV_WMA_RETCOMP

Line 3032: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'

3028: AND last_txn_source_type_id = 5 -- issued to WIP
3029: AND msn.status_id = mms.status_id(+)
3030: AND mms.language (+) = userenv('LANG')
3031: AND NVL(lot_number, '$@#$%') = NVL(p_lot, NVL(lot_number, '$@#$%'))
3032: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'
3033: AND (((p_wip_entity_id <> -1)
3034: AND (p_wip_entity_id = last_txn_source_id)
3035: )
3036: OR ((p_wip_entity_id = -1)

Line 3078: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL,

3074: AND msn.status_id = mms.status_id(+)
3075: AND mms.language (+) = userenv('LANG')
3076: AND NVL(lot_number, '$@#$%') = NVL(p_lot, NVL(lot_number, '$@#$%'))
3077: AND nvl(msn.revision, '$@#$%') = nvl(p_revision, '$@#$%')
3078: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL,
3079: p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'
3080: AND (((p_wip_entity_id <> -1)
3081: AND (p_wip_entity_id = last_txn_source_id)
3082: )

Line 3147: and inv_material_status_grp.is_status_applicable(

3143: AND last_txn_source_id = p_wip_entity_id
3144: AND p_transaction_type_id = 35
3145: )
3146: )--changed for bug 2767928
3147: and inv_material_status_grp.is_status_applicable(
3148: p_wms_installed, p_transaction_type_id,NULL,NULL,
3149: p_organization_id, p_item_id, NULL, NULL, NULL,
3150: serial_number,'S') = 'Y'
3151: and serial_number like (p_serial)

Line 3600: AND inv_material_status_grp.is_status_applicable('TRUE',

3596: )
3597: AND msn.status_id = mms.status_id(+)
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,

Line 3643: AND inv_material_status_grp.is_status_applicable('TRUE',

3639: )
3640: AND msn.status_id = mms.status_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,

Line 3856: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'

3852: )
3853: AND current_status = 4
3854: AND msn.status_id = mms.status_id(+)
3855: AND mms.language (+) = userenv('LANG')
3856: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'
3857: AND msn.serial_number LIKE (p_serial)
3858: AND EXISTS ( select 'x' from mtl_rma_serial_temp msrt
3859: where msrt.organization_id = p_organization_id
3860: and msrt.inventory_item_id = p_item_id

Line 3885: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'

3881: )
3882: AND current_status = 4
3883: AND msn.status_id = mms.status_id(+)
3884: AND mms.language (+) = userenv('LANG')
3885: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'
3886: AND serial_number LIKE (p_serial)
3887: ORDER BY LPAD(serial_number, 20);
3888: End if;
3889: END get_serial_lov_rma_restrict;

Line 3942: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'

3938: )
3939: AND msn.status_id = mms.status_id(+)
3940: AND mms.language (+) = userenv('LANG')
3941: AND serial_number LIKE (p_serial)
3942: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'
3943: UNION
3944: SELECT serial_number
3945: , current_subinventory_code
3946: , current_locator_id

Line 3968: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y')

3964: AND Nvl(msn.lpn_id,NVL(p_from_lpn_id,-1)) = NVL(p_from_lpn_id, NVL(msn.lpn_id, -1))
3965: AND msn.status_id = mms.status_id(+)
3966: AND mms.language (+) = userenv('LANG')
3967: AND serial_number LIKE (p_serial)
3968: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y')
3969: ORDER BY LPAD(serial_number, 20) ;
3970:
3971: END get_serial_lov_asn_rcv;
3972: