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 60: FROM igi_iac_asset_balances

56: IF c_fully_reserved%FOUND THEN
57:
58: SELECT adjusted_cost
59: INTO l_adjusted_cost
60: FROM igi_iac_asset_balances
61: WHERE book_type_code = p_book
62: AND asset_id = p_asset_id
63: AND period_counter = (SELECT MAX(period_counter)
64: FROM igi_iac_asset_balances

Line 64: FROM igi_iac_asset_balances

60: FROM igi_iac_asset_balances
61: WHERE book_type_code = p_book
62: AND asset_id = p_asset_id
63: AND period_counter = (SELECT MAX(period_counter)
64: FROM igi_iac_asset_balances
65: WHERE book_type_code = p_book
66: AND asset_id = p_asset_id);
67:
68: CLOSE c_fully_reserved;

Line 74: FROM igi_iac_asset_balances

70: ELSE
71:
72: SELECT adjusted_cost
73: INTO l_adjusted_cost
74: FROM igi_iac_asset_balances
75: WHERE book_type_code = p_book
76: AND asset_id = p_asset_id
77: AND period_counter = p_period_counter;
78:

Line 92: FROM igi_iac_asset_balances

88: -- reserved
89:
90: SELECT adjusted_cost
91: INTO l_adjusted_cost
92: FROM igi_iac_asset_balances
93: WHERE book_type_code = p_book
94: AND asset_id = p_asset_id
95: AND period_counter = (SELECT MAX(period_counter)
96: FROM igi_iac_asset_balances

Line 96: FROM igi_iac_asset_balances

92: FROM igi_iac_asset_balances
93: WHERE book_type_code = p_book
94: AND asset_id = p_asset_id
95: AND period_counter = (SELECT MAX(period_counter)
96: FROM igi_iac_asset_balances
97: WHERE book_type_code = p_book
98: AND asset_id = p_asset_id);
99:
100: -- bug 3451539, end 3