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.FA_RSVLDG_REP_INS_PKG dependencies on FA_DEPRN_PERIODS

Line 60: FA_DEPRN_PERIODS_MRC_V DP,

56: upc,
57: tod,
58: tpc
59: FROM
60: FA_DEPRN_PERIODS_MRC_V DP,
61: FA_DEPRN_PERIODS_MRC_V DP_FY,
62: FA_BOOK_CONTROLS_MRC_V BC
63: WHERE
64: DP.BOOK_TYPE_CODE = book AND

Line 61: FA_DEPRN_PERIODS_MRC_V DP_FY,

57: tod,
58: tpc
59: FROM
60: FA_DEPRN_PERIODS_MRC_V DP,
61: FA_DEPRN_PERIODS_MRC_V DP_FY,
62: FA_BOOK_CONTROLS_MRC_V BC
63: WHERE
64: DP.BOOK_TYPE_CODE = book AND
65: DP.PERIOD_NAME = period AND

Line 87: FA_DEPRN_PERIODS DP,

83: upc,
84: tod,
85: tpc
86: FROM
87: FA_DEPRN_PERIODS DP,
88: FA_DEPRN_PERIODS DP_FY,
89: FA_BOOK_CONTROLS BC
90: WHERE
91: DP.BOOK_TYPE_CODE = book AND

Line 88: FA_DEPRN_PERIODS DP_FY,

84: tod,
85: tpc
86: FROM
87: FA_DEPRN_PERIODS DP,
88: FA_DEPRN_PERIODS DP_FY,
89: FA_BOOK_CONTROLS BC
90: WHERE
91: DP.BOOK_TYPE_CODE = book AND
92: DP.PERIOD_NAME = period AND

Line 213: FA_DEPRN_PERIODS DP

209: FA_TRANSACTION_HEADERS TH_RT,
210: FA_CATEGORY_BOOKS CB,
211: FA_ADDITIONS AD,
212: FA_BONUS_RATES BR,
213: FA_DEPRN_PERIODS DP
214: WHERE BOOKS.BOOK_TYPE_CODE = book
215: AND BOOKS.ASSET_ID = DD_BONUS.ASSET_ID --7721457
216: AND BOOKS.ASSET_ID = AD.ASSET_ID
217: AND NVL(BOOKS.PERIOD_COUNTER_FULLY_RETIRED, upc) >= tpc

Line 289: FA_DEPRN_PERIODS DP

285: FA_TRANSACTION_HEADERS TH_RT,
286: FA_CATEGORY_BOOKS CB,
287: FA_ADDITIONS AD,
288: FA_BONUS_RATES BR,
289: FA_DEPRN_PERIODS DP
290: WHERE BOOKS.BOOK_TYPE_CODE = book
291: AND BOOKS.ASSET_ID = DD.ASSET_ID --7721457
292: AND BOOKS.ASSET_ID = AD.ASSET_ID
293: AND NVL(BOOKS.PERIOD_COUNTER_FULLY_RETIRED, upc) >= tpc

Line 389: FA_DEPRN_PERIODS DP

385: FA_TRANSACTION_HEADERS TH_RT,
386: FA_CATEGORY_BOOKS CB ,
387: FA_ADDITIONS AD,
388: FA_BONUS_RATES BR,
389: FA_DEPRN_PERIODS DP
390: WHERE BOOKS.BOOK_TYPE_CODE = book
391: AND BOOKS.ASSET_ID = DD_BONUS.ASSET_ID --7721457
392: AND BOOKS.ASSET_ID = AD.ASSET_ID
393: AND NVL(BOOKS.PERIOD_COUNTER_FULLY_RETIRED, upc) >= tpc

Line 465: FA_DEPRN_PERIODS DP

461: FA_TRANSACTION_HEADERS TH_RT,
462: FA_CATEGORY_BOOKS CB ,
463: FA_ADDITIONS AD,
464: FA_BONUS_RATES BR,
465: FA_DEPRN_PERIODS DP
466: WHERE BOOKS.BOOK_TYPE_CODE = book
467: AND BOOKS.ASSET_ID = DD.ASSET_ID --7721457
468: AND BOOKS.ASSET_ID = AD.ASSET_ID
469: AND NVL(BOOKS.PERIOD_COUNTER_FULLY_RETIRED, upc) >= tpc

Line 564: FA_DEPRN_PERIODS DP

560: FA_TRANSACTION_HEADERS TH_RT,
561: FA_CATEGORY_BOOKS CB,
562: FA_ADDITIONS AD,
563: FA_BONUS_RATES BR,
564: FA_DEPRN_PERIODS DP
565: WHERE BOOKS.BOOK_TYPE_CODE = book
566: AND BOOKS.ASSET_ID = DD_BONUS.ASSET_ID --7721457
567: AND BOOKS.ASSET_ID = AD.ASSET_ID
568: AND NVL(BOOKS.PERIOD_COUNTER_FULLY_RETIRED, upc) >= tpc

Line 666: FA_DEPRN_PERIODS DP

662: FA_TRANSACTION_HEADERS TH_DIST_END,
663: FA_CATEGORY_BOOKS CB ,
664: FA_ADDITIONS AD,
665: FA_BONUS_RATES BR,
666: FA_DEPRN_PERIODS DP
667: WHERE BOOKS.BOOK_TYPE_CODE = book
668: AND BOOKS.ASSET_ID = DD_BONUS.ASSET_ID --7721457
669: AND BOOKS.ASSET_ID = AD.ASSET_ID
670: AND NVL(BOOKS.PERIOD_COUNTER_FULLY_RETIRED, upc) >= tpc

Line 776: FA_DEPRN_PERIODS DP

772: FA_TRANSACTION_HEADERS TH_RT,
773: FA_CATEGORY_BOOKS CB ,
774: FA_ADDITIONS AD,
775: FA_BONUS_RATES BR,
776: FA_DEPRN_PERIODS DP
777: WHERE books.group_asset_id IS NULL
778: AND CB.BOOK_TYPE_CODE = book
779: AND CB.CATEGORY_ID = AH.CATEGORY_ID
780: AND AH.ASSET_ID = DD.ASSET_ID --7721457

Line 880: FA_DEPRN_PERIODS DP

876: FA_TRANSACTION_HEADERS TH_RT,
877: FA_CATEGORY_BOOKS CB ,
878: FA_ADDITIONS AD,
879: FA_BONUS_RATES BR,
880: FA_DEPRN_PERIODS DP
881: WHERE books.group_asset_id IS NULL
882: AND CB.BOOK_TYPE_CODE = book
883: AND CB.CATEGORY_ID = AH.CATEGORY_ID
884: AND DD.DISTRIBUTION_ID = DD1.DISTRIBUTION_ID --7721457

Line 978: FA_DEPRN_PERIODS_MRC_V DP,

974: GAD.ASSET_COST_ACCT
975: FROM FA_DEPRN_SUMMARY_MRC_V DD ,
976: FA_GROUP_ASSET_RULES GAR ,
977: FA_GROUP_ASSET_DEFAULT GAD,
978: FA_DEPRN_PERIODS_MRC_V DP,
979: FA_ADDITIONS AD,
980: FA_BONUS_RATES BR
981: WHERE DD.BOOK_TYPE_CODE = book
982: AND DD.ASSET_ID = GAR.GROUP_ASSET_ID

Line 1063: FA_DEPRN_PERIODS DP,

1059: GAD.ASSET_COST_ACCT
1060: FROM FA_DEPRN_SUMMARY DD ,
1061: FA_GROUP_ASSET_RULES GAR ,
1062: FA_GROUP_ASSET_DEFAULT GAD,
1063: FA_DEPRN_PERIODS DP,
1064: FA_ADDITIONS AD,
1065: FA_BONUS_RATES BR
1066: WHERE DD.BOOK_TYPE_CODE = book
1067: AND DD.ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE

Line 1143: FA_DEPRN_PERIODS_MRC_V DP,

1139: FROM FA_DEPRN_SUMMARY_MRC_V DD ,
1140: fa_GROUP_ASSET_RULES GAR ,
1141: fa_GROUP_ASSET_DEFAULT GAD,
1142: fa_SUPER_GROUP_RULES SGR ,
1143: FA_DEPRN_PERIODS_MRC_V DP,
1144: FA_ADDITIONS AD,
1145: FA_BONUS_RATES BR
1146: WHERE DD.BOOK_TYPE_CODE = book
1147: AND DD.ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE

Line 1221: FA_DEPRN_PERIODS DP,

1217: FROM FA_DEPRN_SUMMARY DD ,
1218: fa_GROUP_ASSET_RULES GAR ,
1219: fa_GROUP_ASSET_DEFAULT GAD,
1220: fa_SUPER_GROUP_RULES SGR ,
1221: FA_DEPRN_PERIODS DP,
1222: FA_ADDITIONS AD,
1223: FA_BONUS_RATES BR
1224: WHERE DD.BOOK_TYPE_CODE = book
1225: AND DD.ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE