DBA Data[Home] [Help]

APPS.FA_UTIL_PVT dependencies on FA_MC_ASSET_INVOICES

Line 1480: from fa_mc_asset_invoices ai,

1476: px_inv_rec.prior_source_line_id ,
1477: px_inv_rec.invoice_distribution_id ,
1478: px_inv_rec.invoice_line_number ,
1479: px_inv_rec.po_distribution_id
1480: from fa_mc_asset_invoices ai,
1481: fa_invoice_transactions it
1482: where ai.source_line_id = px_inv_rec.source_line_id
1483: and it.invoice_transaction_id = ai.invoice_transaction_id_in
1484: and it.transaction_type = 'RETIREMENT'

Line 1700: from fa_mc_asset_invoices

1696: px_inv_rec.prior_source_line_id ,
1697: px_inv_rec.invoice_distribution_id ,
1698: px_inv_rec.invoice_line_number ,
1699: px_inv_rec.po_distribution_id
1700: from fa_mc_asset_invoices
1701: where source_line_id = px_inv_rec.source_line_id
1702: and date_ineffective is null
1703: and set_of_books_id = p_set_of_books_id;
1704: