DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PVT dependencies on OE_ORDER_LINES_ALL

Line 23: FROM oe_order_lines_all

19: IS
20: CURSOR l_csr_get_selling_price(p_order_line_id IN NUMBER )
21: IS
22: SELECT unit_selling_price
23: FROM oe_order_lines_all
24: WHERE line_id = p_order_line_id;
25:
26: l_selling_price NUMBER := 0;
27: BEGIN

Line 869: , OE_ORDER_LINES_ALL OOL

865: , '#' id2
866: , CII.external_reference -- bug 4372877
867: FROM CSI_ITEM_INSTANCES CII
868: , CSI_INSTANCE_STATUSES CIS
869: , OE_ORDER_LINES_ALL OOL
870: , OKX_SYSTEM_ITEMS_V IT
871: WHERE CII.INSTANCE_ID = p_instance_id
872: AND CII.inventory_item_id = IT.id1
873: AND IT.serviceable_product_flag = 'Y'