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 1250: ' from fa_transaction_headers trh,'||

1246: ' dih.book_type_code = '||''''||PARM.p_book_type_code ||''''||' and'||
1247: ' gcc.code_combination_id = dih.code_combination_id'||
1248: ' and dih.transaction_header_id_in =';
1249: v_selectstmnt2 := '(select to_char(MAX(transaction_heaDer_id))'||
1250: ' from fa_transaction_headers trh,'||
1251: ' fa_distribution_history dih1'||
1252: ' where dih1.asset_id= dih.asset_id and'||
1253: ' dih1.book_type_code =dih.book_type_code and'||
1254: ' dih1.transaction_header_id_in = trh.transaction_header_id and';

Line 1426: FROM fa_books BO1, fa_transaction_headers TRH

1422: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1423: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1424: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),
1425: max(transaction_header_id_in)
1426: FROM fa_books BO1, fa_transaction_headers TRH
1427: WHERE BO1.book_type_code = BO.book_type_code
1428: AND BO1.asset_id = BO.asset_id
1429: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1430: AND TRH.transaction_date_entered < PARM.p_begin_period_from_date);

Line 1452: FROM fa_books BO1,FA_TRANSACTION_HEADERS TRH

1448: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1449: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1450: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),
1451: max(transaction_header_id_in)
1452: FROM fa_books BO1,FA_TRANSACTION_HEADERS TRH
1453: WHERE BO1.book_type_code = BO.book_type_code
1454: AND BO1.asset_id = BO.asset_id
1455: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1456: AND TRH.transaction_date_entered <= PARM.p_end_period_to_date);

Line 1519: fa_transaction_headers TH,

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

Line 1547: FROM fa_transaction_headers TH,

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

Line 1568: FROM fa_transaction_headers TH,

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

Line 1590: FROM fa_transaction_headers TH,

1586: FA_RX_UTIL_PKG.debug('Get reinstatements ');
1587:
1588: SELECT SUM(RE.cost_retired)
1589: INTO X_reinstatements
1590: FROM fa_transaction_headers TH,
1591: fa_retirements RE
1592: WHERE RE.transaction_header_id_out = TH.transaction_header_id
1593: AND RE.book_type_code = TH.book_type_code
1594: AND RE.asset_id = TH.asset_id

Line 1640: fa_transaction_headers TH,

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

Line 1668: FROM fa_transaction_headers TH,

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

Line 1689: FROM fa_transaction_headers TH,

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

Line 1710: FROM fa_transaction_headers TH,

1706: FA_RX_UTIL_PKG.debug('Get retirements ');
1707:
1708: SELECT SUM(RE.cost_retired)
1709: INTO X_retirements
1710: FROM fa_transaction_headers TH,
1711: fa_retirements RE
1712: WHERE RE.transaction_header_id_in = TH.transaction_header_id
1713: AND RE.book_type_code = TH.book_type_code
1714: AND RE.asset_id = TH.asset_id

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

2453: SELECT TH.transaction_type_code,
2454: TH.transaction_header_id,
2455: BO.date_placed_in_service,
2456: BO.cost
2457: FROM fa_transaction_headers TH,
2458: fa_books BO
2459: WHERE BO.transaction_header_id_in = TH.transaction_header_id
2460: AND BO.book_type_code = TH.book_type_code
2461: AND BO.asset_id = TH.asset_id

Line 2504: FROM fa_transaction_headers TH,

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

Line 2557: FROM fa_transaction_headers TH,

2553: SELECT TH.transaction_type_code,
2554: TH.transaction_header_id,
2555: th.transaction_date_entered,
2556: RE.cost_retired
2557: FROM fa_transaction_headers TH,
2558: fa_retirements RE
2559: WHERE (RE.transaction_header_id_in = TH.transaction_header_id
2560: OR RE.transaction_header_id_out = TH.transaction_header_id)
2561: AND RE.book_type_code = TH.book_type_code

Line 2609: FROM fa_transaction_headers TH,

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