APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OE_ORDER_LINES_ALL

Line 18980: FROM oe_order_lines_all

18976:
18977: -- get the inventory item from the sales order
18978: CURSOR l_oeorderlines_csr(cp_line_id IN NUMBER) IS
18979: SELECT inventory_item_id, ship_from_org_id, ship_to_org_id
18980: FROM oe_order_lines_all
18981: WHERE line_id = cp_line_id;
18982:
18983: -- get the inventory item id and inventory item org for a financial asset
18984: CURSOR l_invitem_csr(cp_fin_asset_id IN NUMBER) IS

Line 19351: -- ship_to_org_id from oe_order_lines_all is the site_use_id value from hz_cust_site_uses_all

19347: END IF;
19348:
19349: OPEN l_oeorderlines_csr(l_billingdtls_rec.isl_id);
19350: FETCH l_oeorderlines_csr INTO l_inv_item_id, l_inv_item_org_id, lx_ship_to_siteuseid;
19351: -- ship_to_org_id from oe_order_lines_all is the site_use_id value from hz_cust_site_uses_all
19352: -- which is the ship_to_site_use_id
19353: IF l_oeorderlines_csr%NOTFOUND THEN
19354: OKC_API.set_message( p_app_name => 'OKC',
19355: p_msg_name => G_INVALID_VALUE,