APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 931: , oe_order_headers_all oh

927: , OKS_K_HEADERS_B sh
928: , mtl_parameters mprm
929: , okc_k_party_roles_b c
930: , okc_k_rel_objs ro
931: , oe_order_headers_all oh
932: -- inline view to select one conversion only per UOM code
933: -- Chooses the conversion rule with the lowest quantity
934: , (SELECT /*+ no_merge parallel(tcui) */
935: tcui.uom_code

Line 1500: (SELECT order_number from oe_order_headers_all where header_id = ro.object1_id1)

1496: , sh.Acct_rule_id
1497: , mprm.master_organization_id
1498: , TO_NUMBER(c.object1_id1) customer_party_id
1499: , CASE WHEN ro.object1_id1 is not null then
1500: (SELECT order_number from oe_order_headers_all where header_id = ro.object1_id1)
1501: END order_number
1502: , h.subsequent_renewal_type_code /* Added this colunm as a part of ER#5760744 */
1503: , sh.renewal_status negotiation_status /* Added this colunm as a part of ER#5950128 */
1504: , sh.rmndr_suppress_flag reminder /* Added this colunm as a part of ER#5950128 */

Line 2763: from oe_order_headers_all oehdr

2759: /* For line lelvel order number */
2760: ,CASE WHEN root_lty_code <> 'WARRANTY' then (
2761: /* rel objs has multiple entries for the same order number */
2762: Select oehdr.order_number order_number
2763: from oe_order_headers_all oehdr
2764: , oe_order_lines_all oelin
2765: , okc_k_rel_objs okcrel
2766: WHERE okcrel.object1_id1 = oelin.line_id
2767: AND oehdr.header_id = oelin.header_id

Line 5240: oe_order_headers_all oehdr

5236: , csi_item_instances cii
5237: , ( /* rel objs has multiple entries for the same order number */
5238: Select /*+ no_merge parallel(oehdr) parallel(oelin) parallel(okcrel) */ okcrel.cle_id,max(oehdr.order_number) order_number
5239: from
5240: oe_order_headers_all oehdr
5241: , oe_order_lines_all oelin
5242: , okc_k_rel_objs okcrel
5243: WHERE okcrel.object1_id1 = oelin.line_id
5244: AND oehdr.header_id = oelin.header_id