APPS.OE_CNCL_VALIDATE_LINE dependencies on OE_ORDER_LINES

Line 681: FROM oe_order_lines

677: ELSE
678:
679: SELECT inventory_item_id
680: INTO l_ref_inventory_item_id
681: FROM oe_order_lines
682: WHERE line_id = p_reference_line_id;
683:
684: IF (l_ref_inventory_item_id = p_inventory_item_id) THEN
685: RETURN TRUE;

Line 745: FROM oe_order_lines

741: INTO l_ref_fulfilled_quantity
742: , l_ref_shippable_flag
743: , l_ref_inv_iface_status
744: , l_ref_shipped_quantity
745: FROM oe_order_lines
746: WHERE line_id = p_reference_line_id;
747:
748: IF (l_ref_shippable_flag = 'N' AND l_ref_inv_iface_status = 'NOT_ELIGIBLE') THEN
749: RETURN TRUE;

Line 818: FROM oe_order_lines

814: oe_debug_pub.add('Enter Validate_Return_Reference',1);
815:
816: SELECT nvl(booked_flag,'N')
817: INTO l_booked_flag
818: FROM oe_order_lines
819: WHERE line_id = p_reference_line_id
820: and line_category_code = 'ORDER';
821:
822: IF l_booked_flag = 'Y' THEN