APPS.OE_DEMAND_STREAM_PROCESSOR dependencies on SO_HEADERS

Line 71: so_headers soh,

67: x_open_flag,
68: x_entry_status,
69: x_po_number
70: FROM
71: so_headers soh,
72: so_order_types sot
73: WHERE
74: sot.order_type_id = soh.order_type_id
75: AND sot.name = x_order_type_name

Line 164: so_headers soh,

160: x_open_flag,
161: x_entry_status,
162: x_po_number
163: FROM
164: so_headers soh,
165: so_order_types sot
166: WHERE
167: sot.order_type_id = soh.order_type_id
168: AND soh.header_id = x_header_id;

Line 233: from so_headers_interface

229: and original_system_reference = x_original_system_reference
230: and nvl(request_id, -99999) = nvl(x_request_id, nvl(request_id, -99999));
231:
232: delete
233: from so_headers_interface
234: where order_source_id = x_order_source_id
235: and original_system_reference = x_original_system_reference
236: and nvl(request_id, -99999) = nvl(x_request_id, nvl(request_id, -99999));
237:

Line 510: so_headers

506:
507: SELECT original_system_source_code, original_system_reference
508: INTO l_original_system_source_code, l_original_system_reference
509: FROM
510: so_headers
511: WHERE
512: header_id = x_header_id
513: FOR UPDATE OF
514: original_system_source_code;

Line 543: so_headers h,

539: INTO
540: l_order_number,
541: l_order_type
542: FROM
543: so_headers h,
544: so_order_types t
545: WHERE
546: h.order_type_id = t.order_type_id
547: AND h.header_id = x_header_id;

Line 576: UPDATE so_headers

572: -- interfaces lines into a copied order, they no longer want to track
573: -- the original order that the header was copied from
574: --
575:
576: UPDATE so_headers
577: SET original_system_source_code = l_original_system_source_code,
578: original_system_reference = l_original_system_reference,
579: source_header_id = NULL
580: WHERE

Line 584: FROM so_headers

580: WHERE
581: header_id = x_header_id
582: AND not exists
583: (SELECT 'x'
584: FROM so_headers
585: WHERE original_system_reference = l_original_system_reference
586: AND original_system_source_code = l_original_system_source_code);
587:
588: IF SQL%NOTFOUND THEN