DBA Data[Home] [Help]

APPS.JA_CN_PS_FA_ACUI_EXP_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 240: , fa_distribution_history fdh

236: FROM
237: fa_additions_v faav
238: , fa_books fb
239: , fa_book_controls_sec fbc
240: , fa_distribution_history fdh
241: , fa_transaction_history_trx_v fthv
242: WHERE fb.date_ineffective IS NULL
243: AND fb.transaction_header_id_out IS NULL
244: AND faav.asset_id = fb.asset_id

Line 309: fa_distribution_history fdh

305: SELECT
306: SUM(fdh.units_assigned)
307: , paf.organization_id
308: FROM
309: fa_distribution_history fdh
310: , per_people_f ppf
311: , per_assignments_f paf
312: , per_periods_of_service pos
313: , fa_book_controls_sec fbc

Line 377: fa_distribution_history fdh

373: SELECT
374: SUM(fdh.units_assigned)
375: , fdh.assigned_to
376: FROM
377: fa_distribution_history fdh
378: , fa_book_controls_sec fbc
379: WHERE fbc.book_type_code = pv_book_type_code
380: AND fdh.book_type_code = fbc.distribution_source_book
381: AND fdh.asset_id = pv_asset_id