Results for “retirement_type_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FA_MASS_EXT_RETIREMENTS_V is a read-only database view owned by the APPS schema within the Oracle E-Business Suite Assets (OFA) module. In Oracle EBS 12.1.1 and 12.2.2, it serves as a reporting and integration layer over the mass external retirement interface. The base table FA_MASS_EXT_RETIREMENTS stores staged retirement transactions loaded into the Mass External Retirements interface before they are validated, reviewed, and ultimately processed into live asset retirement transactions.

The view enriches those staged interface rows with descriptive and contextual data drawn from multiple fixed asset tables, so that users and downstream processes can report on pending external retirements without writing joins manually. Notably, it exposes the REVIEW_STATUS column, which is central to the mass external retirement review workflow. Because the user's search term was "review_status", this column is the primary filter attribute for identifying rows in a given approval or validation state.

Underlying Base Objects

The view is defined over the following documented base objects (each referenced via a SYNONYM in the APPS schema):

• FA_MASS_EXT_RETIREMENTS (EXT) — the driving interface table holding staged external retirement transactions, including REVIEW_STATUS and the retirement attributes.
• FA_ADDITIONS (AD) — joined on ASSET_ID to supply the ASSET_NUMBER.
• FA_BOOKS (BKS) — joined on ASSET_ID and BOOK_TYPE_CODE where DATE_INEFFECTIVE IS NULL, supplying the asset cost.
• FA_BOOK_CONTROLS (BC) — supplies the CURRENT_FISCAL_YEAR and FISCAL_YEAR_NAME.
• FA_FISCAL_YEAR (FY) — supplies the fiscal year START_DATE and END_DATE.
• FA_ASSET_HISTORY (AH) — supplies CURRENT_UNITS, restricted to the latest DATE_EFFECTIVE via a correlated MAX subquery.
• FA_ADDITIONS (TRADE_IN) — an outer join (TRADE_IN.ASSET_ID(+) = EXT.TRADE_IN_ASSET_ID) supplying the trade-in asset number and description.

Key Columns

• REVIEW_STATUS — the review/approval state of the staged retirement row; the principal column of interest for review workflows.
• MASS_EXTERNAL_RETIRE_ID, BATCH_NAME — identifier and grouping label for the interface row/batch.
• ASSET_ID, ASSET_NUMBER, BOOK_TYPE_CODE — the asset and book the retirement applies to.
• DATE_RETIRED, DATE_EFFECTIVE, TRANSACTION_NAME — retirement timing and transaction identification.
• COST_RETIRED, UNITS, COST_OF_REMOVAL, PROCEEDS_OF_SALE — financial and quantity attributes of the retirement.
• RETIREMENT_TYPE_CODE, RETIREMENT_PRORATE_CONVENTION — retirement classification and prorate rule.
• CALC_GAIN_LOSS_FLAG, STL_METHOD_CODE, STL_LIFE_IN_MONTHS, STL_DEPRN_AMOUNT — gain/loss and salvage treatment parameters.
• TRADE_IN_ASSET_NUMBER, TRADE_IN_ASSET_DESC — trade-in details.
• CURRENT_FISCAL_YEAR, FISCAL_YEAR_NAME, FY_START_DATE, FY_END_DATE — fiscal context.
• ATTRIBUTE1–15 and TH_ATTRIBUTE1–15 — descriptive flexfield values for the asset and the retirement row.

Common Use Cases and Queries

The view is typically used to report on staged external retirements and their review status, to reconcile batches before running the Mass External Retirements process, and to feed integration or audit extracts.

• List all pending retirements awaiting review:

  SELECT batch_name, asset_number, date_retired, review_status
  FROM   fa_mass_ext_retirements_v
  WHERE  review_status = 'PENDING';

• Summarize batches by review status:

  SELECT batch_name, review_status, COUNT(*) rec_count, SUM(cost_retired) cost_retired
  FROM   fa_mass_ext_retirements_v
  GROUP  BY batch_name, review_status;

• Detail a specific asset's staged retirement:

  SELECT asset_number, book_type_code, transaction_name, cost, cost_retired,
         proceeds_of_sale, retirement_type_code
  FROM   fa_mass_ext_retirements_v
  WHERE  asset_id = :p_asset_id;

Because FA_MASS_EXT_RETIREMENTS is an interface table, rows are transient; the view reflects only currently staged data.