DBA Data[Home] [Help]

APPS.OKL_AM_INVOICES_PVT dependencies on OE_ORDER_LINES_ALL

Line 2383: FROM oe_order_lines_all oli,

2379: 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.
2380: NULL set_of_books_id, -- derived from org_id
2381: NULL irm_id, -- defaulted in AR
2382: art.legal_entity_id
2383: FROM oe_order_lines_all oli,
2384: oe_order_headers_all ohe,
2385: okl_asset_returns_b art,
2386: okc_k_lines_v kle,
2387: okx_cust_site_uses_v csu

Line 2403: FROM oe_order_lines_all

2399:
2400: -- SECHAWLA 01-NOV-04 3967398 : get the remarketing inventory item id
2401: CURSOR l_orderlines_csr(cp_order_line_id IN NUMBER) IS
2402: SELECT inventory_item_id
2403: FROM oe_order_lines_all
2404: WHERE line_id = cp_order_line_id;
2405:
2406: -- SECHAWLA 01-NOV-04 3967398 : check the item invoiced option from the setup
2407: -- PAGARG 26-Jan-2005 Bug 4044659 Querying LEASE_INV_ORG_YN also.