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_LA_STREAM_PVT dependencies on FA_BOOK_CONTROLS

Line 1939: CURSOR l_txtrans_csr (p_book fa_book_controls.book_type_code%TYPE)

1935: FROM okl_txd_assets_v txd
1936: WHERE txd.asset_number = p_asset_num;
1937: -- Get the types of TAX BOOKS defined in the setup
1938: -- We get first for the Federal or state
1939: CURSOR l_txtrans_csr (p_book fa_book_controls.book_type_code%TYPE)
1940: IS
1941: SELECT trns.value,
1942: books.book_type_code
1943: FROM okl_sgn_translations trns,

Line 1944: fa_book_controls books

1940: IS
1941: SELECT trns.value,
1942: books.book_type_code
1943: FROM okl_sgn_translations trns,
1944: fa_book_controls books
1945: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
1946: AND trns.object1_id1 = books.book_type_code
1947: AND books.book_type_code = p_book;
1948: TYPE tax_book_value_rec IS RECORD(

Line 1945: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'

1941: SELECT trns.value,
1942: books.book_type_code
1943: FROM okl_sgn_translations trns,
1944: fa_book_controls books
1945: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
1946: AND trns.object1_id1 = books.book_type_code
1947: AND books.book_type_code = p_book;
1948: TYPE tax_book_value_rec IS RECORD(
1949: tax_book okl_txd_assets_b.tax_book%TYPE := NULL ,

Line 2062: FROM fa_book_controls

2058: */
2059: CURSOR get_rep_tax_csr(p_corp_book VARCHAR2)
2060: IS
2061: SELECT 'Y'
2062: FROM fa_book_controls
2063: WHERE book_class = 'TAX'
2064: AND mass_copy_source_book = p_corp_book
2065: AND book_type_code = OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_RPT_PROD_BOOK_TYPE_CODE);
2066:

Line 20312: fa_book_controls books

20308: IS
20309: SELECT trns.value,
20310: books.book_type_code
20311: FROM okl_sgn_translations trns,
20312: fa_book_controls books
20313: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
20314: AND trns.object1_id1 = books.book_type_code
20315: AND books.book_type_code = Book
20316: AND trns.sgn_code = 'STMP';

Line 20313: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'

20309: SELECT trns.value,
20310: books.book_type_code
20311: FROM okl_sgn_translations trns,
20312: fa_book_controls books
20313: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
20314: AND trns.object1_id1 = books.book_type_code
20315: AND books.book_type_code = Book
20316: AND trns.sgn_code = 'STMP';
20317: -- get the lease Line rule information

Line 24888: fa_book_controls books

24884: IS
24885: SELECT trns.value,
24886: books.book_type_code
24887: FROM okl_sgn_translations trns,
24888: fa_book_controls books
24889: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
24890: AND trns.object1_id1 = books.book_type_code
24891: AND trns.sgn_code = 'STMP'
24892: AND books.book_type_code = Book;

Line 24889: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'

24885: SELECT trns.value,
24886: books.book_type_code
24887: FROM okl_sgn_translations trns,
24888: fa_book_controls books
24889: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
24890: AND trns.object1_id1 = books.book_type_code
24891: AND trns.sgn_code = 'STMP'
24892: AND books.book_type_code = Book;
24893: -- Get the stream type id