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.JA_CN_FA_BI_EXPORT_PKG dependencies on FA_DEPRN_PERIODS

Line 85: FROM fa_deprn_periods fdp

81: WHERE fdh.asset_id = fth.asset_id
82: AND fth.transaction_type_code NOT IN ('FULL RETIREMENT')
83: AND EXISTS
84: (SELECT fdp.period_close_date
85: FROM fa_deprn_periods fdp
86: WHERE fdp.book_type_code = fbcs.book_type_code
87: AND fdp.calendar_period_close_date BETWEEN ld_start_date AND
88: ld_end_date
89: AND fdp.period_close_date IS NOT NULL)

Line 92: FROM fa_deprn_periods fdp

88: ld_end_date
89: AND fdp.period_close_date IS NOT NULL)
90: AND fdh.date_effective <
91: nvl((SELECT MAX(fdp.period_close_date)
92: FROM fa_deprn_periods fdp
93: WHERE fdp.book_type_code = fbcs.book_type_code
94: AND fdp.calendar_period_close_date <= ld_end_date
95: AND fdp.period_close_date IS NOT NULL),
96: SYSDATE)

Line 99: FROM fa_deprn_periods fdp

95: AND fdp.period_close_date IS NOT NULL),
96: SYSDATE)
97: AND (fdh.date_ineffective >
98: nvl((SELECT MAX(fdp.period_close_date)
99: FROM fa_deprn_periods fdp
100: WHERE fdp.book_type_code = fbcs.book_type_code
101: AND fdp.calendar_period_close_date <= ld_end_date
102: AND fdp.period_close_date IS NOT NULL),
103: SYSDATE) OR fdh.date_ineffective IS NULL)

Line 133: FROM fa_deprn_periods fdp

129: WHERE fdh.asset_id = fth.asset_id
130: AND fth.transaction_type_code NOT IN ('FULL RETIREMENT')
131: AND EXISTS
132: (SELECT fdp.period_close_date
133: FROM fa_deprn_periods fdp
134: WHERE fdp.book_type_code = fbcs.book_type_code
135: AND fdp.calendar_period_close_date BETWEEN ld_start_date AND
136: ld_end_date
137: AND fdp.period_close_date IS NOT NULL)

Line 140: FROM fa_deprn_periods fdp

136: ld_end_date
137: AND fdp.period_close_date IS NOT NULL)
138: AND fdh.date_effective <
139: nvl((SELECT MAX(fdp.period_close_date)
140: FROM fa_deprn_periods fdp
141: WHERE fdp.book_type_code = fbcs.book_type_code
142: AND fdp.calendar_period_close_date <= ld_end_date
143: AND fdp.period_close_date IS NOT NULL),
144: SYSDATE)

Line 147: FROM fa_deprn_periods fdp

143: AND fdp.period_close_date IS NOT NULL),
144: SYSDATE)
145: AND (fdh.date_ineffective >
146: nvl((SELECT MAX(fdp.period_close_date)
147: FROM fa_deprn_periods fdp
148: WHERE fdp.book_type_code = fbcs.book_type_code
149: AND fdp.calendar_period_close_date <= ld_end_date
150: AND fdp.period_close_date IS NOT NULL),
151: SYSDATE) OR fdh.date_ineffective IS NULL)

Line 181: FROM fa_deprn_periods fdp

177: WHERE fdh.asset_id = fth.asset_id
178: AND fth.transaction_type_code NOT IN ('FULL RETIREMENT')
179: AND EXISTS
180: (SELECT fdp.period_close_date
181: FROM fa_deprn_periods fdp
182: WHERE fdp.book_type_code = fbcs.book_type_code
183: AND fdp.calendar_period_close_date BETWEEN ld_start_date AND
184: ld_end_date
185: AND fdp.period_close_date IS NOT NULL)

Line 188: FROM fa_deprn_periods fdp

184: ld_end_date
185: AND fdp.period_close_date IS NOT NULL)
186: AND fdh.date_effective <
187: nvl((SELECT MAX(fdp.period_close_date)
188: FROM fa_deprn_periods fdp
189: WHERE fdp.book_type_code = fbcs.book_type_code
190: AND fdp.calendar_period_close_date <= ld_end_date
191: AND fdp.period_close_date IS NOT NULL),
192: SYSDATE)

Line 195: FROM fa_deprn_periods fdp

191: AND fdp.period_close_date IS NOT NULL),
192: SYSDATE)
193: AND (fdh.date_ineffective >
194: nvl((SELECT MAX(fdp.period_close_date)
195: FROM fa_deprn_periods fdp
196: WHERE fdp.book_type_code = fbcs.book_type_code
197: AND fdp.calendar_period_close_date <= ld_end_date
198: AND fdp.period_close_date IS NOT NULL),
199: SYSDATE) OR fdh.date_ineffective IS NULL)