APPS.INV_DETAIL_UTIL_PVT dependencies on MTL_LOT_NUMBERS

Line 88: FROM mtl_lot_numbers

84: RETURN DATE IS
85: --
86: CURSOR l_cur IS
87: SELECT expiration_date
88: FROM mtl_lot_numbers
89: WHERE inventory_item_id = p_inventory_item_id
90: AND organization_id = p_organization_id
91: AND lot_number = p_lot_number;
92: --

Line 1279: FROM mtl_lot_numbers

1275: AND inventory_location_id = p_locator_id;
1276:
1277: CURSOR c_lot_status IS
1278: SELECT status_id
1279: FROM mtl_lot_numbers
1280: WHERE organization_id = p_organization_id
1281: AND inventory_item_id = p_inventory_item_id
1282: AND lot_number = p_lot_number;
1283:

Line 1593: ,mtl_lot_numbers lot

1589: ,moq.project_id
1590: ,moq.task_id
1591: ) x
1592: ,mtl_secondary_inventories sub
1593: ,mtl_lot_numbers lot
1594: WHERE
1595: x.primary_quantity > 0
1596: AND x.organization_id = sub.organization_id
1597: AND x.subinventory_code = sub.secondary_inventory_name

Line 2759: mtl_lot_numbers mln

2755: ,mln.expiration_action_date
2756: ,mln.expiration_action_code
2757: ,mln.hold_date
2758: FROM mtl_material_transactions_temp mmtt,
2759: mtl_lot_numbers mln
2760: WHERE mmtt.transaction_temp_id = p_mtlt_tbl(l_counter).transaction_temp_id
2761: and mln.inventory_item_id = mmtt.inventory_item_id
2762: and mln.organization_id = mmtt.organization_id
2763: and mln.lot_number = p_mtlt_tbl(l_counter).lot_number

Line 4151: FROM mtl_lot_numbers

4147: CURSOR c_lot_status (p_organization_id in NUMBER
4148: , p_lot_number in varchar2)
4149: IS
4150: SELECT decode(reservable_type,2,0,reservable_type)
4151: FROM mtl_lot_numbers
4152: WHERE organization_id = p_organization_id
4153: AND inventory_item_id = p_inventory_item_id
4154: AND lot_number = p_lot_number;
4155: