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 168: insert into fa_category_accounts_gt

164:
165: -- load the category gt
166: if (l_count = 1) then
167:
168: insert into fa_category_accounts_gt
169: (clearing_acct
170: ,book_type_code
171: ,asset_type)
172: select clearing_acct

Line 191: insert into fa_category_accounts_gt

187: group by clearing_acct, book_type_code;
188:
189: else
190:
191: insert into fa_category_accounts_gt
192: (clearing_acct
193: ,book_type_code
194: ,asset_type)
195: select clearing_acct

Line 222: DebugLog( 'Deleting duplicate rows from ', 'fa_category_accounts_gt' );

218: end if;
219:
220: l_count := SQL%ROWCOUNT;
221: DebugLog( 'No of Records Inserted ', to_char(l_count));
222: DebugLog( 'Deleting duplicate rows from ', 'fa_category_accounts_gt' );
223:
224:
225: savepoint FAMADC_preprocess2;
226:

Line 232: from fa_category_accounts_gt gt1

228: -- this will result in FIFO processing if accounts
229: -- are not unique across books!!!!
230:
231: delete
232: from fa_category_accounts_gt gt1
233: where gt1.book_type_code <> p_book_type_code
234: and exists
235: (select /*+ index (gt2 FA_CATEGORY_ACCOUNTS_GT_N1) */ 1
236: from fa_category_accounts_gt gt2

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

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

Line 236: from fa_category_accounts_gt gt2

232: from fa_category_accounts_gt gt1
233: where gt1.book_type_code <> p_book_type_code
234: and exists
235: (select /*+ index (gt2 FA_CATEGORY_ACCOUNTS_GT_N1) */ 1
236: from fa_category_accounts_gt gt2
237: where gt2.book_type_code = p_book_type_code
238: and gt2.clearing_acct = gt1.clearing_acct);
239:
240: l_count := SQL%ROWCOUNT;

Line 242: DebugLog( 'Deleting duplicate other book rows from ', 'fa_category_accounts_gt' );

238: and gt2.clearing_acct = gt1.clearing_acct);
239:
240: l_count := SQL%ROWCOUNT;
241: DebugLog( 'No of Records Deleted ', to_char(l_count));
242: DebugLog( 'Deleting duplicate other book rows from ', 'fa_category_accounts_gt' );
243:
244:
245: delete
246: from fa_category_accounts_gt gt1

Line 246: from fa_category_accounts_gt gt1

242: DebugLog( 'Deleting duplicate other book rows from ', 'fa_category_accounts_gt' );
243:
244:
245: delete
246: from fa_category_accounts_gt gt1
247: where not exists
248: (select /*+ index (gt2 FA_CATEGORY_ACCOUNTS_GT_N1) */ 1
249: from fa_category_accounts_gt gt2
250: where gt2.book_type_code = p_book_type_code

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

244:
245: delete
246: from fa_category_accounts_gt gt1
247: where not exists
248: (select /*+ index (gt2 FA_CATEGORY_ACCOUNTS_GT_N1) */ 1
249: from fa_category_accounts_gt gt2
250: where gt2.book_type_code = p_book_type_code
251: and gt2.clearing_acct = gt1.clearing_acct)
252: and gt1.rowid <>

Line 249: from fa_category_accounts_gt gt2

245: delete
246: from fa_category_accounts_gt gt1
247: where not exists
248: (select /*+ index (gt2 FA_CATEGORY_ACCOUNTS_GT_N1) */ 1
249: from fa_category_accounts_gt gt2
250: where gt2.book_type_code = p_book_type_code
251: and gt2.clearing_acct = gt1.clearing_acct)
252: and gt1.rowid <>
253: (select min(rowid)

Line 254: from fa_category_accounts_gt gt3

250: where gt2.book_type_code = p_book_type_code
251: and gt2.clearing_acct = gt1.clearing_acct)
252: and gt1.rowid <>
253: (select min(rowid)
254: from fa_category_accounts_gt gt3
255: where gt3.clearing_acct = gt1.clearing_acct);
256:
257: l_count := SQL%ROWCOUNT;
258: DebugLog( 'No of Records Deleted ', to_char(l_count));

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

264: -- now update the parents
265: l_sql := '
266: update /*+ index(gt FA_MASS_ADDITIONS_GT_N2) */ fa_mass_additions_gt gt
267: set (asset_type, line_status, book_type_code) =
268: (select /*+ index(fca FA_CATEGORY_ACCOUNTS_GT_N2 */
269: decode(gt.asset_type,
270: null, decode(glcc.account_type,
271: ''E'', ''EXPENSED'',
272: nvl(fca.asset_type, gt.asset_type)),

Line 292: fa_category_accounts_gt fca

288: :h_book_type_code, :h_book_type_code,
289: null),
290: gt.book_type_code))
291: from gl_code_combinations glcc,
292: fa_category_accounts_gt fca
293: where gt.payables_code_combination_id = glcc.code_combination_id
294: and fca.clearing_acct(+) = ' ||
295: ' glcc.segment' ||
296: to_char(p_segment_num) || '

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

399:
400: l_sql := '
401: update /*+ index(gt FA_MASS_ADDITIONS_GT_N2) */ fa_mass_additions_gt gt
402: set (asset_type, line_status, book_type_code) =
403: (select /*+ index(fca FA_CATEGORY_ACCOUNTS_GT_N2 */
404: decode(asset_type,
405: null, decode(glcc.account_type,
406: ''E'', ''EXPENSED'',
407: nvl(fca.asset_type, gt.asset_type)),

Line 427: fa_category_accounts_gt fca

423: :h_book_type_code, :h_book_type_code,
424: null),
425: gt.book_type_code))
426: from gl_code_combinations glcc,
427: fa_category_accounts_gt fca
428: where gt.parent_payables_ccid = glcc.code_combination_id
429: and fca.clearing_acct(+) = ' ||
430: ' glcc.segment' ||
431: to_char(p_segment_num) || '