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_TRANSACTION_HEADERS

Line 1238: ' from fa_transaction_headers trh,'||

1234: ' dih.book_type_code = '||''''||PARM.p_book_type_code ||''''||' and'||
1235: ' gcc.code_combination_id = dih.code_combination_id'||
1236: ' and dih.transaction_header_id_in =';
1237: v_selectstmnt2 := '(select to_char(MAX(transaction_heaDer_id))'||
1238: ' from fa_transaction_headers trh,'||
1239: ' fa_distribution_history dih1'||
1240: ' where dih1.asset_id= dih.asset_id and'||
1241: ' dih1.book_type_code =dih.book_type_code and'||
1242: ' dih1.transaction_header_id_in = trh.transaction_header_id and';

Line 1410: FROM fa_books BO1, fa_transaction_headers TRH

1406: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1407: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1408: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),
1409: max(transaction_header_id_in)
1410: FROM fa_books BO1, fa_transaction_headers TRH
1411: WHERE BO1.book_type_code = BO.book_type_code
1412: AND BO1.asset_id = BO.asset_id
1413: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1414: AND TRH.transaction_date_entered < PARM.p_begin_period_from_date);

Line 1436: FROM fa_books BO1,FA_TRANSACTION_HEADERS TRH

1432: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1433: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1434: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),
1435: max(transaction_header_id_in)
1436: FROM fa_books BO1,FA_TRANSACTION_HEADERS TRH
1437: WHERE BO1.book_type_code = BO.book_type_code
1438: AND BO1.asset_id = BO.asset_id
1439: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1440: AND TRH.transaction_date_entered <= PARM.p_end_period_to_date);

Line 1503: fa_transaction_headers TH,

1499:
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)

Line 1531: FROM fa_transaction_headers TH,

1527: FA_RX_UTIL_PKG.debug('Get manual adjustment upwards');
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

Line 1552: FROM fa_transaction_headers TH,

1548: FA_RX_UTIL_PKG.debug('Get revaluations upward ');
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

Line 1574: FROM fa_transaction_headers TH,

1570: FA_RX_UTIL_PKG.debug('Get reinstatements ');
1571:
1572: SELECT SUM(RE.cost_retired)
1573: INTO X_reinstatements
1574: FROM fa_transaction_headers TH,
1575: fa_retirements RE
1576: WHERE RE.transaction_header_id_out = TH.transaction_header_id
1577: AND RE.book_type_code = TH.book_type_code
1578: AND RE.asset_id = TH.asset_id

Line 1624: fa_transaction_headers TH,

1620:
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)

Line 1652: FROM fa_transaction_headers TH,

1648: FA_RX_UTIL_PKG.debug('Get manual adjustment downwards');
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

Line 1673: FROM fa_transaction_headers TH,

1669: FA_RX_UTIL_PKG.debug('Get revaluations downward ');
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

Line 1694: FROM fa_transaction_headers TH,

1690: FA_RX_UTIL_PKG.debug('Get retirements ');
1691:
1692: SELECT SUM(RE.cost_retired)
1693: INTO X_retirements
1694: FROM fa_transaction_headers TH,
1695: fa_retirements RE
1696: WHERE RE.transaction_header_id_in = TH.transaction_header_id
1697: AND RE.book_type_code = TH.book_type_code
1698: AND RE.asset_id = TH.asset_id

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 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 2441: FROM fa_transaction_headers TH,

2437: SELECT TH.transaction_type_code,
2438: TH.transaction_header_id,
2439: BO.date_placed_in_service,
2440: BO.cost
2441: FROM fa_transaction_headers TH,
2442: fa_books BO
2443: WHERE BO.transaction_header_id_in = TH.transaction_header_id
2444: AND BO.book_type_code = TH.book_type_code
2445: AND BO.asset_id = TH.asset_id

Line 2488: FROM fa_transaction_headers TH,

2484: SELECT TH.transaction_type_code,
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

Line 2541: FROM fa_transaction_headers TH,

2537: SELECT TH.transaction_type_code,
2538: TH.transaction_header_id,
2539: th.transaction_date_entered,
2540: RE.cost_retired
2541: FROM fa_transaction_headers TH,
2542: fa_retirements RE
2543: WHERE (RE.transaction_header_id_in = TH.transaction_header_id
2544: OR RE.transaction_header_id_out = TH.transaction_header_id)
2545: AND RE.book_type_code = TH.book_type_code

Line 2593: FROM fa_transaction_headers TH,

2589: TH.transaction_header_id,
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