DBA Data[Home] [Help]

APPS.OKL_PROPERTY_TAX_STATEMENT_PVT dependencies on OKL_PROPERTY_TAX_V

Line 104: okl_property_tax_v ptv,

100: okc_k_headers_b khr,
101: okl_k_headers khl,
102: okl_k_lines_full_v asset,
103: okc_line_styles_b ls,
104: okl_property_tax_v ptv,
105: okc_k_lines_b kle,
106: okc_statuses_b khs,
107: okc_statuses_b kls
108: WHERE ste.amount <> 0

Line 126: AND ste.source_table = 'OKL_PROPERTY_TAX_V'

122: AND asset.id = cp_kle_id
123: AND ls.id = asset.lse_id
124: AND ls.lty_code = 'FREE_FORM1'
125: AND ptv.id = ste.source_id
126: AND ste.source_table = 'OKL_PROPERTY_TAX_V'
127: AND khl.id = stm.khr_id
128: AND khl.deal_type IS NOT NULL
129: AND khs.code = khr.sts_code
130: -- AND khs.ste_code = 'ACTIVE'