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.JGRX_FAREG dependencies on FA_ADJUSTMENTS

Line 815: FROM fa_adjustments AD

811: BEGIN
812: SELECT SUM((DECODE(adjustment_type,'RESERVE',adjustment_amount,0)) -
813: (DECODE(adjustment_type,'BONUS RESERVE',adjustment_amount,0)))
814: INTO JGRX_FAREG.var.deprn_reserve
815: FROM fa_adjustments AD
816: WHERE AD.source_type_code in ('RETIREMENT')
817: AND AD.book_type_code = PARM.p_book_type_code
818: AND AD.asset_id = JGRX_FAREG.var.asset_id
819: AND AD.debit_credit_flag = 'DR'

Line 824: FROM fa_adjustments AD

820: AND transaction_header_id = JGRX_FAREG.var.transaction_header_id;
821:
822: SELECT SUM(DECODE(adjustment_type,'BONUS RESERVE',adjustment_amount,0))
823: INTO JGRX_FAREG.var.bonus_reserve
824: FROM fa_adjustments AD
825: WHERE AD.source_type_code in ('RETIREMENT')
826: AND AD.book_type_code = PARM.p_book_type_code
827: AND AD.asset_id = JGRX_FAREG.var.asset_id
828: AND AD.debit_credit_flag = 'DR'

Line 1273: fa_adjustments AD

1269: SELECT SUM(AD.adjustment_amount)
1270: INTO X_partial_addition
1271: FROM fa_books BO,
1272: fa_transaction_headers TH,
1273: fa_adjustments AD
1274: WHERE BO.book_type_code = PARM.p_book_type_code
1275: AND BO.asset_id = JGRX_FAREG.var.asset_id
1276: AND BO.transaction_header_id_in <> NVL(X_transaction_id_initial, 0)
1277: AND BO.book_type_code = TH.book_type_code

Line 1301: fa_adjustments AD

1297:
1298: SELECT SUM(AD.adjustment_amount)
1299: INTO X_manual_adjustment_plus
1300: FROM fa_transaction_headers TH,
1301: fa_adjustments AD
1302: WHERE AD.transaction_header_id = TH.transaction_header_id
1303: AND AD.book_type_code = TH.book_type_code
1304: AND AD.asset_id = TH.asset_id
1305: AND TH.transaction_type_code = 'ADJUSTMENT'

Line 1322: fa_adjustments AD

1318:
1319: SELECT SUM(AD.adjustment_amount)
1320: INTO X_revaluation_plus
1321: FROM fa_transaction_headers TH,
1322: fa_adjustments AD
1323: WHERE AD.transaction_header_id = TH.transaction_header_id
1324: AND AD.book_type_code = TH.book_type_code
1325: AND AD.asset_id = TH.asset_id
1326: AND TH.transaction_type_code = 'REVALUATION'

Line 1394: fa_adjustments AD

1390: SELECT SUM(AD.adjustment_amount)
1391: INTO X_credit_memos
1392: FROM fa_books BO,
1393: fa_transaction_headers TH,
1394: fa_adjustments AD
1395: WHERE BO.book_type_code = PARM.p_book_type_code
1396: AND BO.asset_id = JGRX_FAREG.var.asset_id
1397: AND BO.transaction_header_id_in <> NVL(X_transaction_id_initial, 0)
1398: AND BO.book_type_code = TH.book_type_code

Line 1422: fa_adjustments AD

1418:
1419: SELECT SUM(AD.adjustment_amount)
1420: INTO X_manual_adjustment_minus
1421: FROM fa_transaction_headers TH,
1422: fa_adjustments AD
1423: WHERE AD.transaction_header_id = TH.transaction_header_id
1424: AND AD.book_type_code = TH.book_type_code
1425: AND AD.asset_id = TH.asset_id
1426: AND TH.transaction_type_code = 'ADJUSTMENT'

Line 1443: fa_adjustments AD

1439:
1440: SELECT SUM(AD.adjustment_amount)
1441: INTO X_revaluation_minus
1442: FROM fa_transaction_headers TH,
1443: fa_adjustments AD
1444: WHERE AD.transaction_header_id = TH.transaction_header_id
1445: AND AD.book_type_code = TH.book_type_code
1446: AND AD.asset_id = TH.asset_id
1447: AND TH.transaction_type_code = 'REVALUATION'

Line 1507: FROM fa_adjustments

1503: -- Get initial value
1504: SELECT SUM(DECODE(debit_credit_flag, 'DR', adjustment_amount, 0)) -
1505: SUM(DECODE(debit_credit_flag, 'CR', adjustment_amount, 0))
1506: INTO JGRX_FAREG.var.revaluation_initial
1507: FROM fa_adjustments
1508: WHERE book_type_code = PARM.p_book_type_code
1509: AND asset_id = JGRX_FAREG.var.asset_id
1510: AND source_type_code = 'REVALUATION'
1511: AND adjustment_type = 'COST'

Line 1528: FROM fa_adjustments

1524: -- Get final value
1525: SELECT SUM(DECODE(debit_credit_flag, 'DR', adjustment_amount, 0)) -
1526: SUM(DECODE(debit_credit_flag, 'CR', adjustment_amount, 0))
1527: INTO JGRX_FAREG.var.revaluation_final
1528: FROM fa_adjustments
1529: WHERE book_type_code = PARM.p_book_type_code
1530: AND asset_id = JGRX_FAREG.var.asset_id
1531: AND source_type_code = 'REVALUATION'
1532: AND adjustment_type = 'COST'

Line 1569: FROM fa_adjustments AD

1565:
1566: SELECT SUM(DECODE(DEBIT_CREDIT_FLAG,'DR',AD.adjustment_amount,0)),
1567: SUM(DECODE(DEBIT_CREDIT_FLAG,'CR',AD.adjustment_amount,0))
1568: INTO JGRX_FAREG.var.revaluation_increase,JGRX_FAREG.var.revaluation_decrease
1569: FROM fa_adjustments AD
1570: WHERE AD.book_type_code = PARM.p_book_type_code
1571: AND AD.asset_id = JGRX_FAREG.var.asset_id
1572: AND AD.source_type_code = 'REVALUATION'
1573: AND AD.adjustment_type = 'COST'

Line 1709: FROM fa_adjustments AD

1705:
1706: SELECT abs(SUM(DECODE(adjustment_type,'RESERVE',adjustment_amount,0)) -
1707: SUM(DECODE(adjustment_type,'BONUS RESERVE',adjustment_amount,0)))
1708: INTO X_reinstatements
1709: FROM fa_adjustments AD
1710: WHERE AD.source_type_code in ('RETIREMENT','REVALUATION')
1711: AND AD.book_type_code = PARM.p_book_type_code
1712: AND AD.asset_id = JGRX_FAREG.var.asset_id
1713: AND AD.debit_credit_flag = 'CR'

Line 1725: FROM fa_adjustments AD

1721: FA_RX_UTIL_PKG.debug('Get positive tax reserve adjustment ');
1722:
1723: SELECT SUM(adjustment_amount)
1724: INTO X_tax_re_adjustment_plus
1725: FROM fa_adjustments AD
1726: WHERE AD.source_type_code = 'TAX'
1727: AND AD.adjustment_type = 'RESERVE'
1728: AND AD.debit_credit_flag = 'CR'
1729: AND AD.book_type_code = PARM.p_book_type_code

Line 1770: FROM fa_adjustments AD

1766:
1767: SELECT abs(SUM(DECODE(adjustment_type,'RESERVE',adjustment_amount,0)) -
1768: SUM(DECODE(adjustment_type,'BONUS RESERVE',adjustment_amount,0)))
1769: INTO X_retirements
1770: FROM fa_adjustments AD
1771: WHERE AD.source_type_code in ('RETIREMENT','REVALUATION')
1772: AND AD.book_type_code = PARM.p_book_type_code
1773: AND AD.asset_id = JGRX_FAREG.var.asset_id
1774: AND AD.debit_credit_flag = 'DR'

Line 1790: FROM fa_adjustments AD

1786:
1787: SELECT abs(SUM(DECODE(adjustment_type,'EXPENSE',adjustment_amount,0)) -
1788: SUM(DECODE(adjustment_type,'BONUS EXPENSE',adjustment_amount,0)))
1789: INTO X_financ_adjustment_minus
1790: FROM fa_adjustments AD
1791: WHERE AD.source_type_code = 'DEPRECIATION'
1792: AND AD.adjustment_amount < 0
1793: AND AD.book_type_code = PARM.p_book_type_code
1794: AND AD.asset_id = JGRX_FAREG.var.asset_id

Line 1809: FROM fa_adjustments AD

1805: FA_RX_UTIL_PKG.debug('Get negative tax reserve adjustment ');
1806:
1807: SELECT SUM(adjustment_amount)
1808: INTO X_tax_re_adjustment_minus
1809: FROM fa_adjustments AD
1810: WHERE AD.source_type_code = 'TAX'
1811: AND AD.adjustment_type = 'RESERVE'
1812: AND AD.debit_credit_flag = 'DR'
1813: AND AD.book_type_code = PARM.p_book_type_code

Line 1955: FROM fa_adjustments AD

1951: FA_RX_UTIL_PKG.debug('Get reinstatements ');
1952:
1953: SELECT SUM(adjustment_amount)
1954: INTO X_reinstatements
1955: FROM fa_adjustments AD
1956: WHERE AD.source_type_code in ('RETIREMENT','REVALUATION')
1957: AND AD.book_type_code = PARM.p_book_type_code
1958: AND AD.asset_id = JGRX_FAREG.var.asset_id
1959: AND AD.adjustment_type = 'BONUS RESERVE'

Line 1995: FROM fa_adjustments AD

1991: -------------------------------------------------------------------------------
1992: FA_RX_UTIL_PKG.debug('Get retirements and revaluations ');
1993: SELECT ABS(SUM(adjustment_amount))
1994: INTO X_retirements
1995: FROM fa_adjustments AD
1996: WHERE AD.source_type_code in ('RETIREMENT','REVALUATION')
1997: AND AD.adjustment_type = 'BONUS RESERVE'
1998: AND AD.debit_credit_flag = 'DR'
1999: AND AD.book_type_code = PARM.p_book_type_code

Line 2013: FROM fa_adjustments AD

2009: -------------------------------------------------------------------------------
2010: FA_RX_UTIL_PKG.debug('Get Negative financial adjustment ');
2011: SELECT ABS(SUM(adjustment_amount))
2012: INTO X_financ_adjustment_minus
2013: FROM fa_adjustments AD
2014: WHERE AD.source_type_code = 'DEPRECIATION'
2015: AND AD.adjustment_type = 'BONUS EXPENSE'
2016: AND AD.adjustment_amount < 0
2017: AND AD.book_type_code = PARM.p_book_type_code

Line 2204: fa_ADJUSTMENTS AD

2200: TH.transaction_header_id,
2201: TH.transaction_date_entered,
2202: decode(debit_credit_flag,'CR',(-1*AD.ADJUSTMENT_AMOUNT),AD.ADJUSTMENT_AMOUNT) ADJUSTMENT_AMOUNT
2203: FROM fa_transaction_headers TH,
2204: fa_ADJUSTMENTS AD
2205: WHERE AD.transaction_header_id = TH.transaction_header_id
2206: AND AD.book_type_code = TH.book_type_code
2207: AND AD.asset_id = TH.asset_id
2208: AND TH.transaction_type_code = 'ADJUSTMENT'

Line 2309: fa_adjustments AD

2305: TH.transaction_date_entered,
2306: decode(debit_credit_flag,'CR',(-1*sum(AD.ADJUSTMENT_AMOUNT)),sum(AD.ADJUSTMENT_AMOUNT)) ADJUSTMENT_AMOUNT
2307: -- SUM(AD.adjustment_amount) adjustment_amount
2308: FROM fa_transaction_headers TH,
2309: fa_adjustments AD
2310: WHERE AD.transaction_header_id = TH.transaction_header_id
2311: AND AD.book_type_code = TH.book_type_code
2312: AND AD.asset_id = TH.asset_id
2313: AND AD.adjustment_type = 'COST'