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.FA_MASSADD_CREATE_PKG dependencies on FA_CATEGORY_ACCOUNTS_GT

Line 125: insert into fa_category_accounts_gt

121:
122: /*fa_categories table code added for Bug:10028857*/
123: if (l_count = 1) then
124:
125: insert into fa_category_accounts_gt
126: (clearing_acct
127: ,book_type_code
128: ,asset_type)
129: select clearing_acct

Line 154: insert into fa_category_accounts_gt

150: group by clearing_acct, book_type_code;
151:
152: else
153:
154: insert into fa_category_accounts_gt
155: (clearing_acct
156: ,book_type_code
157: ,asset_type)
158: select clearing_acct

Line 200: ,'fa_category_accounts_gt'

196: ,to_char(l_count)
197: ,p_log_level_rec => g_log_level_rec);
198: fa_debug_pkg.add(l_calling_fn
199: ,'Deleting duplicate rows from '
200: ,'fa_category_accounts_gt'
201: ,p_log_level_rec => g_log_level_rec);
202: end if;
203:
204: -- purge any duplicates from other books

Line 209: from fa_category_accounts_gt gt1

205: -- this will result in FIFO processing if accounts
206: -- are not unique across books!!!!
207:
208: delete
209: from fa_category_accounts_gt gt1
210: where gt1.book_type_code <> p_book_type_code
211: and exists
212: (select /*+ index (gt2 FA_CATEGORY_ACCOUNTS_GT_N1) */ 1
213: from fa_category_accounts_gt gt2

Line 212: (select /+ index (gt2 FA_CATEGORY_ACCOUNTS_GT_N1) / 1

208: delete
209: from fa_category_accounts_gt gt1
210: where gt1.book_type_code <> p_book_type_code
211: and exists
212: (select /*+ index (gt2 FA_CATEGORY_ACCOUNTS_GT_N1) */ 1
213: from fa_category_accounts_gt gt2
214: where gt2.book_type_code = p_book_type_code
215: and gt2.clearing_acct = gt1.clearing_acct);
216:

Line 213: from fa_category_accounts_gt gt2

209: from fa_category_accounts_gt gt1
210: where gt1.book_type_code <> p_book_type_code
211: and exists
212: (select /*+ index (gt2 FA_CATEGORY_ACCOUNTS_GT_N1) */ 1
213: from fa_category_accounts_gt gt2
214: where gt2.book_type_code = p_book_type_code
215: and gt2.clearing_acct = gt1.clearing_acct);
216:
217: l_count := SQL%ROWCOUNT;

Line 226: ,'fa_category_accounts_gt'

222: ,to_char(l_count)
223: ,p_log_level_rec => g_log_level_rec);
224: fa_debug_pkg.add(l_calling_fn
225: ,'Deleting duplicate other book rows from '
226: ,'fa_category_accounts_gt'
227: ,p_log_level_rec => g_log_level_rec);
228: end if;
229:
230: delete

Line 231: from fa_category_accounts_gt gt1

227: ,p_log_level_rec => g_log_level_rec);
228: end if;
229:
230: delete
231: from fa_category_accounts_gt gt1
232: where not exists
233: (select /*+ index (gt2 FA_CATEGORY_ACCOUNTS_GT_N1) */ 1
234: from fa_category_accounts_gt gt2
235: where gt2.book_type_code = p_book_type_code

Line 233: (select /+ index (gt2 FA_CATEGORY_ACCOUNTS_GT_N1) / 1

229:
230: delete
231: from fa_category_accounts_gt gt1
232: where not exists
233: (select /*+ index (gt2 FA_CATEGORY_ACCOUNTS_GT_N1) */ 1
234: from fa_category_accounts_gt gt2
235: where gt2.book_type_code = p_book_type_code
236: and gt2.clearing_acct = gt1.clearing_acct)
237: and gt1.rowid <>

Line 234: from fa_category_accounts_gt gt2

230: delete
231: from fa_category_accounts_gt gt1
232: where not exists
233: (select /*+ index (gt2 FA_CATEGORY_ACCOUNTS_GT_N1) */ 1
234: from fa_category_accounts_gt gt2
235: where gt2.book_type_code = p_book_type_code
236: and gt2.clearing_acct = gt1.clearing_acct)
237: and gt1.rowid <>
238: (select min(rowid)

Line 239: from fa_category_accounts_gt gt3

235: where gt2.book_type_code = p_book_type_code
236: and gt2.clearing_acct = gt1.clearing_acct)
237: and gt1.rowid <>
238: (select min(rowid)
239: from fa_category_accounts_gt gt3
240: where gt3.clearing_acct = gt1.clearing_acct);
241:
242: l_count := SQL%ROWCOUNT;
243: if (g_log_level_rec.statement_level) then

Line 799: (select /+ index(fca FA_CATEGORY_ACCOUNTS_GT_N2 /

795: /*code for second decode changed for Bug:10028857*/
796: l_sql := '
797: update fa_mass_additions_gt gt
798: set (asset_type, line_status, book_type_code, mass_addition_id) =
799: (select /*+ index(fca FA_CATEGORY_ACCOUNTS_GT_N2 */
800: decode(gt.asset_type,
801: null, decode(glcc.account_type,
802: ''E'', ''EXPENSED'',
803: nvl(fca.asset_type, gt.asset_type)),

Line 826: fa_category_accounts_gt fca

822: null),
823: gt.book_type_code)),
824: :mass_add_id
825: from gl_code_combinations glcc,
826: fa_category_accounts_gt fca
827: where gt.payables_code_combination_id = glcc.code_combination_id
828: and fca.clearing_acct(+) = ' ||
829: ' glcc.' || p_column_name || '
830: )