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 952: , OE_ORDER_LINES_ALL OOL

948: , '#' id2
949: , CII.external_reference -- bug 4372877
950: FROM CSI_ITEM_INSTANCES CII
951: , CSI_INSTANCE_STATUSES CIS
952: , OE_ORDER_LINES_ALL OOL
953: , OKX_SYSTEM_ITEMS_V IT
954: WHERE CII.INSTANCE_ID = p_instance_id
955: AND CII.inventory_item_id = IT.id1
956: AND IT.serviceable_product_flag = 'Y'

Line 1448: OE_ORDER_LINES_ALL OOL,

1444: '#' id2,
1445: CII.external_reference -- bug 4372877
1446: FROM CSI_ITEM_INSTANCES CII,
1447: CSI_INSTANCE_STATUSES CIS,
1448: OE_ORDER_LINES_ALL OOL,
1449: OKX_SYSTEM_ITEMS_V IT
1450: WHERE CII.INSTANCE_ID = p_instance_id
1451: AND CII.inventory_item_id = IT.id1
1452: AND IT.serviceable_product_flag = 'Y'