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_GAINLOSS_UND_PKG dependencies on FA_DEPRN_PERIODS

Line 70: fa_adjustments faadj, fa_retirements faret, fa_deprn_periods dp

66: faadj.adjustment_type,
67: DECODE(faadj.debit_credit_flag, 'CR', 'DR', 'CR'),
68: faadj.adjustment_amount
69: FROM
70: fa_adjustments faadj, fa_retirements faret, fa_deprn_periods dp
71: WHERE faadj.transaction_header_id = faret.transaction_header_id_in
72: AND faadj.asset_id = faret.asset_id
73: AND faadj.book_type_Code = faret.book_type_code
74: AND faadj.source_type_code = decode(p_wip_asset, 1, 'CIP RETIREMENT',

Line 94: fa_adjustments faadj, fa_retirements faret, fa_deprn_periods dp

90: faadj.adjustment_type,
91: DECODE(faadj.debit_credit_flag, 'CR', 'DR', 'CR'),
92: faadj.adjustment_amount
93: FROM
94: fa_adjustments faadj, fa_retirements faret, fa_deprn_periods dp
95: WHERE faadj.transaction_header_id = p_group_thid
96: AND faadj.asset_id = p_group_asset_id
97: AND faadj.book_type_Code = faret.book_type_code
98: AND faadj.source_type_code = decode(p_wip_asset, 1, 'CIP RETIREMENT',

Line 124: fa_deprn_periods dp

120: faadj.adjustment_amount
121: FROM
122: fa_adjustments_mrc_v faadj,
123: fa_retirements_mrc_v faret,
124: fa_deprn_periods dp
125: WHERE faadj.transaction_header_id = faret.transaction_header_id_in
126: AND faadj.asset_id = faret.asset_id
127: AND faadj.book_type_Code = faret.book_type_code
128: AND faadj.source_type_code = decode(p_wip_asset, 1, 'CIP RETIREMENT',

Line 150: fa_deprn_periods dp

146: faadj.adjustment_amount
147: FROM
148: fa_adjustments_mrc_v faadj,
149: fa_retirements_mrc_v faret,
150: fa_deprn_periods dp
151: WHERE faadj.transaction_header_id = p_group_thid
152: AND faadj.asset_id = p_group_asset_id
153: AND faadj.book_type_Code = faret.book_type_code
154: AND faadj.source_type_code = decode(p_wip_asset, 1, 'CIP RETIREMENT',

Line 584: FA_DEPRN_PERIODS DP,

580: h_is_prior_period
581: FROM
582: FA_TRANSACTION_HEADERS TH,
583: FA_BOOK_CONTROLS BC,
584: FA_DEPRN_PERIODS DP,
585: FA_DEPRN_PERIODS DP_NOW
586: WHERE
587: TH.ASSET_ID = h_asset_id AND
588: TH.TRANSACTION_TYPE_CODE = 'ADDITION' AND

Line 585: FA_DEPRN_PERIODS DP_NOW

581: FROM
582: FA_TRANSACTION_HEADERS TH,
583: FA_BOOK_CONTROLS BC,
584: FA_DEPRN_PERIODS DP,
585: FA_DEPRN_PERIODS DP_NOW
586: WHERE
587: TH.ASSET_ID = h_asset_id AND
588: TH.TRANSACTION_TYPE_CODE = 'ADDITION' AND
589: TH.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND

Line 632: fa_deprn_periods

628:
629: SELECT period_counter
630: into h_cpd_num
631: from
632: fa_deprn_periods
633: where book_type_code = h_book
634: and period_close_date is null;
635:
636: -- We need to move the cost, reserve and reval reserve to the

Line 3963: FROM FA_DEPRN_PERIODS fadp

3959: end if;
3960:
3961: SELECT PERIOD_NUM , PERIOD_NAME, PERIOD_COUNTER
3962: INTO h_rpdnum, h_rpdname, h_pd_counter
3963: FROM FA_DEPRN_PERIODS fadp
3964: WHERE RET.date_effective
3965: between fadp.period_open_date and
3966: nvl(fadp.period_close_date,
3967: RET.date_effective)

Line 3986: FROM fa_deprn_summary fads, fa_deprn_periods fadp

3982: SELECT fads.deprn_reserve, fads.bonus_deprn_reserve, fads.reval_reserve,
3983: nvl(fads.prior_fy_expense, 0), nvl(fads.ytd_deprn, 0)
3984: INTO h_deprn_reserve, h_bonus_deprn_reserve, h_reval_reserve, h_prior_fy_expense,
3985: h_ytd_deprn
3986: FROM fa_deprn_summary fads, fa_deprn_periods fadp
3987: WHERE fads.asset_id = h_asset_id
3988: AND fads.book_type_Code = h_book
3989: AND fads.period_counter = fadp.period_counter
3990: AND fadp.period_counter =

Line 3992: FROM FA_DEPRN_PERIODS DP, FA_DEPRN_SUMMARY DS

3988: AND fads.book_type_Code = h_book
3989: AND fads.period_counter = fadp.period_counter
3990: AND fadp.period_counter =
3991: (select MAX(DP.PERIOD_COUNTER)
3992: FROM FA_DEPRN_PERIODS DP, FA_DEPRN_SUMMARY DS
3993: WHERE DP.BOOK_TYPE_CODE = h_book
3994: AND DP.PERIOD_COUNTER = DS.PERIOD_COUNTER
3995: AND DP.PERIOD_COUNTER < h_pd_counter
3996: AND DS.BOOK_TYPE_CODE = h_book

Line 4006: FROM fa_deprn_summary_mrc_v fads, fa_deprn_periods fadp

4002: SELECT fads.deprn_reserve, fads.bonus_deprn_reserve, fads.reval_reserve,
4003: nvl(fads.prior_fy_expense, 0), nvl(fads.ytd_deprn, 0)
4004: INTO h_deprn_reserve, h_bonus_deprn_reserve, h_reval_reserve, h_prior_fy_expense,
4005: h_ytd_deprn
4006: FROM fa_deprn_summary_mrc_v fads, fa_deprn_periods fadp
4007: WHERE fads.asset_id = h_asset_id
4008: AND fads.book_type_Code = h_book
4009: AND fads.period_counter = fadp.period_counter
4010: AND fadp.period_counter =

Line 4012: FROM FA_DEPRN_PERIODS DP, FA_DEPRN_SUMMARY DS

4008: AND fads.book_type_Code = h_book
4009: AND fads.period_counter = fadp.period_counter
4010: AND fadp.period_counter =
4011: (select MAX(DP.PERIOD_COUNTER)
4012: FROM FA_DEPRN_PERIODS DP, FA_DEPRN_SUMMARY DS
4013: WHERE DP.BOOK_TYPE_CODE = h_book
4014: AND DP.PERIOD_COUNTER = DS.PERIOD_COUNTER
4015: AND DP.PERIOD_COUNTER < h_pd_counter
4016: AND DS.BOOK_TYPE_CODE = h_book