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 1591: fa_retirements RE

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

Line 1711: fa_retirements RE

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

Line 2558: fa_retirements RE

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