APPS.OKC_XPRT_OM_INT_PVT dependencies on OE_BLANKET_HEADERS_ALL

Line 203: oe_blanket_headers_all bh

199: bhe.end_date_active
200: -- XY
201: FROM
202: oe_blanket_headers_ext bhe,
203: oe_blanket_headers_all bh
204: WHERE
205: bh.order_number = bhe.order_number
206: AND bh.header_id = p_doc_id;
207:

Line 260: oe_blanket_headers_all bh,

256: oh.minisite_id ,
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(+)

Line 1414: FROM oe_blanket_headers_all

1410: l_current_org_id NUMBER;
1411:
1412: CURSOR c_get_doc_org_id IS
1413: SELECT org_id
1414: FROM oe_blanket_headers_all
1415: WHERE header_id = p_doc_id
1416: AND p_doc_type = G_BSA_DOC_TYPE
1417:
1418: UNION ALL

Line 1475: -- Query OM tables oe_blanket_headers_all and oe_blanket_lines_all to retrieve values

1471: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1472: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'45: l_master_org_id: ' || l_master_org_id);
1473: END IF;
1474:
1475: -- Query OM tables oe_blanket_headers_all and oe_blanket_lines_all to retrieve values
1476: -- against variable codes sent in by calling contrtact expert API
1477:
1478: IF p_line_var_tbl.FIRST IS NOT NULL THEN
1479: FOR i IN p_line_var_tbl.FIRST..p_line_var_tbl.LAST LOOP

Line 1796: FROM oe_blanket_headers_all

1792: l_current_org_id NUMBER;
1793:
1794: CURSOR c_get_doc_org_id IS
1795: SELECT org_id
1796: FROM oe_blanket_headers_all
1797: WHERE header_id = p_doc_id
1798: AND p_doc_type = G_BSA_DOC_TYPE
1799:
1800: UNION ALL