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_QUICK_QUOTES_B

Line 195: SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b

191: AND ICPV.ID = p_version_id);
192:
193: -- cursor to fetch the maximum start date of quick quotes referencing Lease Rate Sets - When source is Item
194: CURSOR lrs_qq_csr_itm(p_version_id IN NUMBER) IS
195: SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b
196: WHERE rate_card_id IN (SELECT
197: LRFVERV.RATE_SET_ID LRS_ID
198: FROM
199: OKL_FE_ITEM_RESIDUAL IRHV

Line 217: SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b

213: AND ICPV.ID = p_version_id);
214:
215: -- cursor to fetch the maximum start date of quick quotes referencing Lease Rate Sets - When source is Item Category
216: CURSOR lrs_qq_csr_itm_cat(p_version_id IN NUMBER) IS
217: SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b
218: WHERE rate_card_id IN (SELECT
219: LRFVERV.RATE_SET_ID LRS_ID
220: FROM
221: OKL_FE_ITEM_RESIDUAL IRHV

Line 238: SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b

234: AND ICPV.ID = p_version_id);
235:
236: -- cursor to fetch the maximum start date of quick quotes referencing Lease Rate Sets - When source is Residual Category set
237: CURSOR lrs_qq_csr_rcs(p_version_id IN NUMBER) IS
238: SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b
239: WHERE rate_card_id IN (SELECT
240: LRFVERV.RATE_SET_ID LRS_ID
241: FROM
242: OKL_FE_ITEM_RESIDUAL IRHV