APPS.OKL_SPLIT_ASSET_PVT dependencies on OKX_AST_DST_HST_V

Line 3773: FROM okx_ast_dst_hst_v

3769: RETURN VARCHAR2 IS
3770: CURSOR fa_location_curs(p_asset_id IN VARCHAR2,
3771: p_book_type_code IN VARCHAR2) IS
3772: SELECT location_id
3773: FROM okx_ast_dst_hst_v
3774: WHERE asset_id = p_asset_id
3775: AND book_type_code = p_book_type_code
3776: AND status = 'A'
3777: AND NVL(start_date_active,SYSDATE) <= SYSDATE

Line 11098: FROM okx_ast_dst_hst_v

11094: location_id,
11095: p_units
11096: --p_txdv_rec.quantity
11097: --p_ast_line_rec.current_units
11098: FROM okx_ast_dst_hst_v
11099: WHERE asset_id = p_asset_id
11100: AND book_type_code = p_book_type_code
11101: AND transaction_header_id_out IS NULL
11102: AND retirement_id IS NULL;

Line 11696: FROM OKX_AST_DST_HST_V

11692: CURSOR l_dist_curs(p_asset_id IN NUMBER,
11693: p_corporate_book IN VARCHAR2) IS
11694: SELECT units_assigned,
11695: distribution_id
11696: FROM OKX_AST_DST_HST_V
11697: WHERE asset_id = p_ast_line_rec.asset_id
11698: AND book_type_code = p_ast_line_rec.corporate_book
11699: AND transaction_header_id_out IS NULL
11700: AND retirement_id IS NULL;

Line 11874: FROM OKX_AST_DST_HST_V

11870: CURSOR l_dist_curs(p_asset_id IN NUMBER,
11871: p_corporate_book IN VARCHAR2) IS
11872: SELECT units_assigned,
11873: distribution_id
11874: FROM OKX_AST_DST_HST_V
11875: WHERE asset_id = p_ast_line_rec.asset_id
11876: AND book_type_code = p_ast_line_rec.corporate_book
11877: AND transaction_header_id_out IS NULL
11878: AND retirement_id IS NULL;

Line 12277: FROM OKX_AST_DST_HST_V

12273: CURSOR l_dist_curs(p_asset_id IN NUMBER,
12274: p_corporate_book IN VARCHAR2) IS
12275: SELECT units_assigned,
12276: distribution_id
12277: FROM OKX_AST_DST_HST_V
12278: WHERE asset_id = p_ast_line_rec.asset_id
12279: AND book_type_code = p_ast_line_rec.corporate_book
12280: AND transaction_header_id_out IS NULL
12281: AND retirement_id IS NULL;