APPS.OE_DEMAND_STREAM_PROCESSOR dependencies on SO_LINES

Line 203: from so_lines_interface

199: ) is
200: begin
201:
202: delete
203: from so_lines_interface
204: where order_source_id = x_order_source_id
205: and original_system_reference = x_original_system_reference
206: and nvl(request_id, -99999) = nvl(x_request_id, nvl(request_id, -99999));
207:

Line 280: so_lines lin

276: lin.line_id,
277: det.line_detail_id
278: FROM
279: so_line_details det,
280: so_lines lin
281: WHERE
282: Nvl(det.released_flag, 'N') = 'N'
283: AND lin.line_id = det.line_id (+)
284: AND Decode(lin.s27, -- Manufacturing Release

Line 441: so_lines

437: Nvl(MAX(line_number), 0) + 1
438: INTO
439: x_line_number
440: FROM
441: so_lines
442: WHERE
443: header_id = x_header_id
444: AND shipment_schedule_line_id IS NULL
445: AND parent_line_id IS NULL

Line 655: FROM so_lines

651: FROM so_line_details
652: WHERE line_id in
653: (
654: SELECT line_id
655: FROM so_lines
656: WHERE (line_id = x_line_id
657: OR parent_line_id = x_line_id)
658: )
659: AND schedule_status_code is NOT NULL