APPS.JG_RX_FAREG dependencies on FA_RETIREMENTS

Line 308: ' FROM FA_RETIREMENTS RE'||

304: ' AND ((BO.period_counter_fully_retired IS NULL)'||
305: ' OR ((BO.period_counter_fully_retired IS NOT NULL)'||
306: ' AND BO.TRANSACTION_HEADER_ID_IN ='||
307: ' ( SELECT RE.TRANSACTION_HEADER_ID_IN'||
308: ' FROM FA_RETIREMENTS RE'||
309: ' WHERE BO.ASSET_ID = RE.ASSET_ID'||
310: ' AND BO.TRANSACTION_HEADER_ID_IN = RE.TRANSACTION_HEADER_ID_IN'||
311: ' AND RE.DATE_RETIRED >=:b_fiscal_year_start_date)))'||
312: ' AND CB.category_id = CA.category_id' ||

Line 589: 'fa_retirements re,

585: --
586: -- Assign From Clause
587: --
588: FA_RX_UTIL_PKG.From_Clause :=
589: 'fa_retirements re,
590: fa_additions ad,
591: fa_categories ca,
592: fa_books bo,
593: fa_methods METH';

Line 615: ' FROM fa_retirements' ||

611: ' TO_CHAR(:b_period_to_date,''DD-MON-YYYY HH:MI:SS'')' ||
612: ' AND book_type_code = BO.book_type_code' ||
613: ' AND asset_id = BO.asset_id) '||
614: ' AND RE.date_effective = (SELECT MAX(date_effective)' ||
615: ' FROM fa_retirements' ||
616: ' WHERE TO_CHAR(date_effective,''DD-MON-YYYY HH:MI:SS'') < ' ||
617: ' TO_CHAR(:b_period_to_date,''DD-MON-YYYY HH:MI:SS'')' ||
618: ' AND book_type_code = BO.book_type_code' ||
619: ' AND asset_id = BO.asset_id)';

Line 1575: fa_retirements RE

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
1579: AND TH.transaction_type_code = 'REINSTATEMENT'

Line 1695: fa_retirements RE

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
1699: AND (TH.TRANSACTION_TYPE_CODE = 'PARTIAL RETIREMENT' OR

Line 2542: fa_retirements RE

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
2546: AND RE.asset_id = TH.asset_id