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_CUA_MASS_EXT_RET_PKG dependencies on FA_ASSET_INVOICES

Line 304: fa_asset_invoices ai

300: /** commented out for bugfix 2036777
301: Cursor Source_Lines_C Is
302: Select ext.*
303: from fa_ext_inv_retirements ext ,
304: fa_asset_invoices ai
305: where ext.mass_external_retire_id = L_Mass_External_Retire_ID
306: and ext.source_line_id = ai.source_line_id
307: and ai.date_ineffective is null
308: and ai.asset_id = G_Asset_Id;

Line 318: fa_asset_invoices ai

314: -- to current asset are treated.
315: Cursor Source_Lines_C Is
316: select ext.*, ext.ROWID row_id
317: from fa_ext_inv_retirements ext,
318: fa_asset_invoices ai
319: where ext.mass_external_retire_id = G_Mass_External_Retire_ID
320: and ext.source_line_id = ai.source_line_id
321: and ai.asset_id = g_asset_id
322: and ext.source_line_id_retired is null;

Line 329: from fa_asset_invoices b

325:
326: -- added for bugfix 2036777
327: Cursor C3(p_src_line_id number) IS
328: select b.source_line_id
329: from fa_asset_invoices b
330: where b.source_line_id in (
331: select a.source_line_id
332: from fa_asset_invoices a
333: start with a.source_Line_id = p_src_line_id

Line 332: from fa_asset_invoices a

328: select b.source_line_id
329: from fa_asset_invoices b
330: where b.source_line_id in (
331: select a.source_line_id
332: from fa_asset_invoices a
333: start with a.source_Line_id = p_src_line_id
334: connect by prior a.invoice_transaction_id_out = a.invoice_transaction_id_in )
335: and b.date_ineffective is null;
336: