DBA Data[Home] [Help]

APPS.OKL_AM_ASSET_DISPOSE_PVT dependencies on OE_ORDER_LINES_ALL

Line 3531: FROM oe_order_lines_all

3527:
3528: -- This cursor is used to get the information about all the line items corresponding to an Order
3529: CURSOR l_orderlines_csr(p_line_id NUMBER) IS -- -- SECHAWLA 21-OCT-04 3924244
3530: SELECT header_id, inventory_item_id, nvl(ordered_quantity,1) ordered_quantity, ship_from_org_id, unit_selling_price
3531: FROM oe_order_lines_all
3532: WHERE line_id = p_line_id;
3533:
3534: -- This curosr is used to get the financial asset id for an inventory item
3535: --Changed the cusrsor to use directly base tables instead uv for performance