257: -- End: Added for resolving bug 5300044 and 5299978
258: pl.name price_list_name --6899074
259: FROM
260: oe_blanket_headers_all bh,
261: oe_order_headers_all oh,
262: qp_list_headers_tl pl
263: WHERE
264: oh.blanket_number = bh.order_number(+)
265: AND bh.sales_document_type_code(+) = 'B'
1417:
1418: UNION ALL
1419:
1420: SELECT org_id
1421: FROM oe_order_headers_all
1422: WHERE header_id = p_doc_id
1423: AND p_doc_type = G_SO_DOC_TYPE;
1424:
1425: BEGIN
1799:
1800: UNION ALL
1801:
1802: SELECT org_id
1803: FROM oe_order_headers_all
1804: WHERE header_id = p_doc_id
1805: AND p_doc_type = G_SO_DOC_TYPE;
1806:
1807: --AK