DBA Data[Home] [Help]

APPS.INV_LOT_SERIAL_UPGRADE dependencies on MTL_LOT_NUMBERS

Line 29: FROM mtl_lot_numbers

25: ) IS
26:
27: CURSOR c_lot(p_org_id NUMBER) IS
28: SELECT organization_id, inventory_item_id, lot_number
29: FROM mtl_lot_numbers
30: WHERE organization_id = nvl(p_org_id, organization_id)
31: AND lot_attribute_category IS NULL
32: ORDER BY organization_id, inventory_item_id;
33: