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 1526: from fa_hierarchy_distributions

1522:
1523: if( v_derivation_type IN ('ALL', 'DISTRIBUTION') AND nvl(v_distribution_set_id_out,0) <>0 )then
1524: -- check the dist already exists
1525: select count(*) into v_dist_count
1526: from fa_hierarchy_distributions
1527: where dist_set_id = v_distribution_set_id_out;
1528:
1529: if( v_dist_count <> 0 ) then
1530: -- first get each dist-combination

Line 1536: , fa_hierarchy_distributions ihd

1532: -- check whether the distribution exists for the asset
1533: select count(*)
1534: into v_dist_count2
1535: from fa_distribution_history fmd
1536: , fa_hierarchy_distributions ihd
1537: , fa_additions a
1538: where fmd.asset_id = v_asset_attr_tab(i).asset_id
1539: and fmd.asset_id = a.asset_id
1540: and fmd.date_ineffective is null