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 761: FA_DISTRIBUTION_HISTORY DH,

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

Line 810: FA_DISTRIBUTION_HISTORY DH,

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

Line 842: FA_DISTRIBUTION_HISTORY DH,

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

Line 843: FA_DISTRIBUTION_HISTORY DH_PRIOR,

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

Line 890: FA_DISTRIBUTION_HISTORY DH,

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