DBA Data[Home] [Help]

APPS.JA_CN_FA_ACS_EXPORT_PKG dependencies on FA_CATEGORIES_B_KFV

Line 102: ,fa_categories_b_kfv fcbk

98: SELECT DISTINCT fcbk.concatenated_segments category_name
99: FROM fa_book_controls_sec fbcs
100: ,fa_category_books fcb
101: ,fa_additions_v fav
102: ,fa_categories_b_kfv fcbk
103: WHERE fbcs.book_type_code = fcb.book_type_code
104: AND fbcs.set_of_books_id = pn_ledger_id
105: AND fbcs.book_class IN ('CORPORATE', 'TAX')
106: AND fav.asset_category_id = fcb.category_id