DBA Data[Home] [Help]

APPS.OKL_DEAL_CHARGES_PVT dependencies on OKC_K_LINES_TL

Line 21: asset_number OKC_K_LINES_TL.name%TYPE,

17: -------------------------------------------------------------------------------------------------
18:
19: TYPE asset_rec_type IS RECORD (fin_asset_id OKC_K_LINES_B.id%TYPE,
20: amount OKL_K_LINES.amount%TYPE,
21: asset_number OKC_K_LINES_TL.name%TYPE,
22: description OKC_K_LINES_TL.item_description%TYPE,
23: oec OKL_K_LINES.oec%TYPE,
24: cleb_cov_asset_id OKC_K_LINES_B.id%TYPE,
25: cim_cov_asset_id OKC_K_ITEMS.id%TYPE);

Line 22: description OKC_K_LINES_TL.item_description%TYPE,

18:
19: TYPE asset_rec_type IS RECORD (fin_asset_id OKC_K_LINES_B.id%TYPE,
20: amount OKL_K_LINES.amount%TYPE,
21: asset_number OKC_K_LINES_TL.name%TYPE,
22: description OKC_K_LINES_TL.item_description%TYPE,
23: oec OKL_K_LINES.oec%TYPE,
24: cleb_cov_asset_id OKC_K_LINES_B.id%TYPE,
25: cim_cov_asset_id OKC_K_ITEMS.id%TYPE);
26:

Line 84: okc_k_lines_tl clet_fin,

80: clet_fin.name asset_number,
81: clet_fin.item_description description,
82: NVL(kle_fin.oec,0) oec
83: FROM okc_k_lines_b cleb_fin,
84: okc_k_lines_tl clet_fin,
85: okl_k_lines kle_fin,
86: okc_line_styles_b lse_fin,
87: okc_statuses_b sts
88: WHERE cleb_fin.dnz_chr_id = p_chr_id