DBA Data[Home] [Help]

APPS.FA_MASSADD_CREATE_PKG dependencies on FA_ADDITIONS_B

Line 630: fa_additions_b ad

626: max(mad.asset_type),
627: count(distinct mad.rowid)
628: from fa_mass_additions_gt gt,
629: fa_mass_additions mad,
630: fa_additions_b ad
631: where ad.asset_number(+) = mad.asset_number
632: and mad.book_type_code = p_book_type_code
633: and mad.invoice_distribution_id = gt.parent_invoice_dist_id
634: -- BUG# 9162562 - see discussion for why we can only

Line 650: fa_additions_b ad,

646: max(ad.asset_type),
647: count(distinct ai.rowid),
648: count(distinct ai.asset_id)
649: from fa_asset_invoices ai,
650: fa_additions_b ad,
651: fa_mass_additions_gt gt
652: where ai.invoice_distribution_id = gt.parent_invoice_dist_id
653: and ad.asset_id = ai.asset_id
654: and gt.ledger_category_code = 'P'