Search Results lk_cc

Overview

APPS.OZF_CLAIMS_V is a reporting and integration view within the Oracle E-Business Suite Trade Management (formerly Oracle Claims and Deductions) module. It presents a denormalized, query-friendly projection of the OZF_CLAIMS transactional table, enriched with decoded reference data from lookup, customer, and status objects. In EBS 12.1.1 and 12.2.2, the view serves as the primary read interface for claims, deductions, and chargebacks processed through the Channel Revenue Management / Trade Management settlement engine.

The view is owned by the APPS schema and is defined as a join between the claims base entity and several supporting views and synonyms. Its purpose is to expose claim attributes in a form ready for concurrent program output, OBIEE/XML Publisher reporting, and inbound/outbound interface processing, avoiding the need for consumers to reconstruct decoded meanings or resolve foreign keys manually.

Underlying Base Objects

The documented base objects referenced by OZF_CLAIMS_V are:

• OZF_CLAIMS (synonym) — the driving transactional table, supplying claim header columns such as CLAIM_ID, CLAIM_NUMBER, CLAIM_CLASS, CLAIM_DATE, DUE_DATE, amounts, currency, and the ATTRIBUTE1–15 descriptive flexfield columns.
• OZF_LOOKUPS (view) — joined via lookup type to supply the CLAIM_CLASS meaning; the view text exposes this as LK_CC.MEANING, the exact column referenced in a typical "lk_cc" search.
• OZF_CLAIM_TYPES_VL (view) — provides the translatable CLAIM_TYPE name via CT.NAME.
• AMS_USER_STATUSES_VL (view) — supplies the user-defined status name as AUS.NAME, keyed from USER_STATUS_ID.
• HZ_CUST_ACCOUNTS (synonym) — supplies the customer ACCOUNT_NUMBER.
• HZ_PARTIES (synonym) — supplies the customer party_name.
• OZF_SYS_PARAMETERS (synonym) — referenced for system-level parameter resolution, typically multi-org or operating unit context.

The relationship is a standard master/detail lookup pattern: OZF_CLAIMS is the anchor, and each supporting object is outer-joined on its respective foreign key (CLAIM_CLASS, CLAIM_TYPE_ID, USER_STATUS_ID, CUST_ACCOUNT_ID, and set of books).

Key Columns

• Identity and audit: CLAIM_ID, OBJECT_VERSION_NUMBER, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, REQUEST_ID, PROGRAM_ID.
• Classification: CLAIM_CLASS with its decoded LK_CC.MEANING, BATCH_TYPE, BATCH_ID, CLAIM_TYPE_ID with CT.NAME.
• Lifecycle: CLAIM_DATE, DUE_DATE, STATUS_CODE, USER_STATUS_ID with AUS.NAME, HISTORY_EVENT and HISTORY_EVENT_DATE.
• Customer context: CUST_ACCOUNT_ID, party_name, ACCOUNT_NUMBER, CUST_BILLTO_ACCT_SITE_ID, CUST_SHIPTO_ACCT_SITE_ID, CONTACT_ID, SALES_REP_ID.
• Financials: AMOUNT, AMOUNT_REMAINING, AMOUNT_ADJUSTED, AMOUNT_SETTLED, TAX_AMOUNT, ACCTD_AMOUNT and its adjusted/remaining/settled variants, CURRENCY_CODE, EXCHANGE_RATE, SET_OF_BOOKS_ID.
• Relationships: ROOT_CLAIM_ID, DUPLICATE_CLAIM_ID, SPLIT_FROM_CLAIM_ID, SOURCE_OBJECT_NUMBER, RECEIPT_NUMBER, ORDER_TYPE_ID.
• Flexfields: ATTRIBUTE_CATEGORY, ATTRIBUTE1–15, and DEDUCTION_ATTRIBUTE_CATEGORY with DEDUCTION_ATTRIBUTE1–15.

Common Use Cases and Queries

The view is typically queried to list open deductions by customer, to reconcile settled versus remaining balances, or to extract claim data for downstream reporting. A representative query filtering on claim class meaning ("lk_cc") is:

• SELECT c.claim_number, c.meaning, c.party_name, c.amount, c.amount_remaining, c.currency_code
• FROM apps.ozf_claims_v c
• WHERE c.meaning = :p_class AND c.amount_remaining > 0
• ORDER BY c.claim_date;

Because the view already decodes CLAIM_CLASS, STATUS, and CLAIM_TYPE, it eliminates redundant joins in report SQL and is safe for read-only access by custom concurrent programs and integration extracts.