DBA Data[Home] [Help]

APPS.OKL_AM_ASSET_DISPOSE_PVT dependencies on OE_ORDER_LINES_ALL

Line 3523: FROM oe_order_lines_all

3519:
3520: -- This cursor is used to get the information about all the line items corresponding to an Order
3521: CURSOR l_orderlines_csr(p_line_id NUMBER) IS -- -- SECHAWLA 21-OCT-04 3924244
3522: SELECT header_id, inventory_item_id, nvl(ordered_quantity,1) ordered_quantity, ship_from_org_id, unit_selling_price
3523: FROM oe_order_lines_all
3524: WHERE line_id = p_line_id;
3525:
3526: -- This curosr is used to get the financial asset id for an inventory item
3527: --Changed the cusrsor to use directly base tables instead uv for performance