DBA Data[Home] [Help]

APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on OE_ORDER_LINES_ALL

Line 2764: , oe_order_lines_all oelin

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
2768: AND okcrel.cle_id = l.id

Line 5241: , oe_order_lines_all oelin

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
5245: group by okcrel.cle_id