DBA Data[Home] [Help]

APPS.FA_SLA_CURRENT_PERIOD_UPG_PKG dependencies on FA_ASSET_INVOICES

Line 66: FROM FA_ASSET_INVOICES AI

62: select AI.Payables_Code_Combination_ID,
63: NVL(AI.Payables_Cost, 0),
64: AI.Asset_Invoice_ID,
65: AI.source_line_id
66: FROM FA_ASSET_INVOICES AI
67: WHERE AI.ASSET_ID = p_asset_id
68: AND AI.Payables_Code_Combination_ID IS NOT NULL
69: AND AI.Date_Ineffective IS NULL
70: ORDER BY AI.Payables_Code_Combination_ID,

Line 1717: fa_asset_invoices ai,

1713: from fa_transaction_headers th,
1714: fa_book_controls bc,
1715: fa_deprn_periods dp,
1716: fa_adjustments adj,
1717: fa_asset_invoices ai,
1718: fa_invoice_transactions it,
1719: (select 'SOURCE' source_dest_code from dual union all
1720: select 'DEST' source_dest_code from dual) mult
1721: where th.rowid between p_start_rowid and p_end_rowid