DBA Data[Home] [Help]

APPS.OKL_AM_INVOICES_PVT dependencies on OE_ORDER_LINES_ALL

Line 2277: FROM oe_order_lines_all oli,

2273: NVL(oli.ship_from_org_id, ohe.ship_from_org_id) ship_from_org_id, -- rmunjulu Bug 3985369 Get Ship_From_Org_Id which will be passed to inventory_org_id when creating a invoice transaction.
2274: NULL set_of_books_id, -- derived from org_id
2275: NULL irm_id, -- defaulted in AR
2276: art.legal_entity_id
2277: FROM oe_order_lines_all oli,
2278: oe_order_headers_all ohe,
2279: okl_asset_returns_b art,
2280: okc_k_lines_v kle,
2281: okx_cust_site_uses_v csu

Line 2297: FROM oe_order_lines_all

2293:
2294: -- SECHAWLA 01-NOV-04 3967398 : get the remarketing inventory item id
2295: CURSOR l_orderlines_csr(cp_order_line_id IN NUMBER) IS
2296: SELECT inventory_item_id
2297: FROM oe_order_lines_all
2298: WHERE line_id = cp_order_line_id;
2299:
2300: -- SECHAWLA 01-NOV-04 3967398 : check the item invoiced option from the setup
2301: -- PAGARG 26-Jan-2005 Bug 4044659 Querying LEASE_INV_ORG_YN also.