APPS.OKC_XPRT_OM_INT_PVT dependencies on OE_BLANKET_HEADERS_ALL

Line 163: oe_blanket_headers_all bh

159: bhe.end_date_active
160: -- XY
161: FROM
162: oe_blanket_headers_ext bhe,
163: oe_blanket_headers_all bh
164: WHERE
165: bh.order_number = bhe.order_number
166: AND bh.header_id = p_doc_id;
167:

Line 219: oe_blanket_headers_all bh,

215: oh.minisite_id
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'

Line 1151: FROM oe_blanket_headers_all

1147: l_current_org_id NUMBER;
1148:
1149: CURSOR c_get_doc_org_id IS
1150: SELECT org_id
1151: FROM oe_blanket_headers_all
1152: WHERE header_id = p_doc_id
1153: AND p_doc_type = G_BSA_DOC_TYPE
1154:
1155: UNION ALL

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

1208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1209: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'45: l_master_org_id: ' || l_master_org_id);
1210: END IF;
1211:
1212: -- Query OM tables oe_blanket_headers_all and oe_blanket_lines_all to retrieve values
1213: -- against variable codes sent in by calling contrtact expert API
1214:
1215: IF p_line_var_tbl.FIRST IS NOT NULL THEN
1216: FOR i IN p_line_var_tbl.FIRST..p_line_var_tbl.LAST LOOP

Line 1533: FROM oe_blanket_headers_all

1529: l_current_org_id NUMBER;
1530:
1531: CURSOR c_get_doc_org_id IS
1532: SELECT org_id
1533: FROM oe_blanket_headers_all
1534: WHERE header_id = p_doc_id
1535: AND p_doc_type = G_BSA_DOC_TYPE
1536:
1537: UNION ALL