807:
808: UNION
809:
810: select porl.need_by_date exp_comp_date
811: from mtl_reservations mr, po_requisition_lines_all porl
812: where mr.demand_source_type_id = 2
813: and mr.demand_source_line_id = l_config_line_id
814: and mr.supply_source_type_id in (7, 17)
815: and mr.supply_source_header_id = porl.requisition_header_id
825:
826: UNION
827:
828: select porl.need_by_date exp_comp_date
829: from oe_drop_ship_sources ods, po_requisition_lines_all porl
830: where ods.line_id = l_config_line_id
831: and ods.po_header_id is null
832: and ods.requisition_header_id = porl.requisition_header_id
833: and ods.requisition_line_id = porl.requisition_line_id