DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on MTL_LOT_NUMBERS

Line 930: FROM mtl_lot_numbers

926: l_spec GMD_SPECIFICATIONS%ROWTYPE;
927:
928: CURSOR c_item_lot_number IS
929: SELECT 1
930: FROM mtl_lot_numbers
931: WHERE organization_id = l_inv_vr.organization_id
932: AND inventory_item_id = l_spec.inventory_item_id
933: AND lot_number = l_inv_vr.lot_number;
934:

Line 937: FROM mtl_lot_numbers

933: AND lot_number = l_inv_vr.lot_number;
934:
935: CURSOR c_item_parent_lot IS
936: SELECT 1
937: FROM mtl_lot_numbers
938: WHERE organization_id = l_inv_vr.organization_id
939: AND inventory_item_id = l_spec.inventory_item_id
940: AND parent_lot_number = l_inv_vr.parent_lot_number;
941: