APPS.FARX_AD dependencies on FA_DEPRN_DETAIL

Line 480: from FA_DEPRN_DETAIL DD1

476: AND DD.BOOK_TYPE_CODE = :h_book AND
477: DD.ASSET_ID = TH.ASSET_ID AND
478: DD.PERIOD_COUNTER =
479: ( select max(DD1.PERIOD_COUNTER)
480: from FA_DEPRN_DETAIL DD1
481: where dd1.period_counter <= dp1.period_counter
482: and DD1.ASSET_ID = DD.ASSET_ID
483: and DD1.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE)
484: AND DP1.BOOK_TYPE_CODE = :h_book AND

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 686: FA_DEPRN_DETAIL DD,

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 || '
690: UNION ALL

Line 746: fa_deprn_detail dd,

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
749: WHERE ' || where_clause2 || '
750: UNION ALL

Line 796: FA_DEPRN_DETAIL DD,

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 || '
800: UNION ALL

Line 847: fa_deprn_detail dd,

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
850: WHERE ' || where_clause4 ;
851:

Line 1377: FA_DEPRN_DETAIL DD,

1373: --GL_CODE_COMBINATIONS DHCC,
1374: FA_BOOKS BK,
1375: FA_DEPRN_SUMMARY DS,
1376: FA_TRANSACTION_HEADERS TH,
1377: FA_DEPRN_DETAIL DD,
1378: fa_adjustments adj
1379:
1380: WHERE
1381: bk.book_type_code = th.book_type_code AND

Line 1587: FA_DEPRN_DETAIL DD

1583: FA_LOOKUPS FALU,
1584: PO_VENDORS PO_VEND,
1585: FA_ADDITIONS AD,
1586: --GL_CODE_COMBINATIONS DHCC,
1587: FA_DEPRN_DETAIL DD
1588: WHERE
1589: bk.book_type_code = th.book_type_code AND
1590: bk.asset_id = th.asset_id AND
1591: bk.date_placed_in_service >= begin_dpis AND

Line 2074: FA_DEPRN_DETAIL DD

2070: FA_ASSET_HISTORY AH,
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