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 1146: FROM mtl_lot_numbers

1142: AND inventory_location_id = p_locator_id;
1143:
1144: CURSOR c_lot_status IS
1145: SELECT status_id
1146: FROM mtl_lot_numbers
1147: WHERE organization_id = p_organization_id
1148: AND inventory_item_id = p_inventory_item_id
1149: AND lot_number = p_lot_number;
1150:

Line 1460: ,mtl_lot_numbers lot

1456: ,moq.project_id
1457: ,moq.task_id
1458: ) x
1459: ,mtl_secondary_inventories sub
1460: ,mtl_lot_numbers lot
1461: WHERE
1462: x.primary_quantity > 0
1463: AND x.organization_id = sub.organization_id
1464: AND x.subinventory_code = sub.secondary_inventory_name

Line 2622: mtl_lot_numbers mln

2618: ,mln.expiration_action_date
2619: ,mln.expiration_action_code
2620: ,mln.hold_date
2621: FROM mtl_material_transactions_temp mmtt,
2622: mtl_lot_numbers mln
2623: WHERE mmtt.transaction_temp_id = p_mtlt_tbl(l_counter).transaction_temp_id
2624: and mln.inventory_item_id = mmtt.inventory_item_id
2625: and mln.organization_id = mmtt.organization_id
2626: and mln.lot_number = p_mtlt_tbl(l_counter).lot_number

Line 3732: FROM mtl_lot_numbers

3728: CURSOR c_lot_status (p_organization_id in NUMBER
3729: , p_lot_number in varchar2)
3730: IS
3731: SELECT decode(reservable_type,2,0,reservable_type)
3732: FROM mtl_lot_numbers
3733: WHERE organization_id = p_organization_id
3734: AND inventory_item_id = p_inventory_item_id
3735: AND lot_number = p_lot_number;
3736: