Search Results pac_rates_cost_type

Overview

The APPS.CST_LE_COST_TYPES_V view is a cost management reporting object that resolves legal-entity-level cost type configuration into a single denormalized result set. It sits over the CST_LE_COST_TYPES intersection table, which holds the assignment of cost types to a legal entity and set of books, and enriches each row with descriptive attributes from cost type, ledger, lookup, and first-party (legal entity) sources. Its purpose is to present human-readable values — legal entity name, set of books name, cost type description, primary cost method meaning, PAC rates cost type, and the accounting library name — alongside the raw identifier columns, so that reporting, integration, and diagnostic queries do not have to perform the joins repeatedly.

The view is particularly relevant to users searching on accounting_library_name. That column is derived from the CST_ACCOUNTING_LIBRARIES table through an outer join, meaning a legal-entity cost type row is still returned when no accounting library has been associated, with ACCOUNTING_LIBRARY_NAME null. This behavior mirrors the underlying ACCOUNTING_LIBRARY_ID foreign key, which is also optional. Together with CREATE_ACCT_ENTRIES, POST_TO_GL, GL_TRANSFER_ALLOW_OVERRIDE, GL_TRANSFER_MODE, and GL_TRANSFER_SUBMIT_JOURNAL_IMP, the accounting library columns describe the subledger accounting and general ledger transfer behavior configured for the legal entity's cost type.

Underlying Base Objects

The view is owned by APPS and is defined over the following documented objects:

• CST_LE_COST_TYPES (synonym) — the driving table, supplying legal entity, cost type, set of books, primary cost method, PAC rates cost type, accounting library, GL transfer flags, and standard WHO audit columns.
• CST_COST_TYPES (synonym) — joined twice, once for the primary cost type and once for the PAC rates cost type, providing COST_TYPE and description.
• CST_ACCOUNTING_LIBRARIES (synonym) — outer-joined on accounting_lib_id to supply LIB_NAME as ACCOUNTING_LIBRARY_NAME.
• XLE_FIRSTPARTY_INFORMATION_V (view) — supplies the legal entity NAME, joined on legal_entity_id.
• GL_SETS_OF_BOOKS (view) — supplies SHORT_NAME as SET_OF_BOOKS_NAME, joined on set_of_books_id.
• MFG_LOOKUPS (view) — supplies the MEANING for the primary cost method from lookup type MTL_PRIMARY_COST.

All joins are equijoins on the primary key or descriptive key of each source, with the sole exception of the accounting library join, which is an outer join. This makes the view a strict superset of CST_LE_COST_TYPES rows: every configured legal-entity cost type appears, regardless of whether an accounting library exists.

Key Columns

• LEGAL_ENTITY, LEGAL_ENTITY_NAME — the legal entity identifier and its resolved name.
• COST_TYPE_ID, COST_TYPE, COST_TYPE_DESC — the cost type assigned to the legal entity.
• SET_OF_BOOKS_ID, SET_OF_BOOKS_NAME — the ledger (set of books) context for the configuration.
• PRIMARY_COST_METHOD, PRIMARY_COST_METHOD_NAME — the primary cost method code and its lookup meaning.
• PAC_RATES_COST_TYPE_ID, PAC_RATES_COST_TYPE, PAC_RATES_COST_TYPE_DESC — the cost type used for periodic average cost rates.
• ACCOUNTING_LIBRARY_ID, ACCOUNTING_LIBRARY_NAME — the subledger accounting library, with the name resolved from CST_ACCOUNTING_LIBRARIES.LIB_NAME.
• CREATE_ACCT_ENTRIES, POST_TO_GL, GL_TRANSFER_ALLOW_OVERRIDE, GL_TRANSFER_MODE, GL_TRANSFER_SUBMIT_JOURNAL_IMP — flags and modes governing accounting entry creation and GL transfer.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO and concurrent program audit columns.

Common Use Cases and Queries

Typical scenarios include auditing which cost types have no accounting library assigned, verifying GL transfer configuration by legal entity, and reporting cost type assignments across ledgers. Because the view resolves names, it is convenient for ad hoc reporting without additional joins.

• List cost types with their accounting library: SELECT legal_entity_name, cost_type, accounting_library_name FROM apps.cst_le_cost_types_v;
• Find configurations missing an accounting library: SELECT legal_entity_name, cost_type, set_of_books_name FROM apps.cst_le_cost_types_v WHERE accounting_library_id IS NULL;
• Audit GL transfer settings per legal entity: SELECT legal_entity_name, cost_type, post_to_gl, gl_transfer_mode FROM apps.cst_le_cost_types_v ORDER BY legal_entity_name, cost_type;