DBA Data[Home] [Help]

APPS.OKC_XPRT_OM_INT_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 220: oe_order_headers_all oh

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;

Line 1158: FROM oe_order_headers_all

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

Line 1540: FROM oe_order_headers_all

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