DBA Data[Home] [Help]

APPS.FA_INVOICE_PVT dependencies on FA_MC_ASSET_INVOICES

Line 647: update fa_mc_asset_invoices

643: set date_ineffective = sysdate,
644: invoice_transaction_id_out = px_inv_trans_rec.invoice_transaction_id
645: where source_line_id = l_inv_rec.source_line_id;
646:
647: update fa_mc_asset_invoices
648: set date_ineffective = sysdate,
649: invoice_transaction_id_out = px_inv_trans_rec.invoice_transaction_id
650: where source_line_id = l_inv_rec.source_line_id;
651:

Line 937: from fa_mc_asset_invoices

933: select fixed_assets_cost,
934: payables_cost
935: into l_current_fa_cost,
936: l_current_pa_cost
937: from fa_mc_asset_invoices
938: where source_line_id = l_current_source_line_id
939: and set_of_books_id = l_sob_tbl(l_sob_index);
940:
941:

Line 1608: from fa_mc_asset_invoices mcai,

1604: cursor c_mc_invoices (p_source_line_id in number) is
1605: select mcai.set_of_books_id,
1606: mcai.exchange_rate,
1607: mcai.fixed_assets_cost
1608: from fa_mc_asset_invoices mcai,
1609: fa_mc_book_controls mcbk
1610: where mcai.source_line_id = p_source_line_id
1611: and mcai.set_of_books_id = mcbk.set_of_books_id
1612: and mcbk.book_type_code = p_asset_hdr_rec.book_type_code