DBA Data[Home] [Help]

APPS.OE_DEMAND_STREAM_PROCESSOR dependencies on SO_LINE_DETAILS

Line 209: from so_line_details_interface

205: and original_system_reference = x_original_system_reference
206: and nvl(request_id, -99999) = nvl(x_request_id, nvl(request_id, -99999));
207:
208: delete
209: from so_line_details_interface
210: where order_source_id = x_order_source_id
211: and original_system_reference = x_original_system_reference
212: and nvl(request_id, -99999) = nvl(x_request_id, nvl(request_id, -99999));
213:

Line 279: so_line_details det,

275: SELECT
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 (+)

Line 651: FROM so_line_details

647: begin
648:
649: SELECT 'Y'
650: INTO l_scheduling_exists
651: FROM so_line_details
652: WHERE line_id in
653: (
654: SELECT line_id
655: FROM so_lines