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.IGI_IAC_CREATE_ASSETS dependencies on IGI_IAC_ASSET_BALANCES

Line 83: FROM igi_iac_asset_balances

79: IF c_fully_reserved%FOUND THEN
80:
81: SELECT adjusted_cost
82: INTO l_adjusted_cost
83: FROM igi_iac_asset_balances
84: WHERE book_type_code = p_book
85: AND asset_id = p_asset_id
86: AND period_counter = (SELECT MAX(period_counter)
87: FROM igi_iac_asset_balances

Line 87: FROM igi_iac_asset_balances

83: FROM igi_iac_asset_balances
84: WHERE book_type_code = p_book
85: AND asset_id = p_asset_id
86: AND period_counter = (SELECT MAX(period_counter)
87: FROM igi_iac_asset_balances
88: WHERE book_type_code = p_book
89: AND asset_id = p_asset_id);
90:
91: CLOSE c_fully_reserved;

Line 97: FROM igi_iac_asset_balances

93: ELSE
94:
95: SELECT adjusted_cost
96: INTO l_adjusted_cost
97: FROM igi_iac_asset_balances
98: WHERE book_type_code = p_book
99: AND asset_id = p_asset_id
100: AND period_counter = p_period_counter;
101:

Line 115: FROM igi_iac_asset_balances

111: -- reserved
112:
113: SELECT adjusted_cost
114: INTO l_adjusted_cost
115: FROM igi_iac_asset_balances
116: WHERE book_type_code = p_book
117: AND asset_id = p_asset_id
118: AND period_counter = (SELECT MAX(period_counter)
119: FROM igi_iac_asset_balances

Line 119: FROM igi_iac_asset_balances

115: FROM igi_iac_asset_balances
116: WHERE book_type_code = p_book
117: AND asset_id = p_asset_id
118: AND period_counter = (SELECT MAX(period_counter)
119: FROM igi_iac_asset_balances
120: WHERE book_type_code = p_book
121: AND asset_id = p_asset_id);
122:
123: -- bug 3451539, end 3