APPS.FA_GENACCTS_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 131: SELECT /* leading(dh) index(dh FA_DISTRIBUTION_HISTORY_U1) */

127: p_allow_reval_flag varchar2,
128: p_start_range number,
129: p_end_range number
130: ) is
131: SELECT /* leading(dh) index(dh FA_DISTRIBUTION_HISTORY_U1) */
132: dh.distribution_id,
133: ad.asset_number,
134: ad.asset_id,
135: ad.asset_type,

Line 143: fa_distribution_history dh,

139: bks.group_asset_id,
140: bks.tracking_method
141: FROM fa_distribution_accounts da2,
142: fa_additions_b ad,
143: fa_distribution_history dh,
144: fa_books bks
145: WHERE dh.date_ineffective is null
146: AND dh.book_type_code = p_dist_source_book
147: AND da2.book_type_code(+) = p_book_type_code

Line 1899: FROM FA_DISTRIBUTION_HISTORY DH

1895: SELECT MIN(DISTRIBUTION_ID), MAX(DISTRIBUTION_ID), 0,
1896: 'UNASSIGNED', p_parent_request_id FROM ( SELECT /*+ parallel(DH) */
1897: DISTRIBUTION_ID, FLOOR(RANK()
1898: OVER (ORDER BY DISTRIBUTION_ID)/l_batch_size ) UNIT_ID
1899: FROM FA_DISTRIBUTION_HISTORY DH
1900: WHERE DH.BOOK_TYPE_CODE = l_dist_source_book )
1901: GROUP BY UNIT_ID;
1902:
1903: if g_log_level_rec.statement_level then