216: -- End: Added for resolving bug 5300044 and 5299978
217:
218: FROM
219: oe_blanket_headers_all bh,
220: oe_order_headers_all oh
221: WHERE
222: oh.blanket_number = bh.order_number(+)
223: AND bh.sales_document_type_code(+) = 'B'
224: AND oh.header_id = p_doc_id;
1154:
1155: UNION ALL
1156:
1157: SELECT org_id
1158: FROM oe_order_headers_all
1159: WHERE header_id = p_doc_id
1160: AND p_doc_type = G_SO_DOC_TYPE;
1161:
1162: BEGIN
1536:
1537: UNION ALL
1538:
1539: SELECT org_id
1540: FROM oe_order_headers_all
1541: WHERE header_id = p_doc_id
1542: AND p_doc_type = G_SO_DOC_TYPE;
1543:
1544: --AK