DBA Data[Home] [Help]

APPS.FA_XML_REPORT_PKG dependencies on FA_CASH_GEN_UNITS

Line 318: ,FA_CASH_GEN_UNITS CGU

314: ,IMP.GOODWILL_AMOUNT
315: ,AD.ASSET_NUMBER
316: ,IMP.IMPAIRMENT_ID
317: FROM FA_IMPAIRMENTS IMP
318: ,FA_CASH_GEN_UNITS CGU
319: ,FA_ADDITIONS_B AD
320: WHERE IMP.CASH_GENERATING_UNIT_ID = CGU.CASH_GENERATING_UNIT_ID(+)
321: AND IMP.GOODWILL_ASSET_ID = AD.ASSET_ID(+)
322: AND IMP.BOOK_TYPE_CODE = p_book_type_code

Line 339: ,FA_CASH_GEN_UNITS CGU

335: ,IMP.GOODWILL_AMOUNT
336: ,AD.ASSET_NUMBER
337: ,IMP.IMPAIRMENT_ID
338: FROM FA_MC_IMPAIRMENTS IMP
339: ,FA_CASH_GEN_UNITS CGU
340: ,FA_ADDITIONS_B AD
341: WHERE IMP.CASH_GENERATING_UNIT_ID = CGU.CASH_GENERATING_UNIT_ID(+)
342: AND IMP.GOODWILL_ASSET_ID = AD.ASSET_ID(+)
343: AND IMP.BOOK_TYPE_CODE = p_book_type_code

Line 656: from fa_cash_gen_units cgu

652:
653: cursor c_master is
654: select cash_generating_unit
655: ,cgu.cash_generating_unit_id
656: from fa_cash_gen_units cgu
657: where cgu.book_type_code = p_book_type_code
658: and cgu.cash_generating_unit_id = nvl(p_cash_gen_unit_id, cgu.cash_generating_unit_id)
659: and cgu.cash_generating_unit_id
660: in (select bk.cash_generating_unit_id

Line 670: from fa_cash_gen_units cgu

666:
667: cursor c_master_mrc is
668: select cash_generating_unit
669: ,cgu.cash_generating_unit_id
670: from fa_cash_gen_units cgu
671: where cgu.book_type_code = p_book_type_code
672: and cgu.cash_generating_unit_id = nvl(p_cash_gen_unit_id, cgu.cash_generating_unit_id)
673: and cgu.cash_generating_unit_id
674: in (select bk.cash_generating_unit_id