DBA Data[Home] [Help]

APPS.JE_JEHUFDAN_XMLP_PKG dependencies on FA_TRANSACTION_HEADERS

Line 276: FA_TRANSACTION_HEADERS TH,

272: ,-1) * AJ.ADJUSTMENT_AMOUNT)
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

Line 385: FA_TRANSACTION_HEADERS TH,

381: ,-1) * AJ.ADJUSTMENT_AMOUNT)
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,

Line 461: FA_TRANSACTION_HEADERS TH,

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

Line 797: FA_TRANSACTION_HEADERS TH,

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

Line 880: FA_TRANSACTION_HEADERS TH

876: FA_DEPRN_DETAIL DD,
877: FA_DEPRN_PERIODS DP,
878: FA_BOOKS BO,
879: FA_METHODS ME,
880: FA_TRANSACTION_HEADERS TH
881: WHERE DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK
882: AND AH.ASSET_ID = DH.ASSET_ID
883: AND AH.ASSET_TYPE = 'CAPITALIZED'
884: AND AH.DATE_EFFECTIVE < NVL(DH.DATE_INEFFECTIVE

Line 958: FA_TRANSACTION_HEADERS TH

954: FA_DEPRN_DETAIL DD,
955: FA_DEPRN_PERIODS DP,
956: FA_BOOKS BO,
957: FA_METHODS ME,
958: FA_TRANSACTION_HEADERS TH
959: WHERE DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK
960: AND AH.ASSET_ID = DH.ASSET_ID
961: AND AH.ASSET_TYPE = 'CAPITALIZED'
962: AND AH.DATE_EFFECTIVE < NVL(DH.DATE_INEFFECTIVE