DBA Data[Home] [Help]

APPS.FA_UTIL_PVT dependencies on FA_ASSET_INVOICES

Line 1590: from fa_asset_invoices ai,

1586: px_inv_rec.Prior_Source_Line_ID ,
1587: px_inv_rec.invoice_distribution_id ,
1588: px_inv_rec.invoice_line_number ,
1589: px_inv_rec.po_distribution_id
1590: from fa_asset_invoices ai,
1591: fa_invoice_transactions it
1592: where ai.source_line_id = px_inv_rec.source_line_id
1593: and it.invoice_transaction_id = ai.invoice_transaction_id_in
1594: and it.transaction_type = 'RETIREMENT';

Line 1808: from fa_asset_invoices

1804: px_inv_rec.Prior_Source_Line_ID ,
1805: px_inv_rec.invoice_distribution_id ,
1806: px_inv_rec.invoice_line_number ,
1807: px_inv_rec.po_distribution_id
1808: from fa_asset_invoices
1809: where source_line_id = px_inv_rec.source_line_id
1810: and date_ineffective is null;
1811:
1812: end if;