763: into lWipEntityId
764: from wip_flow_schedules wfs,
765: oe_order_lines_all oel,
766: oe_order_headers_all oeh,
767: oe_transaction_types_all ota,
768: oe_transaction_types_tl otl,
769: mtl_sales_orders mso
770: where wfs.demand_source_line = oel.line_id --config line id
771: and oel.line_id = pLineId
822: into lReserveId
823: from mtl_reservations mr,
824: oe_order_lines_all oel,
825: oe_order_headers_all oeh,
826: oe_transaction_types_all ota,
827: oe_transaction_types_tl otl,
828: mtl_sales_orders mso
829: where mr.demand_source_line_id = oel.line_id --config line id
830: and oel.line_id = pLineId
934: select distinct reservation_id
935: from mtl_reservations mr,
936: oe_order_lines_all oel,
937: oe_order_headers_all oeh,
938: oe_transaction_types_all ota,
939: oe_transaction_types_tl otl,
940: mtl_sales_orders mso
941: where mr.demand_source_line_id = oel.line_id --config line id
942: and oel.line_id = lConfigLineId