DBA Data[Home] [Help]

APPS.OKL_LIKE_KIND_EXCHANGE_PVT dependencies on OKX_AST_DST_HST_V

Line 128: FROM okx_ast_dst_hst_v

124: x_location_id OUT NOCOPY NUMBER) RETURN VARCHAR2 IS
125: CURSOR fa_location_curs(p_asset_id IN VARCHAR2,
126: p_book_type_code IN VARCHAR2) is
127: SELECT location_id
128: FROM okx_ast_dst_hst_v
129: WHERE asset_id = p_asset_id
130: AND book_type_code = p_book_type_code
131: AND status = 'A'
132: AND nvl(start_date_active,sysdate) <= sysdate

Line 329: from okx_ast_dst_hst_v

325: into l_asset_dist_rec.units_assigned,
326: l_asset_dist_rec.assigned_to,
327: l_asset_dist_rec.expense_ccid,
328: l_asset_dist_rec.location_ccid
329: from okx_ast_dst_hst_v
330: where asset_id = p_asdt_rec.asset_id
331: and book_type_code = p_txlv_rec.corporate_book
332: and transaction_header_id_out is null
333: and retirement_id is not null