DBA Data[Home] [Help]

APPS.FA_MASSADD_CREATE_PKG dependencies on FA_ASSET_INVOICES

Line 392: from fa_asset_invoices ai

388:
389: update /*+ index(gt FA_MASS_ADDITIONS_GT_N2) */ fa_mass_additions_gt gt
390: set parent_payables_ccid =
391: (select min(payables_code_combination_id)
392: from fa_asset_invoices ai
393: where invoice_distribution_id = gt.parent_invoice_dist_id)
394: where gt.line_type_lookup_code not in ('ITEM', 'ACCRUAL')
395: and gt.ledger_category_code = 'P'
396: and gt.line_status = 'NEW';