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_ASSET_HIERARCHY

Line 21: from fa_asset_hierarchy_purpose a

17: -- should fetch one row of purpose_id
18: CURSOR C_purpose IS
19: select a.default_rule_set_id
20: , a.rule_set_level
21: from fa_asset_hierarchy_purpose a
22: , fa_asset_hierarchy b
23: where a.asset_hierarchy_purpose_id = b.asset_hierarchy_purpose_id
24: and b.asset_hierarchy_id = x_parent_node_id
25: and a.book_type_code = x_book_type_code ;

Line 22: , fa_asset_hierarchy b

18: CURSOR C_purpose IS
19: select a.default_rule_set_id
20: , a.rule_set_level
21: from fa_asset_hierarchy_purpose a
22: , fa_asset_hierarchy b
23: where a.asset_hierarchy_purpose_id = b.asset_hierarchy_purpose_id
24: and b.asset_hierarchy_id = x_parent_node_id
25: and a.book_type_code = x_book_type_code ;
26:

Line 35: from fa_asset_hierarchy a

31: and book_type_code = x_book_type_code
32: and p_rule_set_level = 'ASSET_CATEGORY'
33: UNION
34: select a.hierarchy_rule_set_id
35: from fa_asset_hierarchy a
36: , fa_asset_hierarchy_purpose b
37: where a.asset_hierarchy_purpose_id = b.asset_hierarchy_purpose_id
38: and a.asset_hierarchy_id = x_parent_node_id
39: and b.book_type_code = x_book_type_code

Line 36: , fa_asset_hierarchy_purpose b

32: and p_rule_set_level = 'ASSET_CATEGORY'
33: UNION
34: select a.hierarchy_rule_set_id
35: from fa_asset_hierarchy a
36: , fa_asset_hierarchy_purpose b
37: where a.asset_hierarchy_purpose_id = b.asset_hierarchy_purpose_id
38: and a.asset_hierarchy_id = x_parent_node_id
39: and b.book_type_code = x_book_type_code
40: and p_rule_set_level = 'TOP_NODE'

Line 44: from fa_asset_hierarchy

40: and p_rule_set_level = 'TOP_NODE'
41: UNION
42: select a.hierarchy_rule_set_id
43: from ( select hierarchy_rule_set_id, asset_hierarchy_purpose_id
44: from fa_asset_hierarchy
45: where parent_hierarchy_id IS NULL
46: start with asset_hierarchy_id = x_parent_node_id
47: connect by prior asset_hierarchy_id = parent_hierarchy_id ) a
48: , fa_asset_hierarchy_purpose b

Line 48: , fa_asset_hierarchy_purpose b

44: from fa_asset_hierarchy
45: where parent_hierarchy_id IS NULL
46: start with asset_hierarchy_id = x_parent_node_id
47: connect by prior asset_hierarchy_id = parent_hierarchy_id ) a
48: , fa_asset_hierarchy_purpose b
49: where a.asset_hierarchy_purpose_id = b.asset_hierarchy_purpose_id
50: and b.book_type_code = x_book_type_code
51: and p_rule_set_level = 'LOWEST_NODE';
52:

Line 122: from fa_asset_hierarchy_values

118: v_life_end_date date;
119:
120: Cursor check_tax_record_exists (c_asset_hierarchy_id number) is
121: select life_end_date
122: from fa_asset_hierarchy_values
123: where book_type_code = x_book_type_code
124: and asset_hierarchy_id = c_asset_hierarchy_id ;
125:
126: CURSOR C_get_lifes IS

Line 134: from fa_asset_hierarchy_values a,

130: , a.book_type_code book_type_code
131: , a.life_end_date life_end_date
132: , 0 life_in_months
133: , bc.book_class book_class
134: from fa_asset_hierarchy_values a,
135: fa_asset_hierarchy b,
136: fa_book_controls bc
137: where a.asset_hierarchy_id = b.asset_hierarchy_id
138: and bc.book_type_code = a.book_type_code

Line 135: fa_asset_hierarchy b,

131: , a.life_end_date life_end_date
132: , 0 life_in_months
133: , bc.book_class book_class
134: from fa_asset_hierarchy_values a,
135: fa_asset_hierarchy b,
136: fa_book_controls bc
137: where a.asset_hierarchy_id = b.asset_hierarchy_id
138: and bc.book_type_code = a.book_type_code
139: and a.book_type_code in (x_book_type_code,g_corporate_book)

Line 149: from fa_asset_hierarchy d

145: from dual
146: where nvl(x_rule_det_rec.include_level, 'ALL') = 'LOWEST'
147: union
148: select d.asset_hierarchy_id
149: from fa_asset_hierarchy d
150: where nvl(x_rule_det_rec.include_level, 'ALL') = 'ALL'
151: start with d.asset_hierarchy_id = x_parent_node_id
152: connect by d.asset_hierarchy_id = prior d.parent_hierarchy_id
153: )

Line 229: from fa_asset_hierarchy

225: order by 7 desc;
226:
227: CURSOR C_get_depr_date IS
228: select depreciation_start_date
229: from fa_asset_hierarchy
230: where asset_hierarchy_id = x_parent_node_id;
231:
232: BEGIN
233: x_err_code:= '0';

Line 405: from fa_asset_hierarchy

401:
402:
403: CURSOR C_get_top_node IS
404: select asset_hierarchy_id
405: from fa_asset_hierarchy
406: where parent_hierarchy_id IS NULL
407: start with asset_hierarchy_id = x_parent_node_id
408: connect by asset_hierarchy_id = prior parent_hierarchy_id;
409:

Line 414: from fa_asset_hierarchy

410: CURSOR C_check_lowest_node IS
411: select 1
412: from dual
413: where not exists ( select asset_hierarchy_id
414: from fa_asset_hierarchy
415: where ( parent_hierarchy_id = x_parent_node_id
416: and asset_id IS NULL)
417: OR ( asset_hierarchy_id = x_parent_node_id
418: and asset_id IS NOT NULL ) );

Line 428: from fa_asset_hierarchy_values

424: , dist_set_id
425: , asset_key_ccid
426: , serial_number
427: , life_end_date
428: from fa_asset_hierarchy_values
429: where asset_hierarchy_id = p_node_id
430: and book_type_code = x_book_type_code
431: UNION
432: select '2' dummy, asset_hierarchy_id

Line 439: from fa_asset_hierarchy_values

435: , dist_set_id
436: , asset_key_ccid
437: , serial_number
438: , life_end_date
439: from fa_asset_hierarchy_values
440: where asset_hierarchy_id = p_node_id
441: and book_type_code = g_corporate_book
442: order by 1;
443:

Line 1975: from fa_asset_hierarchy

1971: x_override_flag out nocopy varchar2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
1972:
1973: CURSOR c_get_parent_id IS
1974: select parent_hierarchy_id
1975: from fa_asset_hierarchy
1976: where asset_id = p_asset_id;
1977:
1978: v_parent_id number;
1979: v_asset_cat_id number;