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_INV_LOVS dependencies on INV_MATERIAL_STATUS_GRP

Line 69: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y'

65: AND (p_owning_org_id IS NULL
66: OR moqd.owning_organization_id = p_owning_org_id)
67: AND (p_owning_tp_type IS NULL
68: OR moqd.owning_tp_type = p_owning_tp_type))
69: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y'
70: -- Bug 5018199
71: UNION
72: SELECT DISTINCT mln.parent_lot_number
73: , mln.description

Line 98: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y';

94: AND (p_owning_org_id IS NULL
95: OR moqd.owning_organization_id = p_owning_org_id)
96: AND (p_owning_tp_type IS NULL
97: OR moqd.owning_tp_type = p_owning_tp_type))
98: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y';
99: -- End Bug 5018199
100: ELSE
101: OPEN x_lot_num_lov FOR
102: SELECT DISTINCT mln.lot_number

Line 129: 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_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y';

125: AND (p_owning_org_id IS NULL
126: OR moqd.owning_organization_id = p_owning_org_id)
127: AND (p_owning_tp_type IS NULL
128: OR moqd.owning_tp_type = p_owning_tp_type))
129: 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_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y';
130: --Passed p_subinventory_code and p_locator_id in is_status_applicable call for Onhand status support project ,Bug#6633612
131: END IF;
132: END get_lot_lov;
133:

Line 175: 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_subinventory_code, p_locator_id , mln.lot_number, NULL, 'O') = 'Y';

171: AND NVL(mln.disable_flag,'2') = '2' --Bug#4108798 Disabled lots must not be displayed
172: AND NVL(mln.expiration_date,sysdate +1 ) > sysdate -- Expired lots must not be displayed . -- Bug#5360600 - Items with null expiration date should be displayed.
173: AND mln.status_id = mmst.status_id (+)
174: AND mmst.language (+) = userenv('LANG')
175: 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_subinventory_code, p_locator_id , mln.lot_number, NULL, 'O') = 'Y';
176: END get_lot_lov_for_receiving;
177:
178: -- Name: ASN_LOT_LOV
179: --

Line 223: 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_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'

219: AND moq.inventory_item_id = mln.inventory_item_id
220: AND moq.organization_id = mln.organization_id)
221: AND mln.status_id = mmst.status_id (+)
222: AND mmst.language (+) = userenv('LANG')
223: 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_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
224: UNION
225: SELECT DISTINCT mln.lot_number
226: , mln.description
227: , mln.expiration_date

Line 263: 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_subinventory_code , p_locator_id , lot_number, NULL, 'O') = 'Y'

259: AND rls.lot_num = mln.lot_number
260: AND rls.lot_num LIKE (p_lot_number)
261: AND mln.status_id = mmst.status_id (+)
262: AND mmst.language (+) = userenv('LANG')
263: 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_subinventory_code , p_locator_id , lot_number, NULL, 'O') = 'Y'
264: GROUP BY rls.lot_num, mln.description, mln.expiration_date, mmst.status_code
265: HAVING SUM(rls.primary_quantity) > 0;
266: END asn_lot_lov;
267:

Line 326: 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_subinventory_code , p_locator_id , lot_number, NULL, 'O') = 'Y'

322: AND rls.lot_num LIKE (p_lot_number)
323: AND rls.SUPPLY_TYPE_CODE = 'SHIPMENT' --Bug 6908946
324: AND mlnv.status_id = mmst.status_id (+)
325: AND mmst.language (+) = userenv('LANG')
326: 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_subinventory_code , p_locator_id , lot_number, NULL, 'O') = 'Y'
327: GROUP BY rls.lot_num, mlnv.description, mlnv.expiration_date, mmst.status_code
328: HAVING SUM(rls.quantity) > 0;
329: ELSE --Added p_subinventory_code and p_locator_id in below call:
330: get_lot_lov_for_receiving(x_lot_num_lov, p_organization_id, p_item_id, p_lot_number, p_transaction_type_id, p_wms_installed, NULL, p_subinventory_code, p_locator_id);

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_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y';

377: AND NVL(moq.locator_id, -999) = NVL(p_locator_id, NVL(moq.locator_id, -999))
378: AND moq.inventory_item_id = p_item_id)
379: AND mln.status_id = mmst.status_id (+)
380: AND mmst.language (+) = userenv('LANG')
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_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y';
382: END get_pack_lot_lov;
383:
384: -- Name: GET_CGUPDATE_LOT_LOV
385: --

Line 428: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, 86, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code , p_locator_id , moq.lot_number, NULL, 'O') = 'Y'

424: AND mln.inventory_item_id = p_inventory_item_id
425: AND mln.organization_id = p_organization_id
426: AND mln.status_id = mmst.status_id (+)
427: AND mmst.language (+) = userenv('LANG')
428: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, 86, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code , p_locator_id , moq.lot_number, NULL, 'O') = 'Y'
429: AND moq.lot_number LIKE (p_lot_number)
430: AND (moq.cost_group_id = p_from_cost_group_id
431: OR p_from_cost_group_id IS NULL
432: )

Line 457: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, 86, NULL, NULL, p_organization_id, p_inventory_item_id, NULL, NULL, wlc.lot_number, NULL, 'O') = 'Y'

453: AND mln.inventory_item_id = p_inventory_item_id
454: AND mln.organization_id = p_organization_id
455: AND mln.status_id = mmst.status_id (+)
456: AND mmst.language (+) = userenv('LANG')
457: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, 86, NULL, NULL, p_organization_id, p_inventory_item_id, NULL, NULL, wlc.lot_number, NULL, 'O') = 'Y'
458: AND wlc.lot_number LIKE (p_lot_number)
459: AND (wlc.cost_group_id = p_from_cost_group_id
460: OR p_from_cost_group_id IS NULL
461: )

Line 946: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,

942: AND mln.inventory_item_id = msik.inventory_item_id
943: AND mln.inventory_item_id LIKE l_inventory_item_id
944: AND msik.lot_split_enabled = 'Y'
945: AND mln.lot_number LIKE (p_lot_number)
946: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,
947: p_organization_id, msik.inventory_item_id, p_locator_id , p_subinventory_code , mln.lot_number, NULL, 'O') = 'Y'
948: UNION ALL
949: SELECT mln.lot_number lot_number
950: , mln.inventory_item_id

Line 996: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,

992: AND mln.inventory_item_id = msik.inventory_item_id
993: AND mln.inventory_item_id LIKE l_inventory_item_id
994: AND msik.lot_merge_enabled = 'Y'
995: AND mln.lot_number LIKE (p_lot_number)
996: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,
997: p_organization_id, msik.inventory_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
998: UNION ALL
999: SELECT DISTINCT moq.lot_number
1000: , moq.inventory_item_id

Line 1024: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,

1020: AND mln.inventory_item_id = msik.inventory_item_id
1021: AND mln.inventory_item_id LIKE l_inventory_item_id
1022: AND msik.lot_merge_enabled = 'Y'
1023: AND mln.lot_number LIKE (p_lot_number)
1024: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,
1025: p_organization_id, msik.inventory_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
1026: ORDER BY 1, concatenated_segments;
1027: ELSE
1028: OPEN x_lot_num_lov FOR

Line 1045: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,

1041: AND mln.inventory_item_id = msik.inventory_item_id
1042: AND mln.inventory_item_id LIKE l_inventory_item_id
1043: AND msik.lot_merge_enabled = 'Y'
1044: AND mln.lot_number LIKE (p_lot_number)
1045: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,
1046: p_organization_id, msik.inventory_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
1047: UNION ALL
1048: SELECT mln.lot_number lot_number
1049: , mln.inventory_item_id

Line 1063: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,

1059: AND mln.inventory_item_id = msik.inventory_item_id
1060: AND mln.inventory_item_id LIKE l_inventory_item_id
1061: AND msik.lot_merge_enabled = 'Y'
1062: AND mln.lot_number LIKE (p_lot_number)
1063: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,
1064: p_organization_id, msik.inventory_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
1065: ORDER BY lot_number, concatenated_segments;
1066: END IF;
1067: -- For bug 4306954: Added ELSIF condtion for Lot Translate case.

Line 1088: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,

1084: AND msik.lot_control_code = 2
1085: AND mln.inventory_item_id LIKE l_inventory_item_id
1086: AND mln.lot_number LIKE (p_lot_number)
1087: AND msik.lot_translate_enabled = 'Y'
1088: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,
1089: p_organization_id, msik.inventory_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
1090: UNION ALL
1091: SELECT mln.lot_number LN
1092: , mln.inventory_item_id

Line 1126: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id,

1122: AND mln.inventory_item_id = msik.inventory_item_id
1123: AND msik.lot_control_code = 2
1124: AND mln.inventory_item_id LIKE l_inventory_item_id
1125: AND mln.lot_number LIKE (p_lot_number)
1126: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id,
1127: p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
1128: UNION ALL
1129: SELECT mln.lot_number LN
1130: , mln.inventory_item_id

Line 1221: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y'

1217: AND mln.inventory_item_id = msik.inventory_item_id
1218: AND mln.inventory_item_id LIKE l_inventory_item_id
1219: AND msik.lot_split_enabled = 'Y'
1220: AND mln.lot_number LIKE (p_lot_number)
1221: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y'
1222: UNION ALL
1223: SELECT mln.lot_number lot_number
1224: , mln.inventory_item_id
1225: , msik.concatenated_segments concatenated_segments

Line 1271: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id, NULL, NULL, mln.lot_number, NULL, 'O') =

1267: AND mln.inventory_item_id LIKE l_inventory_item_id
1268: AND msik.lot_merge_enabled = 'Y'
1269: AND mln.lot_number LIKE (p_lot_number)
1270: AND mln.status_id LIKE (l_status_id) -- restrict to lot_status
1271: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id, NULL, NULL, mln.lot_number, NULL, 'O') =
1272: 'Y'
1273: UNION ALL
1274: SELECT DISTINCT moq.lot_number
1275: , moq.inventory_item_id

Line 1300: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id, NULL, NULL, mln.lot_number, NULL, 'O') =

1296: AND mln.inventory_item_id LIKE l_inventory_item_id
1297: AND msik.lot_merge_enabled = 'Y'
1298: AND mln.lot_number LIKE (p_lot_number)
1299: AND mln.status_id LIKE (l_status_id) -- restrict to lot_status
1300: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id, NULL, NULL, mln.lot_number, NULL, 'O') =
1301: 'Y'
1302: ORDER BY 1, concatenated_segments;
1303: ELSE
1304: OPEN x_lot_num_lov FOR

Line 1322: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y'

1318: AND mln.inventory_item_id LIKE l_inventory_item_id
1319: AND msik.lot_merge_enabled = 'Y'
1320: AND mln.lot_number LIKE (p_lot_number)
1321: AND mln.status_id LIKE (l_status_id) -- restrict to lot_status
1322: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y'
1323: UNION ALL
1324: SELECT mln.lot_number lot_number
1325: , mln.inventory_item_id
1326: , msik.concatenated_segments concatenated_segments

Line 1340: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y'

1336: AND mln.inventory_item_id LIKE l_inventory_item_id
1337: AND msik.lot_merge_enabled = 'Y'
1338: AND mln.lot_number LIKE (p_lot_number)
1339: AND mln.status_id LIKE (l_status_id) -- restrict to lot_status
1340: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y'
1341: ORDER BY lot_number, concatenated_segments;
1342: END IF;
1343: -- For bug 4306954: Added ELSIF condtion for Lot Translate case.
1344: -- SQL st will allow only those rows that are Lot Translate enabled.

Line 1364: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y'

1360: AND msik.lot_control_code = 2
1361: AND mln.inventory_item_id LIKE l_inventory_item_id
1362: AND mln.lot_number LIKE (p_lot_number)
1363: AND msik.lot_translate_enabled = 'Y'
1364: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y'
1365: UNION ALL
1366: SELECT mln.lot_number LN
1367: , mln.inventory_item_id
1368: , msik.concatenated_segments cs

Line 1401: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y'

1397: AND mln.inventory_item_id = msik.inventory_item_id
1398: AND msik.lot_control_code = 2
1399: AND mln.inventory_item_id LIKE l_inventory_item_id
1400: AND mln.lot_number LIKE (p_lot_number)
1401: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y'
1402: UNION ALL
1403: SELECT mln.lot_number LN
1404: , mln.inventory_item_id
1405: , msik.concatenated_segments cs

Line 1591: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1587: AND mmst.language (+) = userenv('LANG')
1588: AND mln.lot_number LIKE (p_lot_number)
1589: -- Bug# 2770853
1590: -- Honor the lot material status for cycle count adjustment transaction
1591: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1592: NULL,
1593: 4,
1594: 'Y',
1595: NULL,

Line 1640: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1636: AND NVL(mcce.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
1637: AND mcce.entry_status_code IN (1, 3)
1638: -- Bug# 2770853
1639: -- Honor the lot material status for cycle count adjustment transaction
1640: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1641: NULL,
1642: 4,
1643: 'Y',
1644: NULL,

Line 1732: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, 501, NULL, NULL, p_organization_id, p_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y';

1728: AND mln.inventory_item_id = wlc.inventory_item_id
1729: AND mln.lot_number = wlc.lot_number
1730: AND mln.organization_id = wlc.organization_id
1731: AND wlc.lot_number LIKE (p_lot_number)
1732: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, 501, NULL, NULL, p_organization_id, p_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y';
1733: END get_cont_lot_lov;
1734:
1735: -- Added p_subinventory_code and p_locator_id parameters as part of onhand status support project
1736: PROCEDURE get_split_cont_lot_lov(x_lot_num_lov OUT NOCOPY t_genref, p_organization_id IN NUMBER, p_item_id IN NUMBER,

Line 1753: AND (inv_material_status_grp.is_status_applicable('TRUE', NULL, 501, NULL, NULL, p_organization_id, p_item_id, p_subinventory_code, p_locator_id, mln.lot_number, NULL, 'O') = 'Y')

1749: AND mln.inventory_item_id = wlc.inventory_item_id
1750: AND mln.lot_number = wlc.lot_number
1751: AND mln.organization_id = wlc.organization_id
1752: AND wlc.lot_number LIKE (p_lot_number)
1753: AND (inv_material_status_grp.is_status_applicable('TRUE', NULL, 501, NULL, NULL, p_organization_id, p_item_id, p_subinventory_code, p_locator_id, mln.lot_number, NULL, 'O') = 'Y')
1754: AND (inv_material_status_grp.is_status_applicable('TRUE', NULL, 500, NULL, NULL, p_organization_id, p_item_id, p_subinventory_code, p_locator_id, mln.lot_number, NULL, 'O') = 'Y');
1755: END get_split_cont_lot_lov;
1756:
1757: PROCEDURE get_all_lot_lov(x_lot_num_lov OUT NOCOPY t_genref, p_organization_id IN NUMBER, p_lot_number IN VARCHAR2) IS

Line 1754: AND (inv_material_status_grp.is_status_applicable('TRUE', NULL, 500, NULL, NULL, p_organization_id, p_item_id, p_subinventory_code, p_locator_id, mln.lot_number, NULL, 'O') = 'Y');

1750: AND mln.lot_number = wlc.lot_number
1751: AND mln.organization_id = wlc.organization_id
1752: AND wlc.lot_number LIKE (p_lot_number)
1753: AND (inv_material_status_grp.is_status_applicable('TRUE', NULL, 501, NULL, NULL, p_organization_id, p_item_id, p_subinventory_code, p_locator_id, mln.lot_number, NULL, 'O') = 'Y')
1754: AND (inv_material_status_grp.is_status_applicable('TRUE', NULL, 500, NULL, NULL, p_organization_id, p_item_id, p_subinventory_code, p_locator_id, mln.lot_number, NULL, 'O') = 'Y');
1755: END get_split_cont_lot_lov;
1756:
1757: PROCEDURE get_all_lot_lov(x_lot_num_lov OUT NOCOPY t_genref, p_organization_id IN NUMBER, p_lot_number IN VARCHAR2) IS
1758: BEGIN

Line 1971: 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_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y';

1967: AND mln.status_id = mmst.status_id (+)
1968: AND mmst.language (+) = userenv('LANG')
1969: AND mtlt.lot_number = mln.lot_number
1970: AND mtlt.transaction_temp_id = p_txn_temp_id
1971: 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_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y';
1972: ELSE --as lpn_id is not null ,hence sub and loc are not passed in is_status_applicable
1973: -- It however remains same for LPNs
1974: OPEN x_lot_num_lov FOR
1975: SELECT DISTINCT mln.lot_number

Line 2002: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y';

1998: AND wlc.parent_lpn_id = p_lpn_id
1999: AND wlc.lot_number = mln.lot_number
2000: AND wlc.inventory_item_id = p_item_id
2001: AND wlc.organization_id = p_organization_id
2002: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y';
2003: END IF;
2004: ELSE
2005: -- Negative inventory balances not allowed
2006:

Line 2035: 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_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y';

2031: AND moq.subinventory_code = NVL(p_subinventory_code, moq.subinventory_code)
2032: AND NVL(moq.locator_id, -1) = NVL(NVL(p_locator_id, moq.locator_id), -1))
2033: AND mtlt.lot_number = mln.lot_number
2034: AND mtlt.transaction_temp_id = p_txn_temp_id
2035: 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_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y';
2036: ELSE
2037: OPEN x_lot_num_lov FOR
2038: SELECT DISTINCT mln.lot_number
2039: , mln.description

Line 2065: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y';

2061: AND wlc.parent_lpn_id = p_lpn_id
2062: AND wlc.lot_number = mln.lot_number
2063: AND wlc.inventory_item_id = p_item_id
2064: AND wlc.organization_id = p_organization_id
2065: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y';
2066: END IF;
2067: END IF;
2068: END get_td_lot_lov;
2069:

Line 2110: 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_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'

2106: AND mln.lot_number LIKE (p_lot_number)
2107: AND mln.status_id = mmst.status_id (+)
2108: AND mmst.language (+) = userenv('LANG')
2109: AND mag.lot_number = mln.lot_number
2110: 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_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
2111: GROUP BY mln.lot_number
2112: , mln.description
2113: , mln.expiration_date
2114: , mmst.status_code

Line 2142: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y'

2138: AND NVL(moq.locator_id, -1) = NVL(NVL(p_locator_id, moq.locator_id), -1))
2139: AND mtlt.lot_number = mln.lot_number
2140: AND mtlt.transaction_temp_id = p_txn_temp_id
2141: AND mag.lot_number = mln.lot_number
2142: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_item_id, NULL, NULL, mln.lot_number, NULL, 'O') = 'Y'
2143: GROUP BY mln.lot_number
2144: , mln.description
2145: , mln.expiration_date
2146: , mmst.status_code

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

2280: AND mln.organization_id = wlc.organization_id
2281: AND mln.status_id = mmst.status_id (+)
2282: AND mmst.language (+) = userenv('LANG')
2283: AND wlc.lot_number LIKE (p_lot_number)
2284: AND inv_material_status_grp.is_status_applicable('TRUE',
2285: NULL,
2286: INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
2287: NULL,
2288: NULL,