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 1960: CURSOR l_txtrans_csr (p_book fa_book_controls.book_type_code%TYPE)

1956: FROM okl_txd_assets_v txd
1957: WHERE txd.asset_number = p_asset_num;
1958: -- Get the types of TAX BOOKS defined in the setup
1959: -- We get first for the Federal or state
1960: CURSOR l_txtrans_csr (p_book fa_book_controls.book_type_code%TYPE)
1961: IS
1962: SELECT trns.value,
1963: books.book_type_code
1964: FROM okl_sgn_translations trns,

Line 1965: fa_book_controls books

1961: IS
1962: SELECT trns.value,
1963: books.book_type_code
1964: FROM okl_sgn_translations trns,
1965: fa_book_controls books
1966: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
1967: AND trns.object1_id1 = books.book_type_code
1968: AND books.book_type_code = p_book;
1969: TYPE tax_book_value_rec IS RECORD(

Line 1966: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'

1962: SELECT trns.value,
1963: books.book_type_code
1964: FROM okl_sgn_translations trns,
1965: fa_book_controls books
1966: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
1967: AND trns.object1_id1 = books.book_type_code
1968: AND books.book_type_code = p_book;
1969: TYPE tax_book_value_rec IS RECORD(
1970: tax_book okl_txd_assets_b.tax_book%TYPE := NULL ,

Line 2083: FROM fa_book_controls

2079: */
2080: CURSOR get_rep_tax_csr(p_corp_book VARCHAR2)
2081: IS
2082: SELECT 'Y'
2083: FROM fa_book_controls
2084: WHERE book_class = 'TAX'
2085: AND mass_copy_source_book = p_corp_book
2086: AND book_type_code = OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_RPT_PROD_BOOK_TYPE_CODE);
2087:

Line 17674: fa_book_controls books

17670: IS
17671: SELECT trns.value,
17672: books.book_type_code
17673: FROM okl_sgn_translations trns,
17674: fa_book_controls books
17675: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
17676: AND trns.object1_id1 = books.book_type_code
17677: AND books.book_type_code = Book
17678: AND trns.sgn_code = 'STMP';

Line 17675: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'

17671: SELECT trns.value,
17672: books.book_type_code
17673: FROM okl_sgn_translations trns,
17674: fa_book_controls books
17675: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
17676: AND trns.object1_id1 = books.book_type_code
17677: AND books.book_type_code = Book
17678: AND trns.sgn_code = 'STMP';
17679: -- get the lease Line rule information

Line 22045: fa_book_controls books

22041: IS
22042: SELECT trns.value,
22043: books.book_type_code
22044: FROM okl_sgn_translations trns,
22045: fa_book_controls books
22046: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
22047: AND trns.object1_id1 = books.book_type_code
22048: AND trns.sgn_code = 'STMP'
22049: AND books.book_type_code = Book;

Line 22046: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'

22042: SELECT trns.value,
22043: books.book_type_code
22044: FROM okl_sgn_translations trns,
22045: fa_book_controls books
22046: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
22047: AND trns.object1_id1 = books.book_type_code
22048: AND trns.sgn_code = 'STMP'
22049: AND books.book_type_code = Book;
22050: -- Get the stream type id