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_SLA_EVENTS_UPG_PKG dependencies on FA_CATEGORY_BOOKS

Line 300: fa_category_books cb

296: fa_deprn_detail dd,
297: gl_je_lines gljl,
298: fa_distribution_accounts da,
299: fa_asset_history ah,
300: fa_category_books cb
301: where bc.book_type_code = l_book_type_code
302: and bc.set_of_books_id = glsob.set_of_books_id
303: and bc.book_type_code = adj.book_type_code
304: and adj.asset_id = l_asset_id

Line 375: fa_category_books cb

371: fa_deprn_detail dd,
372: gl_je_lines gljl,
373: fa_distribution_accounts da,
374: fa_asset_history ah,
375: fa_category_books cb
376: where bc.book_type_code = l_book_type_code
377: and bc.set_of_books_id = glsob.set_of_books_id
378: and bc.book_type_code = adj.book_type_code
379: and adj.asset_id = l_asset_id

Line 520: fa_category_books cb

516: fa_mc_deprn_detail dd,
517: gl_je_lines gljl,
518: fa_distribution_accounts da,
519: fa_asset_history ah,
520: fa_category_books cb
521: where bc.book_type_code = l_book_type_code
522: and bc.set_of_books_id = l_set_of_books_id
523: and bc.enabled_flag = 'Y'
524: and bc.set_of_books_id = glsob.set_of_books_id

Line 599: fa_category_books cb

595: fa_mc_deprn_detail dd,
596: gl_je_lines gljl,
597: fa_distribution_accounts da,
598: fa_asset_history ah,
599: fa_category_books cb
600: where bc.book_type_code = l_book_type_code
601: and bc.set_of_books_id = l_set_of_books_id
602: and bc.enabled_flag = 'Y'
603: and bc.set_of_books_id = glsob.set_of_books_id

Line 2762: fa_category_books cb

2758: fa_deprn_detail dd,
2759: gl_je_lines gljl,
2760: fa_distribution_accounts da,
2761: fa_asset_history ah,
2762: fa_category_books cb
2763: where bc.book_type_code = l_book_type_code
2764: and bc.set_of_books_id = glsob.set_of_books_id
2765: and bc.book_type_code = adj.book_type_code
2766: and adj.asset_id = l_asset_id

Line 2837: fa_category_books cb

2833: fa_deprn_detail dd,
2834: gl_je_lines gljl,
2835: fa_distribution_accounts da,
2836: fa_asset_history ah,
2837: fa_category_books cb
2838: where bc.book_type_code = l_book_type_code
2839: and bc.set_of_books_id = glsob.set_of_books_id
2840: and bc.book_type_code = adj.book_type_code
2841: and adj.asset_id = l_asset_id

Line 2982: fa_category_books cb

2978: fa_mc_deprn_detail dd,
2979: gl_je_lines gljl,
2980: fa_distribution_accounts da,
2981: fa_asset_history ah,
2982: fa_category_books cb
2983: where bc.book_type_code = l_book_type_code
2984: and bc.set_of_books_id = l_set_of_books_id
2985: and bc.enabled_flag = 'Y'
2986: and bc.set_of_books_id = glsob.set_of_books_id

Line 3061: fa_category_books cb

3057: fa_mc_deprn_detail dd,
3058: gl_je_lines gljl,
3059: fa_distribution_accounts da,
3060: fa_asset_history ah,
3061: fa_category_books cb
3062: where bc.book_type_code = l_book_type_code
3063: and bc.set_of_books_id = l_set_of_books_id
3064: and bc.enabled_flag = 'Y'
3065: and bc.set_of_books_id = glsob.set_of_books_id

Line 5307: select /+ ordered index(adj, FA_ADJUSTMENTS_U1) use_nl(cb) index(cb, fa_category_books_u1) /

5303: null, -- subledger_doc_seq_value
5304: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
5305: 'XLAJEL' -- gl_sl_link_table
5306: )
5307: select /*+ ordered index(adj, FA_ADJUSTMENTS_U1) use_nl(cb) index(cb, fa_category_books_u1) */
5308: adj.adjustment_line_id adj_line_id,
5309: decode(adj.debit_credit_flag,
5310: 'DR', adj.adjustment_amount, null) debit_amount,
5311: decode(adj.debit_credit_flag,

Line 5390: fa_category_books cb,

5386: fa_book_controls bc,
5387: gl_sets_of_books glsob,
5388: fa_distribution_accounts da,
5389: fa_asset_history ah,
5390: fa_category_books cb,
5391: (select 1 adj_row from dual
5392: union all
5393: select 2 adj_row from dual
5394: union all

Line 6225: select /+ ordered index(adj, FA_MC_ADJUSTMENTS_U1) use_nl(cb) index(cb, fa_category_books_u1) /

6221: null, -- subledger_doc_seq_value
6222: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
6223: 'XLAJEL' -- gl_sl_link_table
6224: )
6225: select /*+ ordered index(adj, FA_MC_ADJUSTMENTS_U1) use_nl(cb) index(cb, fa_category_books_u1) */
6226: adj.adjustment_line_id adj_line_id,
6227: decode(adj.debit_credit_flag,
6228: 'DR', adj.adjustment_amount, null) debit_amount,
6229: decode(adj.debit_credit_flag,

Line 6309: fa_category_books cb,

6305: fa_mc_book_controls bc,
6306: gl_sets_of_books glsob,
6307: fa_distribution_accounts da,
6308: fa_asset_history ah,
6309: fa_category_books cb,
6310: (select 1 adj_row from dual
6311: union all
6312: select 2 adj_row from dual
6313: union all

Line 6811: fa_category_books cb

6807: fa_book_controls bc,
6808: gl_sets_of_books glsob,
6809: fa_deprn_periods dp,
6810: fa_asset_history ah,
6811: fa_category_books cb
6812: where ds.rowid between p_start_rowid and p_end_rowid
6813: and ds.book_type_code = bc.book_type_code
6814: and bc.set_of_books_id = glsob.set_of_books_id
6815: and dp.book_type_code = ds.book_type_code

Line 7145: fa_category_books cb,

7141: fa_book_controls bc,
7142: gl_sets_of_books glsob,
7143: fa_deprn_periods dp,
7144: fa_asset_history ah,
7145: fa_category_books cb,
7146: gl_period_statuses ps
7147: where ds.rowid between p_start_rowid and p_end_rowid
7148: and ds.book_type_code = bc.book_type_code
7149: and bc.set_of_books_id = glsob.set_of_books_id