APPS.JE_JEHUFDAN_XMLP_PKG dependencies on FA_DEPRN_DETAIL

Line 330: FA_DEPRN_DETAIL DD

326: FROM
327: FA_DISTRIBUTION_HISTORY DH,
328: FA_CATEGORY_BOOKS CB,
329: FA_ADDITIONS AD,
330: FA_DEPRN_DETAIL DD
331: WHERE NOT EXISTS (
332: SELECT
333: BR.ASSET_ID
334: FROM

Line 536: FA_DEPRN_DETAIL DD,

532: FA_LOOKUPS RT,
533: FA_CATEGORY_BOOKS CB,
534: FA_DISTRIBUTION_HISTORY DH,
535: FA_ASSET_HISTORY AH,
536: FA_DEPRN_DETAIL DD,
537: FA_DEPRN_PERIODS DP
538: WHERE DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK
539: AND AH.ASSET_ID = DH.ASSET_ID
540: AND AH.ASSET_TYPE = 'CAPITALIZED'

Line 612: FA_DEPRN_DETAIL DD,

608: FA_LOOKUPS RT,
609: FA_CATEGORY_BOOKS CB,
610: FA_DISTRIBUTION_HISTORY DH,
611: FA_ASSET_HISTORY AH,
612: FA_DEPRN_DETAIL DD,
613: FA_DEPRN_PERIODS DP,
614: FA_DEPRN_PERIODS DP1,
615: FA_BOOKS BO
616: WHERE DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK

Line 657: FA_DEPRN_DETAIL DD2

653: AND BO.PERIOD_COUNTER_FULLY_RESERVED = (
654: SELECT
655: MIN(PERIOD_COUNTER)
656: FROM
657: FA_DEPRN_DETAIL DD2
658: WHERE DD2.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE
659: AND DD2.ASSET_ID = DD.ASSET_ID
660: AND DD2.DEPRN_SOURCE_CODE = 'D' )
661: GROUP BY

Line 703: FA_DEPRN_DETAIL DD,

699: FA_LOOKUPS RT,
700: FA_CATEGORY_BOOKS CB,
701: FA_DISTRIBUTION_HISTORY DH,
702: FA_ASSET_HISTORY AH,
703: FA_DEPRN_DETAIL DD,
704: FA_DEPRN_PERIODS DP,
705: FA_DEPRN_PERIODS DP1,
706: FA_METHODS ME,
707: FA_BOOKS BO

Line 876: FA_DEPRN_DETAIL DD,

872: FA_LOOKUPS RT,
873: FA_CATEGORY_BOOKS CB,
874: FA_DISTRIBUTION_HISTORY DH,
875: FA_ASSET_HISTORY AH,
876: FA_DEPRN_DETAIL DD,
877: FA_DEPRN_PERIODS DP,
878: FA_BOOKS BO,
879: FA_METHODS ME,
880: FA_TRANSACTION_HEADERS TH

Line 954: FA_DEPRN_DETAIL DD,

950: FA_LOOKUPS RT,
951: FA_CATEGORY_BOOKS CB,
952: FA_DISTRIBUTION_HISTORY DH,
953: FA_ASSET_HISTORY AH,
954: FA_DEPRN_DETAIL DD,
955: FA_DEPRN_PERIODS DP,
956: FA_BOOKS BO,
957: FA_METHODS ME,
958: FA_TRANSACTION_HEADERS TH