303: ''CR'', adjustment_amount,
304: adjustment_amount * -1),
305: 0)) ' ||
306: ' from fa_adjustments adj,
307: fa_distribution_history dh,
308: gl_code_combinations glcc1,
309: gl_code_combinations glcc2
310: where adj.asset_id = :p_asset_id
311: and adj.book_type_code = :p_book
338: ''CR'', adjustment_amount,
339: adjustment_amount * -1),
340: 0)) ' ||
341: ' from fa_adjustments adj,
342: fa_distribution_history dh,
343: gl_code_combinations glcc1,
344: gl_code_combinations glcc2
345: where adj.asset_id = :p_asset_id
346: and adj.book_type_code = :p_book
450: ''DR'', adjustment_amount,
451: adjustment_amount * -1),
452: 0)) ' ||
453: ' from fa_adjustments adj,
454: fa_distribution_history dh,
455: gl_code_combinations glcc1,
456: gl_code_combinations glcc2
457: where adj.asset_id = :p_asset_id
458: and adj.book_type_code = :p_book
484: ''DR'', adjustment_amount,
485: adjustment_amount * -1),
486: 0)) ' ||
487: ' from fa_adjustments adj,
488: fa_distribution_history dh,
489: gl_code_combinations glcc1,
490: gl_code_combinations glcc2
491: where adj.asset_id = :p_asset_id
492: and adj.book_type_code = :p_book
1052: dh.distribution_id,
1053: dh.code_combination_id,
1054: dh.units_assigned
1055: from fa_adjustments adj,
1056: fa_distribution_history dh,
1057: gl_code_combinations glcc
1058: where adj.asset_id = :p_asset_id
1059: and adj.book_type_code = :p_book_type_code
1060: and adj.period_counter_created = :p_period_counter_created
1264: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN is
1265:
1266: CURSOR c_asset_distributions IS
1267: select code_combination_id
1268: from fa_distribution_history
1269: where asset_id = p_asset_hdr_rec.asset_id
1270: and date_ineffective is null;
1271:
1272: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1405:
1406: if l_asset_dist_tbl(l_dist_tbl_count).expense_ccid is null then
1407: select code_combination_id
1408: into l_ccid
1409: from fa_distribution_history
1410: where distribution_id = l_asset_dist_tbl(l_dist_tbl_count).distribution_id;
1411: else
1412: l_ccid := l_asset_dist_tbl(l_dist_tbl_count).expense_ccid;
1413: end if;
1484: 'select distinct glcc.' || l_column_name ||
1485: ' from gl_code_combinations glcc,
1486: fa_books bk,
1487: fa_book_controls bc,
1488: fa_distribution_history dh
1489: where bk.asset_id = dh.asset_id
1490: and bk.group_asset_id = :p_asset_id
1491: and bk.book_type_code = bc.book_type_code
1492: and bc.distribution_source_book = :p_book
1511: l_statement :=
1512: 'select distinct glcc.' || l_column_name ||
1513: ' from gl_code_combinations glcc,
1514: fa_book_controls bc,
1515: fa_distribution_history dh
1516: where dh.asset_id = :p_asset_Id
1517: and dh.date_ineffective is null
1518: and dh.code_combination_id = glcc.code_combination_id
1519: and bc.distribution_source_book = :p_book
1529: l_statement :=
1530: 'select distinct glcc.' || l_column_name ||
1531: ' from gl_code_combinations glcc,
1532: fa_books bk,
1533: fa_distribution_history dh,
1534: fa_book_controls bc
1535: where dh.asset_id = bk.group_asset_id
1536: and dh.date_ineffective is null
1537: and dh.code_combination_id = glcc.code_combination_id
1627: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN is
1628:
1629: CURSOR c_asset_distributions (p_asset_id number) IS
1630: select code_combination_id
1631: from fa_distribution_history
1632: where asset_id = p_asset_id
1633: and date_ineffective is null;
1634:
1635: TYPE l_bal_tbl_type is table of varchar2(30) index by binary_integer;