APPS.FA_GENACCTS_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 141: SELECT /*+ leading(dh) index(dh FA_DISTRIBUTION_HISTORY_U1) */

137: p_allow_sorp_flag varchar2, -- Bug 6666666
138: p_start_range number,
139: p_end_range number
140: ) is
141: SELECT /*+ leading(dh) index(dh FA_DISTRIBUTION_HISTORY_U1) */
142: dh.distribution_id,
143: ad.asset_number,
144: ad.asset_id,
145: ad.asset_type,

Line 153: fa_distribution_history dh,

149: bks.group_asset_id,
150: bks.tracking_method
151: FROM fa_distribution_accounts da2,
152: fa_additions_b ad,
153: fa_distribution_history dh,
154: fa_books bks
155: WHERE dh.date_ineffective is null
156: AND dh.book_type_code = p_dist_source_book
157: AND da2.book_type_code(+) = p_book_type_code

Line 2094: FROM FA_DISTRIBUTION_HISTORY DH

2090: SELECT MIN(DISTRIBUTION_ID), MAX(DISTRIBUTION_ID), 0,
2091: 'UNASSIGNED', p_parent_request_id FROM ( SELECT /*+ parallel(DH) */
2092: DISTRIBUTION_ID, FLOOR(RANK()
2093: OVER (ORDER BY DISTRIBUTION_ID)/l_batch_size ) UNIT_ID
2094: FROM FA_DISTRIBUTION_HISTORY DH
2095: WHERE DH.BOOK_TYPE_CODE = l_dist_source_book )
2096: GROUP BY UNIT_ID;
2097:
2098: if g_log_level_rec.statement_level then