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 196: 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';

192: AND oola.inventory_item_id = p_item_id
193: AND olsn.line_id = oola.line_id
194: AND olsn.LOT_NUMBER = mln.lot_number
195: AND rownum =1) ))
196: 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';
197: END get_lot_lov_for_receiving;
198:
199: -- Name: ASN_LOT_LOV
200: --

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

240: AND moq.inventory_item_id = mln.inventory_item_id
241: AND moq.organization_id = mln.organization_id)
242: AND mln.status_id = mmst.status_id (+)
243: AND mmst.language (+) = userenv('LANG')
244: 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'
245: UNION
246: SELECT DISTINCT mln.lot_number
247: , mln.description
248: , mln.expiration_date

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

280: AND rls.lot_num = mln.lot_number
281: AND rls.lot_num LIKE (p_lot_number)
282: AND mln.status_id = mmst.status_id (+)
283: AND mmst.language (+) = userenv('LANG')
284: 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'
285: GROUP BY rls.lot_num, mln.description, mln.expiration_date, mmst.status_code
286: HAVING SUM(rls.primary_quantity) > 0;
287: END asn_lot_lov;
288:

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

344: AND mlnv.lot_number LIKE (p_lot_number) -- Bug 13595510
345: AND rls.SUPPLY_TYPE_CODE = 'SHIPMENT' --Bug 6908946
346: AND mlnv.status_id = mmst.status_id (+)
347: AND mmst.language (+) = userenv('LANG')
348: 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'
349: GROUP BY rls.lot_num, mlnv.description, mlnv.expiration_date, mmst.status_code
350: HAVING SUM(rls.quantity) > 0;
351: ELSE --Added p_subinventory_code and p_locator_id in below call:
352: 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, NULL); -- Bug 12595030, Added NULL for P_rma value

Line 403: 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';

399: AND NVL(moq.locator_id, -999) = NVL(p_locator_id, NVL(moq.locator_id, -999))
400: AND moq.inventory_item_id = p_item_id)
401: AND mln.status_id = mmst.status_id (+)
402: AND mmst.language (+) = userenv('LANG')
403: 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';
404: END get_pack_lot_lov;
405:
406: -- Name: GET_CGUPDATE_LOT_LOV
407: --

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

446: AND mln.inventory_item_id = p_inventory_item_id
447: AND mln.organization_id = p_organization_id
448: AND mln.status_id = mmst.status_id (+)
449: AND mmst.language (+) = userenv('LANG')
450: 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'
451: AND moq.lot_number LIKE (p_lot_number)
452: AND (moq.cost_group_id = p_from_cost_group_id
453: OR p_from_cost_group_id IS NULL
454: )

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

475: AND mln.inventory_item_id = p_inventory_item_id
476: AND mln.organization_id = p_organization_id
477: AND mln.status_id = mmst.status_id (+)
478: AND mmst.language (+) = userenv('LANG')
479: 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'
480: AND wlc.lot_number LIKE (p_lot_number)
481: AND (wlc.cost_group_id = p_from_cost_group_id
482: OR p_from_cost_group_id IS NULL
483: )

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

966: AND mln.inventory_item_id = msik.inventory_item_id
967: AND mln.inventory_item_id LIKE l_inventory_item_id
968: AND msik.lot_split_enabled = 'Y'
969: AND mln.lot_number LIKE (p_lot_number)
970: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,
971: p_organization_id, msik.inventory_item_id, p_locator_id , p_subinventory_code , mln.lot_number, NULL, 'O') = 'Y'
972: UNION ALL
973: SELECT mln.lot_number lot_number
974: , mln.inventory_item_id

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

1016: AND mln.inventory_item_id = msik.inventory_item_id
1017: AND mln.inventory_item_id LIKE l_inventory_item_id
1018: AND msik.lot_merge_enabled = 'Y'
1019: AND mln.lot_number LIKE (p_lot_number)
1020: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,
1021: p_organization_id, msik.inventory_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
1022: UNION ALL
1023: SELECT DISTINCT moq.lot_number
1024: , moq.inventory_item_id

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

1044: AND mln.inventory_item_id = msik.inventory_item_id
1045: AND mln.inventory_item_id LIKE l_inventory_item_id
1046: AND msik.lot_merge_enabled = 'Y'
1047: AND mln.lot_number LIKE (p_lot_number)
1048: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,
1049: p_organization_id, msik.inventory_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
1050: ORDER BY 1, concatenated_segments;
1051: ELSE
1052: OPEN x_lot_num_lov FOR

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

1065: AND mln.inventory_item_id = msik.inventory_item_id
1066: AND mln.inventory_item_id LIKE l_inventory_item_id
1067: AND msik.lot_merge_enabled = 'Y'
1068: AND mln.lot_number LIKE (p_lot_number)
1069: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,
1070: p_organization_id, msik.inventory_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
1071: UNION ALL
1072: SELECT mln.lot_number lot_number
1073: , mln.inventory_item_id

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

1083: AND mln.inventory_item_id = msik.inventory_item_id
1084: AND mln.inventory_item_id LIKE l_inventory_item_id
1085: AND msik.lot_merge_enabled = 'Y'
1086: AND mln.lot_number LIKE (p_lot_number)
1087: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,
1088: p_organization_id, msik.inventory_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
1089: ORDER BY lot_number, concatenated_segments;
1090: END IF;
1091: -- For bug 4306954: Added ELSIF condtion for Lot Translate case.

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

1108: AND msik.lot_control_code = 2
1109: AND mln.inventory_item_id LIKE l_inventory_item_id
1110: AND mln.lot_number LIKE (p_lot_number)
1111: AND msik.lot_translate_enabled = 'Y'
1112: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,
1113: p_organization_id, msik.inventory_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
1114: UNION ALL
1115: SELECT mln.lot_number LN
1116: , mln.inventory_item_id

Line 1150: 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,

1146: AND mln.inventory_item_id = msik.inventory_item_id
1147: AND msik.lot_control_code = 2
1148: AND mln.inventory_item_id LIKE l_inventory_item_id
1149: AND mln.lot_number LIKE (p_lot_number)
1150: 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,
1151: p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
1152: UNION ALL
1153: SELECT mln.lot_number LN
1154: , mln.inventory_item_id

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

1241: AND mln.inventory_item_id = msik.inventory_item_id
1242: AND mln.inventory_item_id LIKE l_inventory_item_id
1243: AND msik.lot_split_enabled = 'Y'
1244: AND mln.lot_number LIKE (p_lot_number)
1245: 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'
1246: UNION ALL
1247: SELECT mln.lot_number lot_number
1248: , mln.inventory_item_id
1249: , msik.concatenated_segments concatenated_segments

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

1291: AND mln.inventory_item_id LIKE l_inventory_item_id
1292: AND msik.lot_merge_enabled = 'Y'
1293: AND mln.lot_number LIKE (p_lot_number)
1294: AND mln.status_id LIKE (l_status_id) -- restrict to lot_status
1295: 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: 'Y'
1297: UNION ALL
1298: SELECT DISTINCT moq.lot_number
1299: , moq.inventory_item_id

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

1320: AND mln.inventory_item_id LIKE l_inventory_item_id
1321: AND msik.lot_merge_enabled = 'Y'
1322: AND mln.lot_number LIKE (p_lot_number)
1323: AND mln.status_id LIKE (l_status_id) -- restrict to lot_status
1324: 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') =
1325: 'Y'
1326: ORDER BY 1, concatenated_segments;
1327: ELSE
1328: OPEN x_lot_num_lov FOR

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

1342: AND mln.inventory_item_id LIKE l_inventory_item_id
1343: AND msik.lot_merge_enabled = 'Y'
1344: AND mln.lot_number LIKE (p_lot_number)
1345: AND mln.status_id LIKE (l_status_id) -- restrict to lot_status
1346: 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'
1347: UNION ALL
1348: SELECT mln.lot_number lot_number
1349: , mln.inventory_item_id
1350: , msik.concatenated_segments concatenated_segments

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 mln.inventory_item_id LIKE l_inventory_item_id
1361: AND msik.lot_merge_enabled = 'Y'
1362: AND mln.lot_number LIKE (p_lot_number)
1363: AND mln.status_id LIKE (l_status_id) -- restrict to lot_status
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: ORDER BY lot_number, concatenated_segments;
1366: END IF;
1367: -- For bug 4306954: Added ELSIF condtion for Lot Translate case.
1368: -- SQL st will allow only those rows that are Lot Translate enabled.

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

1384: AND msik.lot_control_code = 2
1385: AND mln.inventory_item_id LIKE l_inventory_item_id
1386: AND mln.lot_number LIKE (p_lot_number)
1387: AND msik.lot_translate_enabled = 'Y'
1388: 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'
1389: UNION ALL
1390: SELECT mln.lot_number LN
1391: , mln.inventory_item_id
1392: , msik.concatenated_segments cs

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

1421: AND mln.inventory_item_id = msik.inventory_item_id
1422: AND msik.lot_control_code = 2
1423: AND mln.inventory_item_id LIKE l_inventory_item_id
1424: AND mln.lot_number LIKE (p_lot_number)
1425: 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'
1426: UNION ALL
1427: SELECT mln.lot_number LN
1428: , mln.inventory_item_id
1429: , msik.concatenated_segments cs

Line 1615: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1611: AND mmst.language (+) = userenv('LANG')
1612: AND mln.lot_number LIKE (p_lot_number)
1613: -- Bug# 2770853
1614: -- Honor the lot material status for cycle count adjustment transaction
1615: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1616: NULL,
1617: 4,
1618: 'Y',
1619: NULL,

Line 1664: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

1660: AND NVL(mcce.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
1661: AND mcce.entry_status_code IN (1, 3)
1662: -- Bug# 2770853
1663: -- Honor the lot material status for cycle count adjustment transaction
1664: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
1665: NULL,
1666: 4,
1667: 'Y',
1668: NULL,

Line 1756: 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';

1752: AND mln.inventory_item_id = wlc.inventory_item_id
1753: AND mln.lot_number = wlc.lot_number
1754: AND mln.organization_id = wlc.organization_id
1755: AND wlc.lot_number LIKE (p_lot_number)
1756: 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';
1757: END get_cont_lot_lov;
1758:
1759: -- Added p_subinventory_code and p_locator_id parameters as part of onhand status support project
1760: 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 1777: 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')

1773: AND mln.inventory_item_id = wlc.inventory_item_id
1774: AND mln.lot_number = wlc.lot_number
1775: AND mln.organization_id = wlc.organization_id
1776: AND wlc.lot_number LIKE (p_lot_number)
1777: 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')
1778: 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');
1779: END get_split_cont_lot_lov;
1780:
1781: 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 1778: 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');

1774: AND mln.lot_number = wlc.lot_number
1775: AND mln.organization_id = wlc.organization_id
1776: AND wlc.lot_number LIKE (p_lot_number)
1777: 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')
1778: 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');
1779: END get_split_cont_lot_lov;
1780:
1781: PROCEDURE get_all_lot_lov(x_lot_num_lov OUT NOCOPY t_genref, p_organization_id IN NUMBER, p_lot_number IN VARCHAR2) IS
1782: BEGIN

Line 1995: 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';

1991: AND mln.status_id = mmst.status_id (+)
1992: AND mmst.language (+) = userenv('LANG')
1993: AND mtlt.lot_number = mln.lot_number
1994: AND mtlt.transaction_temp_id = p_txn_temp_id
1995: 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';
1996: ELSE --as lpn_id is not null ,hence sub and loc are not passed in is_status_applicable
1997: -- It however remains same for LPNs
1998: OPEN x_lot_num_lov FOR
1999: SELECT DISTINCT mln.lot_number

Line 2026: 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';

2022: AND wlc.parent_lpn_id = p_lpn_id
2023: AND wlc.lot_number = mln.lot_number
2024: AND wlc.inventory_item_id = p_item_id
2025: AND wlc.organization_id = p_organization_id
2026: 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';
2027: END IF;
2028: ELSE
2029: -- Negative inventory balances not allowed
2030:

Line 2059: 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';

2055: AND moq.subinventory_code = NVL(p_subinventory_code, moq.subinventory_code)
2056: AND NVL(moq.locator_id, -1) = NVL(NVL(p_locator_id, moq.locator_id), -1))
2057: AND mtlt.lot_number = mln.lot_number
2058: AND mtlt.transaction_temp_id = p_txn_temp_id
2059: 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';
2060: ELSE
2061: OPEN x_lot_num_lov FOR
2062: SELECT DISTINCT mln.lot_number
2063: , mln.description

Line 2089: 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';

2085: AND wlc.parent_lpn_id = p_lpn_id
2086: AND wlc.lot_number = mln.lot_number
2087: AND wlc.inventory_item_id = p_item_id
2088: AND wlc.organization_id = p_organization_id
2089: 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';
2090: END IF;
2091: END IF;
2092: END get_td_lot_lov;
2093:

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

2131: AND mln.lot_number LIKE (p_lot_number)
2132: AND mln.status_id = mmst.status_id (+)
2133: AND mmst.language (+) = userenv('LANG')
2134: AND mag.lot_number = mln.lot_number
2135: 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'
2136: GROUP BY mln.lot_number
2137: , mln.description
2138: , mln.expiration_date
2139: , mmst.status_code

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

2168: (mtlt.lot_number = mln.lot_number AND mtlt.transaction_temp_id = p_txn_temp_id AND p_isLotSubtitution = 'Y')
2169: )
2170: --/* Bug 9448490 Lot Substitution Project */ end
2171: AND mag.lot_number = mln.lot_number
2172: 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'
2173: GROUP BY mln.lot_number
2174: , mln.description
2175: , mln.expiration_date
2176: , mmst.status_code

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

2310: AND mln.organization_id = wlc.organization_id
2311: AND mln.status_id = mmst.status_id (+)
2312: AND mmst.language (+) = userenv('LANG')
2313: AND wlc.lot_number LIKE (p_lot_number)
2314: AND inv_material_status_grp.is_status_applicable('TRUE',
2315: NULL,
2316: INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
2317: NULL,
2318: NULL,