eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_CUA_ASSET_APIS dependencies on FA_HIERARCHY_DISTRIBUTIONS

Line 1515: from fa_hierarchy_distributions

1511:
1512: if( v_derivation_type IN ('ALL', 'DISTRIBUTION') AND nvl(v_distribution_set_id_out,0) <>0 )then
1513: -- check the dist already exists
1514: select count(*) into v_dist_count
1515: from fa_hierarchy_distributions
1516: where dist_set_id = v_distribution_set_id_out;
1517:
1518: if( v_dist_count <> 0 ) then
1519: -- first get each dist-combination

Line 1525: , fa_hierarchy_distributions ihd

1521: -- check whether the distribution exists for the asset
1522: select count(*)
1523: into v_dist_count2
1524: from fa_distribution_history fmd
1525: , fa_hierarchy_distributions ihd
1526: , fa_additions a
1527: where fmd.asset_id = v_asset_attr_tab(i).asset_id
1528: and fmd.asset_id = a.asset_id
1529: and fmd.date_ineffective is null