DBA Data[Home] [Help]

APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on OKC_K_REL_OBJS

Line 930: , okc_k_rel_objs ro

926: , gl_sets_of_books sob
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) */

Line 1658: , okc_k_rel_objs ro

1654: WHERE r = 1 ) h
1655: , oks_k_headers_b sh
1656: , mtl_parameters mprm
1657: , okc_k_party_roles_b c
1658: , okc_k_rel_objs ro
1659: , financials_system_params_all fsp
1660: , gl_sets_of_books sob
1661: -- inline view to select one conversion only per UOM code
1662: -- Chooses the conversion rule with the lowest quantity

Line 2765: , okc_k_rel_objs okcrel

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
2769: AND rownum=1 )

Line 5242: , okc_k_rel_objs okcrel

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
5246: ) oehdr