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_MASS_REBOOK_PVT dependencies on OKC_K_ITEMS_V

Line 308: l_query := l_query || 'EXISTS ( SELECT 1 FROM OKC_K_ITEMS_V ITEM, FA_BOOKS FB ';

304: l_asset_row := l_asset_row + 1;
305: l_asset_query_present := 'T';
306: l_query := l_query || l_clause || ' ';
307: IF (l_asset_row = 1) THEN -- First Asset Criteria
308: l_query := l_query || 'EXISTS ( SELECT 1 FROM OKC_K_ITEMS_V ITEM, FA_BOOKS FB ';
309: l_query := l_query || 'WHERE ITEM.JTOT_OBJECT1_CODE = '||''''||'OKX_ASSET'||'''';
310: l_query := l_query || ' AND ITEM.DNZ_CHR_ID = CON.ID ';
311: l_query := l_query || ' AND LINE.ID = ITEM.CLE_ID ';
312: l_query := l_query || ' AND ITEM.OBJECT1_ID1 = FB.ASSET_ID AND';

Line 347: l_query := l_query || ' EXISTS ( SELECT 1 FROM OKC_K_ITEMS_V ITEM, FA_ADDITIONS ASSET ';

343: l_asset_query_present := 'F';
344: END IF;
345:
346: l_query := l_query || l_clause || ' ';
347: l_query := l_query || ' EXISTS ( SELECT 1 FROM OKC_K_ITEMS_V ITEM, FA_ADDITIONS ASSET ';
348: l_query := l_query || 'WHERE ITEM.JTOT_OBJECT1_CODE = '||''''||'OKX_ASSET'||'''';
349: l_query := l_query || ' AND ITEM.DNZ_CHR_ID = CON.ID ';
350: l_query := l_query || ' AND LINE.ID = ITEM.CLE_ID ';
351: l_query := l_query || ' AND ITEM.OBJECT1_ID1 = ASSET.ASSET_ID ';

Line 1400: FROM okc_k_items_v

1396: WHERE id = p_fa_line_id);
1397:
1398: CURSOR unit_csr (p_fa_line_id NUMBER) IS
1399: SELECT number_of_items
1400: FROM okc_k_items_v
1401: WHERE cle_id = p_fa_line_id;
1402:
1403: CURSOR fa_line_csr (p_chr_id OKL_K_HEADERS_V.ID%TYPE,
1404: p_kle_id OKC_K_LINES_V.ID%TYPE) IS