DBA Data[Home] [Help]

APPS.JE_JEHUFDAN_XMLP_PKG dependencies on FA_ASSET_HISTORY

Line 277: FA_ASSET_HISTORY AH,

273: FROM
274: FA_LOOKUPS RT,
275: FA_DISTRIBUTION_HISTORY DH,
276: FA_TRANSACTION_HEADERS TH,
277: FA_ASSET_HISTORY AH,
278: FA_ADJUSTMENTS AJ
279: WHERE RT.LOOKUP_TYPE = 'REPORT TYPE'
280: AND RT.LOOKUP_CODE = P_REPORT_TYPE
281: AND DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK

Line 386: FA_ASSET_HISTORY AH,

382: FROM
383: FA_LOOKUPS RT,
384: FA_DISTRIBUTION_HISTORY DH,
385: FA_TRANSACTION_HEADERS TH,
386: FA_ASSET_HISTORY AH,
387: FA_ADJUSTMENTS AJ,
388: FA_METHODS ME,
389: FA_BOOKS BO,
390: FA_DEPRN_PERIODS DP

Line 462: FA_ASSET_HISTORY AH,

458: FA_LOOKUPS RT,
459: FA_DISTRIBUTION_HISTORY DH,
460: FA_CATEGORY_BOOKS CB,
461: FA_TRANSACTION_HEADERS TH,
462: FA_ASSET_HISTORY AH,
463: FA_ADJUSTMENTS AJ,
464: FA_LOOKUPS LO,
465: FA_METHODS ME,
466: FA_BOOKS BO

Line 535: FA_ASSET_HISTORY AH,

531: FROM
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

Line 611: FA_ASSET_HISTORY AH,

607: FROM
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

Line 702: FA_ASSET_HISTORY AH,

698: FROM
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,

Line 798: FA_ASSET_HISTORY AH,

794: FA_LOOKUPS RT,
795: FA_DISTRIBUTION_HISTORY DH,
796: FA_CATEGORY_BOOKS CB,
797: FA_TRANSACTION_HEADERS TH,
798: FA_ASSET_HISTORY AH,
799: FA_ADJUSTMENTS AJ,
800: FA_LOOKUPS LO,
801: FA_METHODS ME,
802: FA_BOOKS BO

Line 875: FA_ASSET_HISTORY AH,

871: FROM
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,

Line 953: FA_ASSET_HISTORY AH,

949: FROM
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,