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.FARX_AD dependencies on FA_DEPRN_PERIODS

Line 157: from fa_deprn_periods

153: h_mesg_name := 'FA_AMT_SEL_PERIODS';
154:
155: select period_counter
156: into h_period1_pc
157: from fa_deprn_periods
158: where book_type_code = h_book and period_name = begin_period;
159:
160: select count(*) into h_count
161: from fa_deprn_periods where period_name = end_period

Line 161: from fa_deprn_periods where period_name = end_period

157: from fa_deprn_periods
158: where book_type_code = h_book and period_name = begin_period;
159:
160: select count(*) into h_count
161: from fa_deprn_periods where period_name = end_period
162: and book_type_code = h_book;
163:
164: if (h_count > 0) then
165: select period_counter

Line 167: from fa_deprn_periods

163:
164: if (h_count > 0) then
165: select period_counter
166: into h_period2_pc
167: from fa_deprn_periods
168: where book_type_code = h_book and period_name = end_period;
169: else
170: h_period2_pc := null;
171: end if;

Line 578: from FA_DEPRN_DETAIL DD1, FA_DEPRN_PERIODS DP2

574: AND DD.BOOK_TYPE_CODE = :h_book AND
575: DD.ASSET_ID = TH.ASSET_ID AND
576: DD.PERIOD_COUNTER =
577: ( select max(DD1.PERIOD_COUNTER)
578: from FA_DEPRN_DETAIL DD1, FA_DEPRN_PERIODS DP2
579: where dd1.period_counter <= dp2.period_counter
580: and DD1.ASSET_ID = DD.ASSET_ID
581: and DD1.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE
582: and DP2.BOOK_TYPE_CODE = DD1.BOOK_TYPE_CODE

Line 683: FA_DEPRN_PERIODS DP1,

679: FA_CATEGORY_BOOKS CB,
680: FA_ASSET_HISTORY AH,
681: FA_BOOKS BK,
682: FA_TRANSACTION_HEADERS TH,
683: FA_DEPRN_PERIODS DP1,
684: FA_DEPRN_PERIODS DP,
685: FA_DEPRN_DETAIL DD,
686: FA_CATEGORIES CAT,
687: FA_ADDITIONS_B GAD

Line 684: FA_DEPRN_PERIODS DP,

680: FA_ASSET_HISTORY AH,
681: FA_BOOKS BK,
682: FA_TRANSACTION_HEADERS TH,
683: FA_DEPRN_PERIODS DP1,
684: FA_DEPRN_PERIODS DP,
685: FA_DEPRN_DETAIL DD,
686: FA_CATEGORIES CAT,
687: FA_ADDITIONS_B GAD
688: WHERE ' || where_clause1 || '

Line 741: FA_DEPRN_PERIODS DP2,

737: FA_CATEGORY_BOOKS CB,
738: FA_LOOKUPS FALU,
739: FA_ASSET_HISTORY AH,
740: FA_TRANSACTION_HEADERS THADD,
741: FA_DEPRN_PERIODS DP2,
742: FA_DEPRN_PERIODS DP1,
743: FA_DEPRN_PERIODS DP,
744: FA_TRANSACTION_HEADERS TH,
745: fa_deprn_detail dd,

Line 742: FA_DEPRN_PERIODS DP1,

738: FA_LOOKUPS FALU,
739: FA_ASSET_HISTORY AH,
740: FA_TRANSACTION_HEADERS THADD,
741: FA_DEPRN_PERIODS DP2,
742: FA_DEPRN_PERIODS DP1,
743: FA_DEPRN_PERIODS DP,
744: FA_TRANSACTION_HEADERS TH,
745: fa_deprn_detail dd,
746: fa_categories cat,

Line 743: FA_DEPRN_PERIODS DP,

739: FA_ASSET_HISTORY AH,
740: FA_TRANSACTION_HEADERS THADD,
741: FA_DEPRN_PERIODS DP2,
742: FA_DEPRN_PERIODS DP1,
743: FA_DEPRN_PERIODS DP,
744: FA_TRANSACTION_HEADERS TH,
745: fa_deprn_detail dd,
746: fa_categories cat,
747: fa_additions_b GAD

Line 794: FA_DEPRN_PERIODS DP,

790: FA_CATEGORY_BOOKS CB,
791: FA_ASSET_HISTORY AH,
792: FA_BOOKS BK,
793: FA_TRANSACTION_HEADERS TH,
794: FA_DEPRN_PERIODS DP,
795: FA_DEPRN_DETAIL DD,
796: fa_categories cat,
797: fa_additions_b GAD
798: WHERE ' || where_clause3 || '

Line 844: FA_DEPRN_PERIODS DP,

840: FA_ADDITIONS AD,
841: FA_CATEGORY_BOOKS CB,
842: FA_LOOKUPS FALU,
843: FA_ASSET_HISTORY AH,
844: FA_DEPRN_PERIODS DP,
845: FA_TRANSACTION_HEADERS TH,
846: fa_deprn_detail dd,
847: fa_categories cat,
848: FA_ADDITIONS_B GAD

Line 1477: fa_deprn_periods dp

1473: --GL_CODE_COMBINATIONS DHCC,
1474: --GL_CODE_COMBINATIONS AJCC,
1475: FA_LOOKUPS FALU,
1476: FA_ADJUSTMENTS ADJ,
1477: fa_deprn_periods dp
1478: WHERE
1479: DP.BOOK_TYPE_CODE = h_book AND
1480: DP.period_open_date >= bk.date_effective --AND
1481: -- dp.period_close_date <= nvl(bk.date_ineffective,sysdate)

Line 1702: FA_DEPRN_PERIODS DP

1698: PO_VENDORS PO_VEND,
1699: FA_ADDITIONS AD,
1700: --GL_CODE_COMBINATIONS DHCC,
1701: FA_TRANSACTION_HEADERS TH,
1702: FA_DEPRN_PERIODS DP
1703: WHERE
1704: DP.BOOK_TYPE_CODE = h_book AND
1705: dp.period_open_date >= bk.date_effective --AND
1706: -- dp.period_close_date <= nvl(bk.date_ineffective,sysdate)

Line 2077: --FA_DEPRN_PERIODS DP

2073: FA_DISTRIBUTION_HISTORY DH,
2074: FA_BOOKS BOOKS,
2075: FA_DEPRN_SUMMARY DS,
2076: FA_DEPRN_DETAIL DD
2077: --FA_DEPRN_PERIODS DP
2078: WHERE
2079: TH.DATE_EFFECTIVE >= h_period1_pod AND
2080: TH.DATE_EFFECTIVE <= nvl(h_period2_pcd ,sysdate) AND
2081: TH.BOOK_TYPE_CODE = h_book AND

Line 2153: --fa_deprn_periods dp

2149: FA_DISTRIBUTION_HISTORY DH,
2150: FA_BOOKS BOOKS,
2151: FA_DEPRN_SUMMARY DS,
2152: FA_ADJUSTMENTS CADJ
2153: --fa_deprn_periods dp
2154: WHERE
2155: TH.DATE_EFFECTIVE >= h_period1_pod AND
2156: TH.DATE_EFFECTIVE <= nvl(h_period2_pcd ,sysdate) AND
2157: TH.BOOK_TYPE_CODE = h_book AND

Line 2244: --fa_deprn_periods dp

2240: FA_DISTRIBUTION_HISTORY DH,
2241: FA_DEPRN_SUMMARY DS,
2242: FA_BOOKS BOOKS,
2243: FA_ADJUSTMENTS RADJ
2244: --fa_deprn_periods dp
2245: WHERE
2246: TH.DATE_EFFECTIVE >= h_period1_pod AND
2247: TH.DATE_EFFECTIVE <= nvl(h_period2_pcd ,sysdate) AND
2248: TH.BOOK_TYPE_CODE = h_book AND

Line 2341: from fa_deprn_periods

2337: h_mesg_name := 'FA_AMT_SEL_PERIODS';
2338:
2339: select period_counter, period_open_date
2340: into h_period1_pc, h_period1_pod
2341: from fa_deprn_periods
2342: where book_type_code = h_book and period_name = period;
2343:
2344: select count(*) into h_count
2345: from fa_deprn_periods where period_name = period

Line 2345: from fa_deprn_periods where period_name = period

2341: from fa_deprn_periods
2342: where book_type_code = h_book and period_name = period;
2343:
2344: select count(*) into h_count
2345: from fa_deprn_periods where period_name = period
2346: and book_type_code = h_book;
2347:
2348: if (h_count > 0) then
2349: select period_counter, nvl(period_close_date,sysdate)

Line 2351: from fa_deprn_periods

2347:
2348: if (h_count > 0) then
2349: select period_counter, nvl(period_close_date,sysdate)
2350: into h_period2_pc, h_period2_pcd
2351: from fa_deprn_periods
2352: where book_type_code = h_book and period_name = period;
2353: else
2354: h_period2_pc := null;
2355: h_period2_pcd := null;