DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on MTL_LOT_NUMBERS

Line 941: FROM mtl_lot_numbers

937: l_spec GMD_SPECIFICATIONS%ROWTYPE;
938:
939: CURSOR c_item_lot_number IS
940: SELECT 1
941: FROM mtl_lot_numbers
942: WHERE organization_id = l_inv_vr.organization_id
943: AND inventory_item_id = l_spec.inventory_item_id
944: AND lot_number = l_inv_vr.lot_number;
945:

Line 948: FROM mtl_lot_numbers

944: AND lot_number = l_inv_vr.lot_number;
945:
946: CURSOR c_item_parent_lot IS
947: SELECT 1
948: FROM mtl_lot_numbers
949: WHERE organization_id = l_inv_vr.organization_id
950: AND inventory_item_id = l_spec.inventory_item_id
951: AND parent_lot_number = l_inv_vr.parent_lot_number;
952: