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_AL dependencies on FA_DISTRIBUTION_HISTORY

Line 386: FA_DISTRIBUTION_HISTORY DH,

382: FROM
383: FA_CATEGORY_BOOKS CB,
384: FA_ASSET_HISTORY AH,
385: FA_BOOKS BOOKS,
386: FA_DISTRIBUTION_HISTORY DH,
387: GL_CODE_COMBINATIONS CC,
388: PER_PEOPLE_F EMP,
389: FA_ADDITIONS AD,
390: FA_CATEGORIES CAT,

Line 453: FA_DISTRIBUTION_HISTORY DH,

449: FROM
450: FA_CATEGORY_BOOKS CB,
451: FA_ASSET_HISTORY AH,
452: FA_BOOKS_mrc_v BOOKS,
453: FA_DISTRIBUTION_HISTORY DH,
454: GL_CODE_COMBINATIONS CC,
455: PER_PEOPLE_F EMP,
456: FA_ADDITIONS AD,
457: FA_CATEGORIES CAT,

Line 681: FA_DISTRIBUTION_HISTORY DH,

677: DECODE(DD.PERIOD_COUNTER, upc, DD.DEPRN_AMOUNT,0) DEPRN_AMOUNT,
678: DH.UNITS_ASSIGNED UNITS
679: FROM
680: FA_DEPRN_DETAIL DD,
681: FA_DISTRIBUTION_HISTORY DH,
682: FA_BOOK_CONTROLS BC -- Added for Bug#2675646
683: WHERE
684: DD.ASSET_ID = h_asset_id AND
685: DD.BOOK_TYPE_CODE = h_book AND

Line 713: FA_DISTRIBUTION_HISTORY DH,

709: DECODE(DD.PERIOD_COUNTER, upc, DD.DEPRN_AMOUNT,0) DEPRN_AMOUNT,
710: 0 UNITS
711: FROM
712: FA_DEPRN_DETAIL DD,
713: FA_DISTRIBUTION_HISTORY DH,
714: FA_DISTRIBUTION_HISTORY DH_PRIOR,
715: FA_BOOK_CONTROLS BC -- Added for Bug#2675646
716: WHERE
717: DD.ASSET_ID = h_asset_id AND

Line 714: FA_DISTRIBUTION_HISTORY DH_PRIOR,

710: 0 UNITS
711: FROM
712: FA_DEPRN_DETAIL DD,
713: FA_DISTRIBUTION_HISTORY DH,
714: FA_DISTRIBUTION_HISTORY DH_PRIOR,
715: FA_BOOK_CONTROLS BC -- Added for Bug#2675646
716: WHERE
717: DD.ASSET_ID = h_asset_id AND
718: DD.BOOK_TYPE_CODE = h_book AND

Line 759: FA_DISTRIBUTION_HISTORY DH,

755: DH.UNITS_ASSIGNED,0) UNITS
756: FROM
757: FA_ADJUSTMENTS ADJ,
758: FA_LOOKUPS LU,
759: FA_DISTRIBUTION_HISTORY DH,
760: FA_BOOK_CONTROLS BC -- Added for Bug#2675646
761: WHERE
762: LU.LOOKUP_TYPE = 'JOURNAL ENTRIES' AND
763: ((ADJ.ADJUSTMENT_TYPE IN ('COST','CIP COST') AND

Line 808: FA_DISTRIBUTION_HISTORY DH,

804: DECODE(DD.PERIOD_COUNTER, upc, DD.DEPRN_AMOUNT,0) DEPRN_AMOUNT,
805: DH.UNITS_ASSIGNED UNITS
806: FROM
807: FA_DEPRN_DETAIL_mrc_v DD,
808: FA_DISTRIBUTION_HISTORY DH,
809: FA_BOOK_CONTROLS_mrc_v BC -- Added for Bug#2675646
810: WHERE
811: DD.ASSET_ID = h_asset_id AND
812: DD.BOOK_TYPE_CODE = h_book AND

Line 840: FA_DISTRIBUTION_HISTORY DH,

836: DECODE(DD.PERIOD_COUNTER, upc, DD.DEPRN_AMOUNT,0) DEPRN_AMOUNT,
837: 0 UNITS
838: FROM
839: FA_DEPRN_DETAIL_mrc_v DD,
840: FA_DISTRIBUTION_HISTORY DH,
841: FA_DISTRIBUTION_HISTORY DH_PRIOR,
842: FA_BOOK_CONTROLS_mrc_v BC -- Added for Bug#2675646
843: WHERE
844: DD.ASSET_ID = h_asset_id AND

Line 841: FA_DISTRIBUTION_HISTORY DH_PRIOR,

837: 0 UNITS
838: FROM
839: FA_DEPRN_DETAIL_mrc_v DD,
840: FA_DISTRIBUTION_HISTORY DH,
841: FA_DISTRIBUTION_HISTORY DH_PRIOR,
842: FA_BOOK_CONTROLS_mrc_v BC -- Added for Bug#2675646
843: WHERE
844: DD.ASSET_ID = h_asset_id AND
845: DD.BOOK_TYPE_CODE = h_book AND

Line 886: FA_DISTRIBUTION_HISTORY DH,

882: DH.UNITS_ASSIGNED,0) UNITS
883: FROM
884: FA_ADJUSTMENTS_mrc_v ADJ,
885: FA_LOOKUPS LU,
886: FA_DISTRIBUTION_HISTORY DH,
887: FA_BOOK_CONTROLS_mrc_v BC -- Added for Bug#2675646
888: WHERE
889: LU.LOOKUP_TYPE = 'JOURNAL ENTRIES' AND
890: ((ADJ.ADJUSTMENT_TYPE IN ('COST','CIP COST') AND