APPS.JGRX_FAREG dependencies on FA_RETIREMENTS

Line 286: ' FROM FA_RETIREMENTS RE'||

282: ' AND ((BO.period_counter_fully_retired IS NULL)'||
283: ' OR ((BO.period_counter_fully_retired IS NOT NULL)'||
284: ' AND BO.TRANSACTION_HEADER_ID_IN ='||
285: ' ( SELECT RE.TRANSACTION_HEADER_ID_IN'||
286: ' FROM FA_RETIREMENTS RE'||
287: ' WHERE BO.ASSET_ID = RE.ASSET_ID'||
288: ' AND BO.TRANSACTION_HEADER_ID_IN = RE.TRANSACTION_HEADER_ID_IN'||
289: ' AND RE.DATE_RETIRED >=:b_fiscal_year_start_date)))'||
290: ' AND CB.category_id = CA.category_id' ||

Line 504: 'fa_retirements re,

500: --
501: -- Assign From Clause
502: --
503: FA_RX_UTIL_PKG.From_Clause :=
504: 'fa_retirements re,
505: fa_additions ad,
506: fa_categories ca,
507: fa_books bo';
508:

Line 526: ' FROM fa_retirements' ||

522: ' TO_CHAR(:b_period_to_date,''DD-MON-YYYY HH:MI:SS'')' ||
523: ' AND book_type_code = BO.book_type_code' ||
524: ' AND asset_id = BO.asset_id) '||
525: ' AND RE.date_effective = (SELECT MAX(date_effective)' ||
526: ' FROM fa_retirements' ||
527: ' WHERE TO_CHAR(date_effective,''DD-MON-YYYY HH:MI:SS'') < ' ||
528: ' TO_CHAR(:b_period_to_date,''DD-MON-YYYY HH:MI:SS'')' ||
529: ' AND book_type_code = BO.book_type_code' ||
530: ' AND asset_id = BO.asset_id)';

Line 1344: fa_retirements RE

1340:
1341: SELECT SUM(RE.cost_retired)
1342: INTO X_reinstatements
1343: FROM fa_transaction_headers TH,
1344: fa_retirements RE
1345: WHERE RE.transaction_header_id_out = TH.transaction_header_id
1346: AND RE.book_type_code = TH.book_type_code
1347: AND RE.asset_id = TH.asset_id
1348: AND TH.transaction_type_code = 'REINSTATEMENT'

Line 1464: fa_retirements RE

1460:
1461: SELECT SUM(RE.cost_retired)
1462: INTO X_retirements
1463: FROM fa_transaction_headers TH,
1464: fa_retirements RE
1465: WHERE RE.transaction_header_id_in = TH.transaction_header_id
1466: AND RE.book_type_code = TH.book_type_code
1467: AND RE.asset_id = TH.asset_id
1468: AND (TH.TRANSACTION_TYPE_CODE = 'PARTIAL RETIREMENT' OR

Line 2257: fa_retirements RE

2253: TH.transaction_header_id,
2254: th.transaction_date_entered,
2255: RE.cost_retired
2256: FROM fa_transaction_headers TH,
2257: fa_retirements RE
2258: WHERE (RE.transaction_header_id_in = TH.transaction_header_id
2259: OR RE.transaction_header_id_out = TH.transaction_header_id)
2260: AND RE.book_type_code = TH.book_type_code
2261: AND RE.asset_id = TH.asset_id