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 579: from FA_DEPRN_DETAIL DD1, FA_DEPRN_PERIODS DP2

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

Line 684: /* FA_DEPRN_PERIODS DP1,*/

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

Line 685: FA_DEPRN_PERIODS DP,

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

Line 742: FA_DEPRN_PERIODS DP2,

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

Line 743: FA_DEPRN_PERIODS DP1,

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

Line 744: FA_DEPRN_PERIODS DP,

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

Line 795: FA_DEPRN_PERIODS DP,

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

Line 845: FA_DEPRN_PERIODS DP,

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

Line 1478: fa_deprn_periods dp

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

Line 1700: FA_DEPRN_PERIODS DP

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

Line 2075: --FA_DEPRN_PERIODS DP

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

Line 2151: --fa_deprn_periods dp

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

Line 2242: --fa_deprn_periods dp

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

Line 2339: from fa_deprn_periods

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

Line 2343: from fa_deprn_periods where period_name = period

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

Line 2349: from fa_deprn_periods

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