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

Line 964: FROM fa_adjustments AD

960: -(DECODE(adjustment_type,'BONUS RESERVE',decode(debit_credit_flag,'DR',adjustment_amount),0)))
961: - SUM((DECODE(adjustment_type,'RESERVE',decode(debit_credit_flag,'CR',adjustment_amount),0))
962: -(DECODE(adjustment_type,'BONUS RESERVE',decode(debit_credit_flag,'CR',adjustment_amount),0)))
963: INTO JG_RX_FAREG.var.deprn_reserve
964: FROM fa_adjustments AD
965: WHERE AD.source_type_code in ('RETIREMENT')
966: AND AD.book_type_code = PARM.p_book_type_code
967: AND AD.asset_id = JG_RX_FAREG.var.asset_id
968: --AND AD.debit_credit_flag = 'DR'

Line 975: FROM fa_adjustments AD

971:
972: SELECT SUM((DECODE(adjustment_type,'BONUS RESERVE',decode(debit_credit_flag,'DR',adjustment_amount),0))
973: -(DECODE(adjustment_type,'BONUS RESERVE',decode(debit_credit_flag,'CR',adjustment_amount),0)))
974: INTO JG_RX_FAREG.var.bonus_reserve
975: FROM fa_adjustments AD
976: WHERE AD.source_type_code in ('RETIREMENT')
977: AND AD.book_type_code = PARM.p_book_type_code
978: AND AD.asset_id = JG_RX_FAREG.var.asset_id
979: --AND AD.debit_credit_flag = 'DR'

Line 1520: fa_adjustments AD

1516: SELECT SUM(AD.adjustment_amount)
1517: INTO X_partial_addition
1518: FROM fa_books BO,
1519: fa_transaction_headers TH,
1520: fa_adjustments AD
1521: WHERE BO.book_type_code = PARM.p_book_type_code
1522: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1523: AND BO.transaction_header_id_in <> NVL(X_transaction_id_initial, 0)
1524: AND BO.book_type_code = TH.book_type_code

Line 1548: fa_adjustments AD

1544:
1545: SELECT SUM(AD.adjustment_amount)
1546: INTO X_manual_adjustment_plus
1547: FROM fa_transaction_headers TH,
1548: fa_adjustments AD
1549: WHERE AD.transaction_header_id = TH.transaction_header_id
1550: AND AD.book_type_code = TH.book_type_code
1551: AND AD.asset_id = TH.asset_id
1552: AND TH.transaction_type_code = 'ADJUSTMENT'

Line 1569: fa_adjustments AD

1565:
1566: SELECT SUM(AD.adjustment_amount)
1567: INTO X_revaluation_plus
1568: FROM fa_transaction_headers TH,
1569: fa_adjustments AD
1570: WHERE AD.transaction_header_id = TH.transaction_header_id
1571: AND AD.book_type_code = TH.book_type_code
1572: AND AD.asset_id = TH.asset_id
1573: AND TH.transaction_type_code = 'REVALUATION'

Line 1641: fa_adjustments AD

1637: SELECT SUM(AD.adjustment_amount)
1638: INTO X_credit_memos
1639: FROM fa_books BO,
1640: fa_transaction_headers TH,
1641: fa_adjustments AD
1642: WHERE BO.book_type_code = PARM.p_book_type_code
1643: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1644: AND BO.transaction_header_id_in <> NVL(X_transaction_id_initial, 0)
1645: AND BO.book_type_code = TH.book_type_code

Line 1669: fa_adjustments AD

1665:
1666: SELECT SUM(AD.adjustment_amount)
1667: INTO X_manual_adjustment_minus
1668: FROM fa_transaction_headers TH,
1669: fa_adjustments AD
1670: WHERE AD.transaction_header_id = TH.transaction_header_id
1671: AND AD.book_type_code = TH.book_type_code
1672: AND AD.asset_id = TH.asset_id
1673: AND TH.transaction_type_code = 'ADJUSTMENT'

Line 1690: fa_adjustments AD

1686:
1687: SELECT SUM(AD.adjustment_amount)
1688: INTO X_revaluation_minus
1689: FROM fa_transaction_headers TH,
1690: fa_adjustments AD
1691: WHERE AD.transaction_header_id = TH.transaction_header_id
1692: AND AD.book_type_code = TH.book_type_code
1693: AND AD.asset_id = TH.asset_id
1694: AND TH.transaction_type_code = 'REVALUATION'

Line 1754: FROM fa_adjustments

1750: -- Get initial value
1751: SELECT SUM(DECODE(debit_credit_flag, 'DR', adjustment_amount, 0)) -
1752: SUM(DECODE(debit_credit_flag, 'CR', adjustment_amount, 0))
1753: INTO JG_RX_FAREG.var.revaluation_initial
1754: FROM fa_adjustments
1755: WHERE book_type_code = PARM.p_book_type_code
1756: AND asset_id = JG_RX_FAREG.var.asset_id
1757: AND source_type_code = 'REVALUATION'
1758: AND adjustment_type = 'COST'

Line 1775: FROM fa_adjustments

1771: -- Get final value
1772: SELECT SUM(DECODE(debit_credit_flag, 'DR', adjustment_amount, 0)) -
1773: SUM(DECODE(debit_credit_flag, 'CR', adjustment_amount, 0))
1774: INTO JG_RX_FAREG.var.revaluation_final
1775: FROM fa_adjustments
1776: WHERE book_type_code = PARM.p_book_type_code
1777: AND asset_id = JG_RX_FAREG.var.asset_id
1778: AND source_type_code = 'REVALUATION'
1779: AND adjustment_type = 'COST'

Line 1816: FROM fa_adjustments AD

1812:
1813: SELECT SUM(DECODE(DEBIT_CREDIT_FLAG,'DR',AD.adjustment_amount,0)),
1814: SUM(DECODE(DEBIT_CREDIT_FLAG,'CR',AD.adjustment_amount,0))
1815: INTO JG_RX_FAREG.var.revaluation_increase,JG_RX_FAREG.var.revaluation_decrease
1816: FROM fa_adjustments AD
1817: WHERE AD.book_type_code = PARM.p_book_type_code
1818: AND AD.asset_id = JG_RX_FAREG.var.asset_id
1819: AND AD.source_type_code = 'REVALUATION'
1820: AND AD.adjustment_type = 'COST'

Line 1963: FROM fa_adjustments AD

1959:
1960: SELECT nvl(abs(SUM(DECODE(adjustment_type,'RESERVE',adjustment_amount,0)) -
1961: SUM(DECODE(adjustment_type,'BONUS RESERVE',adjustment_amount,0))),0)
1962: INTO X_revaluation_cr
1963: FROM fa_adjustments AD
1964: WHERE AD.source_type_code = 'REVALUATION' -- bug 5208066 removed reinstatement
1965: AND AD.book_type_code = PARM.p_book_type_code
1966: AND AD.asset_id = JG_RX_FAREG.var.asset_id
1967: AND AD.debit_credit_flag = 'CR'

Line 1977: FROM fa_adjustments AD, fa_transaction_headers ft

1973: SELECT nvl(abs(SUM(DECODE(adjustment_type,'RESERVE', DECODE(debit_credit_flag , 'CR' ,adjustment_amount, 'DR', (-1*adjustment_amount),0),0)) -
1974: SUM(DECODE(adjustment_type,'BONUS RESERVE',DECODE(debit_credit_flag , 'CR' ,adjustment_amount, 'DR', (-1*adjustment_amount),0),0))),0)
1975:
1976: INTO X_reinstatements
1977: FROM fa_adjustments AD, fa_transaction_headers ft
1978: WHERE AD.source_type_code = 'RETIREMENT'
1979: AND AD.book_type_code = PARM.p_book_type_code
1980: AND AD.asset_id = JG_RX_FAREG.var.asset_id
1981: and ft.asset_id = ad.asset_id

Line 1998: FROM fa_adjustments AD

1994: FA_RX_UTIL_PKG.debug('Get positive tax reserve adjustment ');
1995:
1996: SELECT SUM(adjustment_amount)
1997: INTO X_tax_re_adjustment_plus
1998: FROM fa_adjustments AD
1999: WHERE AD.source_type_code = 'TAX'
2000: AND AD.adjustment_type = 'RESERVE'
2001: AND AD.debit_credit_flag = 'CR'
2002: AND AD.book_type_code = PARM.p_book_type_code

Line 2044: FROM fa_adjustments AD

2040:
2041: SELECT nvl(abs(SUM(DECODE(adjustment_type,'RESERVE',adjustment_amount,0)) -
2042: SUM(DECODE(adjustment_type,'BONUS RESERVE',adjustment_amount,0))),0)
2043: INTO X_revaluation_dr
2044: FROM fa_adjustments AD
2045: WHERE AD.source_type_code = 'REVALUATION' --bug 5208066 removed retirement
2046: AND AD.book_type_code = PARM.p_book_type_code
2047: AND AD.asset_id = JG_RX_FAREG.var.asset_id
2048: AND AD.debit_credit_flag = 'DR'

Line 2057: FROM fa_adjustments AD, fa_transaction_headers ft

2053: SELECT nvl(abs(SUM(DECODE(adjustment_type,'RESERVE', DECODE(debit_credit_flag , 'DR' ,adjustment_amount, 'CR', (-1*adjustment_amount),0),0)) -
2054: SUM(DECODE(adjustment_type,'BONUS RESERVE',DECODE(debit_credit_flag , 'DR' ,adjustment_amount, 'CR', (-1*adjustment_amount),0),0))),0)
2055:
2056: INTO X_retirements
2057: FROM fa_adjustments AD, fa_transaction_headers ft
2058: WHERE AD.source_type_code = 'RETIREMENT'
2059: AND AD.book_type_code = PARM.p_book_type_code
2060: AND AD.asset_id = JG_RX_FAREG.var.asset_id
2061: and ft.asset_id = ad.asset_id

Line 2080: FROM fa_adjustments AD

2076:
2077: SELECT abs(SUM(DECODE(adjustment_type,'EXPENSE',adjustment_amount,0)) -
2078: SUM(DECODE(adjustment_type,'BONUS EXPENSE',adjustment_amount,0)))
2079: INTO X_financ_adjustment_minus
2080: FROM fa_adjustments AD
2081: WHERE AD.source_type_code = 'DEPRECIATION'
2082: AND AD.adjustment_amount < 0
2083: AND AD.book_type_code = PARM.p_book_type_code
2084: AND AD.asset_id = JG_RX_FAREG.var.asset_id

Line 2099: FROM fa_adjustments AD

2095: FA_RX_UTIL_PKG.debug('Get negative tax reserve adjustment ');
2096:
2097: SELECT SUM(adjustment_amount)
2098: INTO X_tax_re_adjustment_minus
2099: FROM fa_adjustments AD
2100: WHERE AD.source_type_code = 'TAX'
2101: AND AD.adjustment_type = 'RESERVE'
2102: AND AD.debit_credit_flag = 'DR'
2103: AND AD.book_type_code = PARM.p_book_type_code

Line 2245: FROM fa_adjustments AD

2241: FA_RX_UTIL_PKG.debug('Get reinstatements ');
2242:
2243: SELECT SUM(adjustment_amount)
2244: INTO X_reinstatements
2245: FROM fa_adjustments AD
2246: WHERE AD.source_type_code in ('RETIREMENT','REVALUATION')
2247: AND AD.book_type_code = PARM.p_book_type_code
2248: AND AD.asset_id = JG_RX_FAREG.var.asset_id
2249: AND AD.adjustment_type = 'BONUS RESERVE'

Line 2285: FROM fa_adjustments AD

2281: -------------------------------------------------------------------------------
2282: FA_RX_UTIL_PKG.debug('Get retirements and revaluations ');
2283: SELECT ABS(SUM(adjustment_amount))
2284: INTO X_retirements
2285: FROM fa_adjustments AD
2286: WHERE AD.source_type_code in ('RETIREMENT','REVALUATION')
2287: AND AD.adjustment_type = 'BONUS RESERVE'
2288: AND AD.debit_credit_flag = 'DR'
2289: AND AD.book_type_code = PARM.p_book_type_code

Line 2303: FROM fa_adjustments AD

2299: -------------------------------------------------------------------------------
2300: FA_RX_UTIL_PKG.debug('Get Negative financial adjustment ');
2301: SELECT ABS(SUM(adjustment_amount))
2302: INTO X_financ_adjustment_minus
2303: FROM fa_adjustments AD
2304: WHERE AD.source_type_code = 'DEPRECIATION'
2305: AND AD.adjustment_type = 'BONUS EXPENSE'
2306: AND AD.adjustment_amount < 0
2307: AND AD.book_type_code = PARM.p_book_type_code

Line 2505: fa_ADJUSTMENTS AD

2501: TH.transaction_header_id,
2502: TH.transaction_date_entered,
2503: decode(debit_credit_flag,'CR',(-1*AD.ADJUSTMENT_AMOUNT),AD.ADJUSTMENT_AMOUNT) ADJUSTMENT_AMOUNT
2504: FROM fa_transaction_headers TH,
2505: fa_ADJUSTMENTS AD
2506: WHERE AD.transaction_header_id = TH.transaction_header_id
2507: AND AD.book_type_code = TH.book_type_code
2508: AND AD.asset_id = TH.asset_id
2509: AND TH.transaction_type_code = 'ADJUSTMENT'

Line 2610: fa_adjustments AD

2606: TH.transaction_date_entered,
2607: decode(debit_credit_flag,'CR',(-1*sum(AD.ADJUSTMENT_AMOUNT)),sum(AD.ADJUSTMENT_AMOUNT)) ADJUSTMENT_AMOUNT
2608: -- SUM(AD.adjustment_amount) adjustment_amount
2609: FROM fa_transaction_headers TH,
2610: fa_adjustments AD
2611: WHERE AD.transaction_header_id = TH.transaction_header_id
2612: AND AD.book_type_code = TH.book_type_code
2613: AND AD.asset_id = TH.asset_id
2614: AND AD.adjustment_type = 'COST'