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.

[Home] [Help]

APPS.JG_RX_FAREG dependencies on FA_ADJUSTMENTS

Line 959: FROM fa_adjustments AD

955: BEGIN
956: SELECT SUM((DECODE(adjustment_type,'RESERVE',adjustment_amount,0)) -
957: (DECODE(adjustment_type,'BONUS RESERVE',adjustment_amount,0)))
958: INTO JG_RX_FAREG.var.deprn_reserve
959: FROM fa_adjustments AD
960: WHERE AD.source_type_code in ('RETIREMENT')
961: AND AD.book_type_code = PARM.p_book_type_code
962: AND AD.asset_id = JG_RX_FAREG.var.asset_id
963: AND AD.debit_credit_flag = 'DR'

Line 968: FROM fa_adjustments AD

964: AND transaction_header_id = JG_RX_FAREG.var.transaction_header_id;
965:
966: SELECT SUM(DECODE(adjustment_type,'BONUS RESERVE',adjustment_amount,0))
967: INTO JG_RX_FAREG.var.bonus_reserve
968: FROM fa_adjustments AD
969: WHERE AD.source_type_code in ('RETIREMENT')
970: AND AD.book_type_code = PARM.p_book_type_code
971: AND AD.asset_id = JG_RX_FAREG.var.asset_id
972: AND AD.debit_credit_flag = 'DR'

Line 1504: fa_adjustments AD

1500: SELECT SUM(AD.adjustment_amount)
1501: INTO X_partial_addition
1502: FROM fa_books BO,
1503: fa_transaction_headers TH,
1504: fa_adjustments AD
1505: WHERE BO.book_type_code = PARM.p_book_type_code
1506: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1507: AND BO.transaction_header_id_in <> NVL(X_transaction_id_initial, 0)
1508: AND BO.book_type_code = TH.book_type_code

Line 1532: fa_adjustments AD

1528:
1529: SELECT SUM(AD.adjustment_amount)
1530: INTO X_manual_adjustment_plus
1531: FROM fa_transaction_headers TH,
1532: fa_adjustments AD
1533: WHERE AD.transaction_header_id = TH.transaction_header_id
1534: AND AD.book_type_code = TH.book_type_code
1535: AND AD.asset_id = TH.asset_id
1536: AND TH.transaction_type_code = 'ADJUSTMENT'

Line 1553: fa_adjustments AD

1549:
1550: SELECT SUM(AD.adjustment_amount)
1551: INTO X_revaluation_plus
1552: FROM fa_transaction_headers TH,
1553: fa_adjustments AD
1554: WHERE AD.transaction_header_id = TH.transaction_header_id
1555: AND AD.book_type_code = TH.book_type_code
1556: AND AD.asset_id = TH.asset_id
1557: AND TH.transaction_type_code = 'REVALUATION'

Line 1625: fa_adjustments AD

1621: SELECT SUM(AD.adjustment_amount)
1622: INTO X_credit_memos
1623: FROM fa_books BO,
1624: fa_transaction_headers TH,
1625: fa_adjustments AD
1626: WHERE BO.book_type_code = PARM.p_book_type_code
1627: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1628: AND BO.transaction_header_id_in <> NVL(X_transaction_id_initial, 0)
1629: AND BO.book_type_code = TH.book_type_code

Line 1653: fa_adjustments AD

1649:
1650: SELECT SUM(AD.adjustment_amount)
1651: INTO X_manual_adjustment_minus
1652: FROM fa_transaction_headers TH,
1653: fa_adjustments AD
1654: WHERE AD.transaction_header_id = TH.transaction_header_id
1655: AND AD.book_type_code = TH.book_type_code
1656: AND AD.asset_id = TH.asset_id
1657: AND TH.transaction_type_code = 'ADJUSTMENT'

Line 1674: fa_adjustments AD

1670:
1671: SELECT SUM(AD.adjustment_amount)
1672: INTO X_revaluation_minus
1673: FROM fa_transaction_headers TH,
1674: fa_adjustments AD
1675: WHERE AD.transaction_header_id = TH.transaction_header_id
1676: AND AD.book_type_code = TH.book_type_code
1677: AND AD.asset_id = TH.asset_id
1678: AND TH.transaction_type_code = 'REVALUATION'

Line 1738: FROM fa_adjustments

1734: -- Get initial value
1735: SELECT SUM(DECODE(debit_credit_flag, 'DR', adjustment_amount, 0)) -
1736: SUM(DECODE(debit_credit_flag, 'CR', adjustment_amount, 0))
1737: INTO JG_RX_FAREG.var.revaluation_initial
1738: FROM fa_adjustments
1739: WHERE book_type_code = PARM.p_book_type_code
1740: AND asset_id = JG_RX_FAREG.var.asset_id
1741: AND source_type_code = 'REVALUATION'
1742: AND adjustment_type = 'COST'

Line 1759: FROM fa_adjustments

1755: -- Get final value
1756: SELECT SUM(DECODE(debit_credit_flag, 'DR', adjustment_amount, 0)) -
1757: SUM(DECODE(debit_credit_flag, 'CR', adjustment_amount, 0))
1758: INTO JG_RX_FAREG.var.revaluation_final
1759: FROM fa_adjustments
1760: WHERE book_type_code = PARM.p_book_type_code
1761: AND asset_id = JG_RX_FAREG.var.asset_id
1762: AND source_type_code = 'REVALUATION'
1763: AND adjustment_type = 'COST'

Line 1800: FROM fa_adjustments AD

1796:
1797: SELECT SUM(DECODE(DEBIT_CREDIT_FLAG,'DR',AD.adjustment_amount,0)),
1798: SUM(DECODE(DEBIT_CREDIT_FLAG,'CR',AD.adjustment_amount,0))
1799: INTO JG_RX_FAREG.var.revaluation_increase,JG_RX_FAREG.var.revaluation_decrease
1800: FROM fa_adjustments AD
1801: WHERE AD.book_type_code = PARM.p_book_type_code
1802: AND AD.asset_id = JG_RX_FAREG.var.asset_id
1803: AND AD.source_type_code = 'REVALUATION'
1804: AND AD.adjustment_type = 'COST'

Line 1947: FROM fa_adjustments AD

1943:
1944: SELECT nvl(abs(SUM(DECODE(adjustment_type,'RESERVE',adjustment_amount,0)) -
1945: SUM(DECODE(adjustment_type,'BONUS RESERVE',adjustment_amount,0))),0)
1946: INTO X_revaluation_cr
1947: FROM fa_adjustments AD
1948: WHERE AD.source_type_code = 'REVALUATION' -- bug 5208066 removed reinstatement
1949: AND AD.book_type_code = PARM.p_book_type_code
1950: AND AD.asset_id = JG_RX_FAREG.var.asset_id
1951: AND AD.debit_credit_flag = 'CR'

Line 1961: FROM fa_adjustments AD, fa_transaction_headers ft

1957: SELECT nvl(abs(SUM(DECODE(adjustment_type,'RESERVE', DECODE(debit_credit_flag , 'CR' ,adjustment_amount, 'DR', (-1*adjustment_amount),0),0)) -
1958: SUM(DECODE(adjustment_type,'BONUS RESERVE',DECODE(debit_credit_flag , 'CR' ,adjustment_amount, 'DR', (-1*adjustment_amount),0),0))),0)
1959:
1960: INTO X_reinstatements
1961: FROM fa_adjustments AD, fa_transaction_headers ft
1962: WHERE AD.source_type_code = 'RETIREMENT'
1963: AND AD.book_type_code = PARM.p_book_type_code
1964: AND AD.asset_id = JG_RX_FAREG.var.asset_id
1965: and ft.asset_id = ad.asset_id

Line 1982: FROM fa_adjustments AD

1978: FA_RX_UTIL_PKG.debug('Get positive tax reserve adjustment ');
1979:
1980: SELECT SUM(adjustment_amount)
1981: INTO X_tax_re_adjustment_plus
1982: FROM fa_adjustments AD
1983: WHERE AD.source_type_code = 'TAX'
1984: AND AD.adjustment_type = 'RESERVE'
1985: AND AD.debit_credit_flag = 'CR'
1986: AND AD.book_type_code = PARM.p_book_type_code

Line 2028: FROM fa_adjustments AD

2024:
2025: SELECT nvl(abs(SUM(DECODE(adjustment_type,'RESERVE',adjustment_amount,0)) -
2026: SUM(DECODE(adjustment_type,'BONUS RESERVE',adjustment_amount,0))),0)
2027: INTO X_revaluation_dr
2028: FROM fa_adjustments AD
2029: WHERE AD.source_type_code = 'REVALUATION' --bug 5208066 removed retirement
2030: AND AD.book_type_code = PARM.p_book_type_code
2031: AND AD.asset_id = JG_RX_FAREG.var.asset_id
2032: AND AD.debit_credit_flag = 'DR'

Line 2041: FROM fa_adjustments AD, fa_transaction_headers ft

2037: SELECT nvl(abs(SUM(DECODE(adjustment_type,'RESERVE', DECODE(debit_credit_flag , 'DR' ,adjustment_amount, 'CR', (-1*adjustment_amount),0),0)) -
2038: SUM(DECODE(adjustment_type,'BONUS RESERVE',DECODE(debit_credit_flag , 'DR' ,adjustment_amount, 'CR', (-1*adjustment_amount),0),0))),0)
2039:
2040: INTO X_retirements
2041: FROM fa_adjustments AD, fa_transaction_headers ft
2042: WHERE AD.source_type_code = 'RETIREMENT'
2043: AND AD.book_type_code = PARM.p_book_type_code
2044: AND AD.asset_id = JG_RX_FAREG.var.asset_id
2045: and ft.asset_id = ad.asset_id

Line 2064: FROM fa_adjustments AD

2060:
2061: SELECT abs(SUM(DECODE(adjustment_type,'EXPENSE',adjustment_amount,0)) -
2062: SUM(DECODE(adjustment_type,'BONUS EXPENSE',adjustment_amount,0)))
2063: INTO X_financ_adjustment_minus
2064: FROM fa_adjustments AD
2065: WHERE AD.source_type_code = 'DEPRECIATION'
2066: AND AD.adjustment_amount < 0
2067: AND AD.book_type_code = PARM.p_book_type_code
2068: AND AD.asset_id = JG_RX_FAREG.var.asset_id

Line 2083: FROM fa_adjustments AD

2079: FA_RX_UTIL_PKG.debug('Get negative tax reserve adjustment ');
2080:
2081: SELECT SUM(adjustment_amount)
2082: INTO X_tax_re_adjustment_minus
2083: FROM fa_adjustments AD
2084: WHERE AD.source_type_code = 'TAX'
2085: AND AD.adjustment_type = 'RESERVE'
2086: AND AD.debit_credit_flag = 'DR'
2087: AND AD.book_type_code = PARM.p_book_type_code

Line 2229: FROM fa_adjustments AD

2225: FA_RX_UTIL_PKG.debug('Get reinstatements ');
2226:
2227: SELECT SUM(adjustment_amount)
2228: INTO X_reinstatements
2229: FROM fa_adjustments AD
2230: WHERE AD.source_type_code in ('RETIREMENT','REVALUATION')
2231: AND AD.book_type_code = PARM.p_book_type_code
2232: AND AD.asset_id = JG_RX_FAREG.var.asset_id
2233: AND AD.adjustment_type = 'BONUS RESERVE'

Line 2269: FROM fa_adjustments AD

2265: -------------------------------------------------------------------------------
2266: FA_RX_UTIL_PKG.debug('Get retirements and revaluations ');
2267: SELECT ABS(SUM(adjustment_amount))
2268: INTO X_retirements
2269: FROM fa_adjustments AD
2270: WHERE AD.source_type_code in ('RETIREMENT','REVALUATION')
2271: AND AD.adjustment_type = 'BONUS RESERVE'
2272: AND AD.debit_credit_flag = 'DR'
2273: AND AD.book_type_code = PARM.p_book_type_code

Line 2287: FROM fa_adjustments AD

2283: -------------------------------------------------------------------------------
2284: FA_RX_UTIL_PKG.debug('Get Negative financial adjustment ');
2285: SELECT ABS(SUM(adjustment_amount))
2286: INTO X_financ_adjustment_minus
2287: FROM fa_adjustments AD
2288: WHERE AD.source_type_code = 'DEPRECIATION'
2289: AND AD.adjustment_type = 'BONUS EXPENSE'
2290: AND AD.adjustment_amount < 0
2291: AND AD.book_type_code = PARM.p_book_type_code

Line 2489: fa_ADJUSTMENTS AD

2485: TH.transaction_header_id,
2486: TH.transaction_date_entered,
2487: decode(debit_credit_flag,'CR',(-1*AD.ADJUSTMENT_AMOUNT),AD.ADJUSTMENT_AMOUNT) ADJUSTMENT_AMOUNT
2488: FROM fa_transaction_headers TH,
2489: fa_ADJUSTMENTS AD
2490: WHERE AD.transaction_header_id = TH.transaction_header_id
2491: AND AD.book_type_code = TH.book_type_code
2492: AND AD.asset_id = TH.asset_id
2493: AND TH.transaction_type_code = 'ADJUSTMENT'

Line 2594: fa_adjustments AD

2590: TH.transaction_date_entered,
2591: decode(debit_credit_flag,'CR',(-1*sum(AD.ADJUSTMENT_AMOUNT)),sum(AD.ADJUSTMENT_AMOUNT)) ADJUSTMENT_AMOUNT
2592: -- SUM(AD.adjustment_amount) adjustment_amount
2593: FROM fa_transaction_headers TH,
2594: fa_adjustments AD
2595: WHERE AD.transaction_header_id = TH.transaction_header_id
2596: AND AD.book_type_code = TH.book_type_code
2597: AND AD.asset_id = TH.asset_id
2598: AND AD.adjustment_type = 'COST'