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 320: fa_asset_invoices ai

316: /** commented out for bugfix 2036777
317: Cursor Source_Lines_C Is
318: Select ext.*
319: from fa_ext_inv_retirements ext ,
320: fa_asset_invoices ai
321: where ext.mass_external_retire_id = L_Mass_External_Retire_ID
322: and ext.source_line_id = ai.source_line_id
323: and ai.date_ineffective is null
324: and ai.asset_id = G_Asset_Id;

Line 334: fa_asset_invoices ai

330: -- to current asset are treated.
331: Cursor Source_Lines_C Is
332: select ext.*, ext.ROWID row_id
333: from fa_ext_inv_retirements ext,
334: fa_asset_invoices ai
335: where ext.mass_external_retire_id = G_Mass_External_Retire_ID
336: and ext.source_line_id = ai.source_line_id
337: and ai.asset_id = g_asset_id
338: and ext.source_line_id_retired is null;

Line 345: from fa_asset_invoices b

341:
342: -- added for bugfix 2036777
343: Cursor C3(p_src_line_id number) IS
344: select b.source_line_id
345: from fa_asset_invoices b
346: where b.source_line_id in (
347: select a.source_line_id
348: from fa_asset_invoices a
349: start with a.source_Line_id = p_src_line_id

Line 348: from fa_asset_invoices a

344: select b.source_line_id
345: from fa_asset_invoices b
346: where b.source_line_id in (
347: select a.source_line_id
348: from fa_asset_invoices a
349: start with a.source_Line_id = p_src_line_id
350: connect by prior a.invoice_transaction_id_out = a.invoice_transaction_id_in )
351: and b.date_ineffective is null;
352: