APPS.OKL_SPLIT_ASSET_PVT dependencies on OKX_AST_DST_HST_V

Line 3745: FROM okx_ast_dst_hst_v

3741: RETURN VARCHAR2 IS
3742: CURSOR fa_location_curs(p_asset_id IN VARCHAR2,
3743: p_book_type_code IN VARCHAR2) IS
3744: SELECT location_id
3745: FROM okx_ast_dst_hst_v
3746: WHERE asset_id = p_asset_id
3747: AND book_type_code = p_book_type_code
3748: AND status = 'A'
3749: AND NVL(start_date_active,SYSDATE) <= SYSDATE

Line 11045: FROM okx_ast_dst_hst_v

11041: location_id,
11042: p_units
11043: --p_txdv_rec.quantity
11044: --p_ast_line_rec.current_units
11045: FROM okx_ast_dst_hst_v
11046: WHERE asset_id = p_asset_id
11047: AND book_type_code = p_book_type_code
11048: AND transaction_header_id_out IS NULL
11049: AND retirement_id IS NULL;

Line 11643: FROM OKX_AST_DST_HST_V

11639: CURSOR l_dist_curs(p_asset_id IN NUMBER,
11640: p_corporate_book IN VARCHAR2) IS
11641: SELECT units_assigned,
11642: distribution_id
11643: FROM OKX_AST_DST_HST_V
11644: WHERE asset_id = p_ast_line_rec.asset_id
11645: AND book_type_code = p_ast_line_rec.corporate_book
11646: AND transaction_header_id_out IS NULL
11647: AND retirement_id IS NULL;

Line 11821: FROM OKX_AST_DST_HST_V

11817: CURSOR l_dist_curs(p_asset_id IN NUMBER,
11818: p_corporate_book IN VARCHAR2) IS
11819: SELECT units_assigned,
11820: distribution_id
11821: FROM OKX_AST_DST_HST_V
11822: WHERE asset_id = p_ast_line_rec.asset_id
11823: AND book_type_code = p_ast_line_rec.corporate_book
11824: AND transaction_header_id_out IS NULL
11825: AND retirement_id IS NULL;

Line 12224: FROM OKX_AST_DST_HST_V

12220: CURSOR l_dist_curs(p_asset_id IN NUMBER,
12221: p_corporate_book IN VARCHAR2) IS
12222: SELECT units_assigned,
12223: distribution_id
12224: FROM OKX_AST_DST_HST_V
12225: WHERE asset_id = p_ast_line_rec.asset_id
12226: AND book_type_code = p_ast_line_rec.corporate_book
12227: AND transaction_header_id_out IS NULL
12228: AND retirement_id IS NULL;