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 44: 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'

40: )
41: AND msn.status_id = mms.status_id(+)
42: AND mms.language (+) = userenv('LANG')
43: AND serial_number LIKE (p_serial)
44: 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'
45: ORDER BY LPAD(serial_number, 20);
46: END get_serial_lov_rcv;
47:
48: -- This is equivalent to inv_serial3 in the serial entry form INVTTESR

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

125: )
126: AND current_status = 4
127: AND msn.status_id = mms.status_id(+)
128: AND mms.language (+) = userenv('LANG')
129: 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'
130: AND msn.serial_number LIKE (p_serial)
131: AND EXISTS ( select 'x' from mtl_rma_serial_temp msrt
132: where msrt.organization_id = p_organization_id
133: and msrt.inventory_item_id = p_item_id

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

153: )
154: AND current_status = 4
155: AND msn.status_id = mms.status_id(+)
156: AND mms.language (+) = userenv('LANG')
157: 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'
158: AND serial_number LIKE (p_serial)
159: ORDER BY LPAD(serial_number, 20);
160: End if;
161: END get_serial_lov_rma_rcv;

Line 260: AND inv_material_status_grp.is_status_applicable(

256: (Nvl(rss.lot_num,'@@@') = Nvl(p_lot_num,'@@@')))
257: )
258: AND msn.status_id = mms.status_id(+)
259: AND mms.language (+) = userenv('LANG')
260: AND inv_material_status_grp.is_status_applicable(
261: p_wms_installed
262: , p_transaction_type_id
263: , NULL
264: , NULL

Line 305: AND inv_material_status_grp.is_status_applicable(

301: AND rsl.to_organization_id = p_organization_id
302: AND rsl.item_id = p_item_id
303: AND msn.status_id = mms.status_id(+)
304: AND mms.language (+) = userenv('LANG')
305: AND inv_material_status_grp.is_status_applicable(
306: p_wms_installed
307: , p_transaction_type_id
308: , NULL
309: , NULL

Line 381: 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, 'A') = 'Y'

377: AND NVL(current_locator_id, 0) = NVL(DECODE(p_locator_id, -1, current_locator_id, p_locator_id), 0)
378: AND msn.status_id = mms.status_id(+)
379: AND mms.language (+) = userenv('LANG')
380: AND serial_number LIKE (p_serial)
381: 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, 'A') = 'Y'
382: ORDER BY LPAD(serial_number, 20);
383:
384: END;
385:

Line 665: AND inv_material_status_grp.is_status_applicable(

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

Line 720: AND inv_material_status_grp.is_status_applicable(

716: OR owning_organization_id = p_owning_org_id)
717: AND (p_owning_tp_type IS NULL
718: OR owning_tp_type = p_owning_tp_type)
719: AND a.serial_number LIKE (p_serial_number)
720: AND inv_material_status_grp.is_status_applicable(
721: p_wms_installed
722: , NULL
723: , p_transaction_type_id
724: , NULL

Line 922: AND inv_material_status_grp.is_status_applicable

918: AND msn.status_id = mms.status_id(+)
919: AND mms.LANGUAGE(+) = USERENV ('LANG')
920: AND serial_number > p_from_serial_number
921: -- Bug# 2770853. Honor the serial material status for physical inventory adjustments.
922: AND inv_material_status_grp.is_status_applicable
923: (NULL,
924: NULL,
925: 8,
926: NULL,

Line 953: AND inv_material_status_grp.is_status_applicable

949: AND msn.status_id = mms.status_id(+)
950: AND mms.LANGUAGE(+) = USERENV ('LANG')
951: AND serial_number > p_from_serial_number
952: -- Bug# 2770853. Honor the serial material status for physical inventory adjustments.
953: AND inv_material_status_grp.is_status_applicable
954: (NULL,
955: NULL,
956: 8,
957: NULL,

Line 1008: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1004: AND organization_id = p_organization_id
1005: AND approval_status IS NULL) OR mpit.adjustment_id IS NULL) --Bug#9772069
1006: -- Bug# 2770853
1007: -- Honor the serial material status for physical inventory adjustments
1008: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1009: NULL,
1010: 8,
1011: NULL,
1012: 'Y',

Line 1062: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1058: AND msn.current_organization_id = msik.organization_id
1059: AND wlpn.lpn_id(+) = msn.lpn_id
1060: -- Bug# 2770853
1061: -- Honor the serial material status for physical inventory adjustments
1062: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1063: NULL,
1064: 8,
1065: NULL,
1066: 'Y',

Line 1115: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1111: AND msn.current_organization_id = msik.organization_id
1112: AND wlpn.lpn_id(+) = msn.lpn_id
1113: -- Bug# 2770853
1114: -- Honor the serial material status for physical inventory adjustments
1115: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1116: NULL,
1117: 8,
1118: NULL,
1119: 'Y',

Line 1227: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1223: AND mcce.entry_status_code = 2
1224: AND NVL(mcce.export_flag, 2) = 2)
1225: -- Bug# 2770853
1226: -- Honor the serial material status for cycle count adjustments
1227: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1228: NULL,
1229: 4,
1230: NULL,
1231: 'Y',

Line 1280: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1276: AND mcce.entry_status_code IN (1, 3)
1277: AND NVL(mcce.export_flag, 2) = 2
1278: -- Bug# 2770853
1279: -- Honor the serial material status for cycle count adjustments
1280: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1281: NULL,
1282: 4,
1283: NULL,
1284: 'Y',

Line 1336: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1332: AND mcce.entry_status_code IN (1, 3)
1333: AND NVL(mcce.export_flag, 2) = 2
1334: -- Bug# 2770853
1335: -- Honor the serial material status for cycle count adjustments
1336: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1337: NULL,
1338: 4,
1339: NULL,
1340: 'Y',

Line 1462: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1458: AND mcce.entry_status_code = 2
1459: AND NVL(mcce.export_flag, 2) = 2)
1460: -- Bug# 2770853
1461: -- Honor the serial material status for cycle count adjustments
1462: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1463: NULL,
1464: 4,
1465: NULL,
1466: 'Y',

Line 1517: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1513: AND mcce.entry_status_code IN (1, 3)
1514: AND NVL(mcce.export_flag, 2) = 2
1515: -- Bug# 2770853
1516: -- Honor the serial material status for cycle count adjustments
1517: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1518: NULL,
1519: 4,
1520: NULL,
1521: 'Y',

Line 1575: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1571: AND mcce.entry_status_code IN (1, 3)
1572: AND NVL(mcce.export_flag, 2) = 2
1573: -- Bug# 2770853
1574: -- Honor the serial material status for cycle count adjustments
1575: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1576: NULL,
1577: 4,
1578: NULL,
1579: 'Y',

Line 1666: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1662: AND mcce.entry_status_code = 2
1663: AND NVL(mcce.export_flag, 2) = 2)
1664: -- Bug# 2770853
1665: -- Honor the serial material status for cycle count adjustments
1666: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1667: NULL,
1668: 4,
1669: NULL,
1670: 'Y',

Line 1718: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1714: AND msn.current_organization_id = msik.organization_id
1715: AND wlpn.lpn_id(+) = msn.lpn_id
1716: -- Bug# 2770853
1717: -- Honor the serial material status for cycle count adjustments
1718: AND INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1719: NULL,
1720: 4,
1721: NULL,
1722: 'Y',

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

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)

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

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)

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

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:

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

2050: AND NVL(lot_number, '@@@') = NVL(NVL(p_lot_number, '@@@'), NVL(lot_number, '@@@'))
2051: AND NVL(revision, '@@@') = NVL(NVL(p_revision, '@@@'), NVL(revision, '@@@'))
2052: AND msn.serial_number LIKE (p_serial)
2053: AND current_status = 3
2054: 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'
2055: ORDER BY LPAD(msn.serial_number, 20);
2056: END get_pupcont_serial_lov;
2057:
2058: -- Name: GET_INV_SERIAL_LOV

Line 2141: AND inv_material_status_grp.is_status_applicable

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

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

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

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

2272: AND mms.language (+) = userenv('LANG')
2273: AND ccg.cost_group_id = msn.cost_group_id
2274: AND msn.current_locator_id = mil.inventory_location_id
2275: AND mil.organization_id = p_organization_id
2276: 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'
2277: AND msn.current_status = 3
2278: AND (msn.group_mark_id IS NULL
2279: OR (msn.group_mark_id <> 1)
2280: )

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

2310: AND mms.language (+) = userenv('LANG')
2311: AND ccg.cost_group_id = msn.cost_group_id
2312: AND msn.current_locator_id = mil.inventory_location_id
2313: AND mil.organization_id = p_organization_id
2314: 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'
2315: AND msn.current_status = 3
2316: AND (msn.group_mark_id IS NULL
2317: OR (msn.group_mark_id <> 1)
2318: )

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

2421: AND msn.status_id = mms.status_id(+)
2422: AND mms.language (+) = userenv('LANG')
2423: AND serial_number LIKE (p_serial)
2424: AND NVL(msn.lot_number, 0) = NVL(p_lot_number, 0) --retrict to lot numbers
2425: 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'
2426: ORDER BY LPAD(serial_number, 20);
2427: END get_serial_lov_picking;
2428:
2429: -- Name: GET_SERIAL_LOV_ALLOC_PICKING

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

2482: AND NVL(msn.lpn_id, 0) = NVL(p_lpn_id, 0)
2483: AND NVL(msn.current_locator_id, 0) = NVL(DECODE(p_locator_id, -1, msn.current_locator_id, p_locator_id), 0)
2484: AND msn.status_id = mms.status_id(+)
2485: AND mms.language (+) = userenv('LANG')
2486: 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'
2487: AND msn.serial_number = msnt.fm_serial_number
2488: AND msnt.fm_serial_number LIKE (p_serial)
2489: AND msnt.transaction_temp_id = p_transaction_temp_id
2490: ORDER BY LPAD(msnt.fm_serial_number, 20);

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

2506: AND NVL(msn.lpn_id, 0) = NVL(p_lpn_id, 0)
2507: AND NVL(msn.current_locator_id, 0) = NVL(DECODE(p_locator_id, -1, msn.current_locator_id, p_locator_id), 0)
2508: AND msn.status_id = mms.status_id(+)
2509: AND mms.language (+) = userenv('LANG')
2510: 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'
2511: AND msn.serial_number = msnt.fm_serial_number
2512: AND msnt.fm_serial_number LIKE (p_serial)
2513: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
2514: AND mtlt.lot_number = p_lot_number

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

2556: AND (p_revision IS NULL
2557: OR (msn.revision = p_revision)
2558: )
2559: AND NVL(msn.lot_number, 0) = NVL(p_lot_number, 0) --retrict to lot numbers
2560: 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'
2561: ORDER BY LPAD(serial_number, 20);
2562: END get_serial_lov_apl_picking;
2563:
2564:

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

2603: --AND NVL(msn.lpn_id, 0) = NVL(p_lpn_id, 0)
2604: AND NVL(msn.current_locator_id, 0) = NVL(DECODE(p_locator_id, -1, msn.current_locator_id, p_locator_id), 0)
2605: AND msn.status_id = mms.status_id(+)
2606: AND mms.language (+) = userenv('LANG')
2607: 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'
2608: AND msn.serial_number = mag.serial_number
2609: AND mag.serial_number LIKE (p_serial)
2610: AND (p_revision IS NULL
2611: OR (msn.revision = p_revision)

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

2629: --AND NVL(msn.lpn_id, 0) = NVL(p_lpn_id, 0)
2630: AND NVL(msn.current_locator_id, 0) = NVL(DECODE(p_locator_id, -1, msn.current_locator_id, p_locator_id), 0)
2631: AND msn.status_id = mms.status_id(+)
2632: AND mms.language (+) = userenv('LANG')
2633: 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'
2634: AND msn.serial_number = mag.serial_number
2635: AND mag.serial_number LIKE (p_serial)
2636: AND mag.lot_number = p_lot_number
2637: AND (p_revision IS NULL

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

2886: AND msn.lpn_id IS NULL
2887: AND msn.status_id = mms.status_id(+)
2888: AND mms.language (+) = userenv('LANG')
2889: AND serial_number LIKE (p_serial)
2890: 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'
2891: ORDER BY LPAD(serial_number, 20);
2892: END get_serial_lov_mo;
2893:
2894: -- Name: GET_SERIAL_LOV_WMA_NEGISS

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

2935: AND last_txn_source_type_id = 5 -- returned to WIP
2936: AND (NVL(lot_number, '%') LIKE l_lot_number)))
2937: AND serial_number LIKE (p_serial)
2938: AND (group_mark_id IS NULL OR group_mark_id = -1)
2939: 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'
2940: ORDER BY LPAD(serial_number, 20);
2941: END get_serial_lov_wma_negiss;
2942:
2943: -- Name: GET_SERIAL_LOV_WMA_ISS

Line 2997: 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')) =

2993: AND serial_number LIKE (p_serial)
2994: AND (group_mark_id IS NULL
2995: OR group_mark_id = -1
2996: )
2997: 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')) =
2998: 'Y'
2999: ORDER BY LPAD(serial_number, 20);
3000: END get_serial_lov_wma_iss;
3001:

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

3069: AND serial_number LIKE (p_serial)
3070: AND (group_mark_id IS NULL
3071: OR group_mark_id = -1
3072: )
3073: 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'
3074: ORDER BY LPAD(serial_number, 20);
3075: END get_serial_lov_wma_rcv;
3076:
3077: -- Name: GET_SERIAL_LOV_WMA_RETCOMP

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

3117: AND last_txn_source_type_id = 5 -- issued to WIP
3118: AND msn.status_id = mms.status_id(+)
3119: AND mms.language (+) = userenv('LANG')
3120: AND NVL(lot_number, '$@#$%') = NVL(p_lot, NVL(lot_number, '$@#$%'))
3121: 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'
3122: AND (((p_wip_entity_id <> -1)
3123: AND (p_wip_entity_id = last_txn_source_id)
3124: )
3125: OR ((p_wip_entity_id = -1)

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

3163: AND msn.status_id = mms.status_id(+)
3164: AND mms.language (+) = userenv('LANG')
3165: AND NVL(lot_number, '$@#$%') = NVL(p_lot, NVL(lot_number, '$@#$%'))
3166: AND nvl(msn.revision, '$@#$%') = nvl(p_revision, '$@#$%')
3167: AND inv_material_status_grp.is_status_applicable(p_wms_installed, p_transaction_type_id, NULL, NULL,
3168: p_organization_id, p_item_id, NULL, NULL, NULL, serial_number, 'S') = 'Y'
3169: AND (((p_wip_entity_id <> -1)
3170: AND (p_wip_entity_id = last_txn_source_id)
3171: )

Line 3236: and inv_material_status_grp.is_status_applicable(

3232: AND last_txn_source_id = p_wip_entity_id
3233: AND p_transaction_type_id = 35
3234: )
3235: )--changed for bug 2767928
3236: and inv_material_status_grp.is_status_applicable(
3237: p_wms_installed, p_transaction_type_id,NULL,NULL,
3238: p_organization_id, p_item_id, NULL, NULL, NULL,
3239: serial_number,'S') = 'Y'
3240: and serial_number like (p_serial)

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

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

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

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

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

3941: )
3942: AND current_status = 4
3943: AND msn.status_id = mms.status_id(+)
3944: AND mms.language (+) = userenv('LANG')
3945: 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'
3946: AND msn.serial_number LIKE (p_serial)
3947: AND EXISTS ( select 'x' from mtl_rma_serial_temp msrt
3948: where msrt.organization_id = p_organization_id
3949: and msrt.inventory_item_id = p_item_id

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

3970: )
3971: AND current_status = 4
3972: AND msn.status_id = mms.status_id(+)
3973: AND mms.language (+) = userenv('LANG')
3974: 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'
3975: AND serial_number LIKE (p_serial)
3976: ORDER BY LPAD(serial_number, 20);
3977: End if;
3978: END get_serial_lov_rma_restrict;

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

4027: )
4028: AND msn.status_id = mms.status_id(+)
4029: AND mms.language (+) = userenv('LANG')
4030: AND serial_number LIKE (p_serial)
4031: 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'
4032: UNION
4033: SELECT serial_number
4034: , current_subinventory_code
4035: , current_locator_id

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

4053: AND Nvl(msn.lpn_id,NVL(p_from_lpn_id,-1)) = NVL(p_from_lpn_id, NVL(msn.lpn_id, -1))
4054: AND msn.status_id = mms.status_id(+)
4055: AND mms.language (+) = userenv('LANG')
4056: AND serial_number LIKE (p_serial)
4057: 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')
4058: ORDER BY LPAD(serial_number, 20) ;
4059:
4060: END get_serial_lov_asn_rcv;
4061:

Line 4339: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_trx_type_id,

4335: AND current_status = 1
4336: AND msn.status_id = mms.status_id(+)
4337: AND mms.language (+) = userenv('LANG')
4338: AND serial_number LIKE (p_serial_number)
4339: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_trx_type_id,
4340: NULL, NULL, p_organization_id, p_inventory_item_id,
4341: NULL, NULL, msn.lot_number, msn.serial_number, 'S') = 'Y'
4342: ORDER BY LPAD(serial_number, 20);
4343: