eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ITEM_RESIDUALS_PVT dependencies on OKL_LEASE_QUOTES_B

Line 132: SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b

128: l_calc_date2 DATE := NULL;
129:
130: -- cursor to fetch the maximum start date of lease quotes referencing Lease Rate Sets - When source is Item
131: CURSOR lrs_lq_csr_itm(p_version_id IN NUMBER) IS
132: SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b
133: WHERE rate_card_id IN(SELECT
134: LRFVERV.RATE_SET_ID LRS_ID
135: FROM
136: OKL_FE_ITEM_RESIDUAL IRHV

Line 154: SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b

150: AND ICPV.ID = p_version_id);
151:
152: -- cursor to fetch the maximum start date of lease quotes referencing Lease Rate Sets - When source is Item Category
153: CURSOR lrs_lq_csr_itm_cat(p_version_id IN NUMBER) IS
154: SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b
155: WHERE rate_card_id IN(SELECT
156: LRFVERV.RATE_SET_ID LRS_ID
157: FROM
158: OKL_FE_ITEM_RESIDUAL IRHV

Line 175: SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b

171: AND ICPV.ID = p_version_id);
172:
173: -- cursor to fetch the maximum start date of lease quotes referencing Lease Rate Sets - When source is Residual Category set
174: CURSOR lrs_lq_csr_rcs(p_version_id IN NUMBER) IS
175: SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b
176: WHERE rate_card_id IN(SELECT
177: LRFVERV.RATE_SET_ID LRS_ID
178: FROM
179: OKL_FE_ITEM_RESIDUAL IRHV