Results for “package_seq”

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

Overview

CZ_SPARES_SPECIALS is a table in the CZ (Configurator) product schema of Oracle E-Business Suite, holding data associated with the MDApp "spares-specials" construct used by the Configurator quoting engine. ETRM metadata explicitly flags the object as OBSOLETE, meaning it is retained for backward compatibility, historical data preservation, or upgrade integrity rather than for active functional use in current 12.1.1 or 12.2.2 deployments. Despite its obsolete status, the table remains VALID in the database dictionary and continues to participate in the documented foreign key web that anchors the CZ quote model.

From a Data Vault modeling perspective, the heuristic classification of CZ_SPARES_SPECIALS is satellite-leaning. Its composite primary key (PACKAGE_SEQ, QUOTE_HDR_ID, QUOTE_REV_NBR, TYPE_FLAG) identifies rows in the context of a parent quote structure, and its columns consist largely of descriptive and control attributes — discount amounts, notes, effective dating, and audit fields — that sit alongside business keys rather than defining new hubs or relationships. Analysts migrating this data into a dimensional or Data Vault warehouse should therefore treat it as a descriptive satellite attached to the quote header/package grain, not as an independent hub.

Key Information Stored

The table contains 20 documented columns in the 12.2.2 physical schema. The most significant are summarized below.

• PACKAGE_SEQ — Sequence identifier for the spares or specials package; part of the composite primary key.
• QUOTE_HDR_ID — Foreign key to the parent quote header (CZ_QUOTE_HDRS); part of the PK and the primary business join path.
• QUOTE_REV_NBR — Quote revision number; also part of the PK and referenced by downstream child tables.
• TYPE_FLAG — Discriminator indicating whether the row represents a spares package or a specials package; completes the PK.
• ITEM_SEQ_NUMBER — Sequence of the line item within the parent quote main items structure.
• QTY — Quantity associated with the spares or specials entry.
• PACKAGE_DISCOUNT — Discount amount or percentage applied to the package.
• DISC_TYPE — Type of discount applied (for example, amount versus percentage).
• NOTE — Free-form descriptive text.
• DELETED_FLAG — Logical delete indicator used to retain history without physical removal.
• EFF_FROM / EFF_TO — Effective date range for the row, supporting date-effective reporting.
• CREATION_DATE / LAST_UPDATE_DATE — Standard EBS audit timestamps.
• CREATED_BY / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — Standard EBS who-columns identifying the application user and login session.
• SECURITY_MASK / EFF_MASK / CHECKOUT_USER — Configurator-specific control columns used by the MDApp layer for row-level security, effective dating, and checkout locking.

The surrogate primary key is CZ_SPARES_SPECIALS_PK over the four columns PACKAGE_SEQ, QUOTE_HDR_ID, QUOTE_REV_NBR, and TYPE_FLAG. The documented unique index of the same name exposes those four columns as the business-key candidate for the table.

Common Use Cases and Queries

Because the table is obsolete, the principal use cases involve historical reporting, migration, and reconciliation rather than live configuration. A typical query retrieves spares and specials packages for a given quote revision, treating TYPE_FLAG as the spares/specials filter.

• Quote package listing — Join to CZ_QUOTE_HDRS on QUOTE_HDR_ID and QUOTE_REV_NBR to produce a report of packages for a quote revision, filtering on TYPE_FLAG and DELETED_FLAG = 'N'.
• Discount analysis — Aggregate PACKAGE_DISCOUNT by DISC_TYPE and TYPE_FLAG to understand historical discounting behavior across spares versus specials packages.
• Effective-dated extraction — Filter on EFF_FROM and EFF_TO to reproduce point-in-time package states for audit or migration.
• Line-item expansion — Join to CZ_QUOTE_SPARES or CZ_QUOTE_SPECIAL_ITEMS on PACKAGE_SEQ, QUOTE_HDR_ID, QUOTE_REV_NBR, and TYPE_FLAG to obtain the child lines beneath each package.

Because the object is marked OBSOLETE, any query should be validated against the target release and should be treated as read-only historical access.

Related Objects

• CZ_QUOTE_HDRS — Parent quote header; joined via QUOTE_HDR_ID and QUOTE_REV_NBR.
• CZ_QUOTE_MAIN_ITEMS — Parent quote line items; joined via QUOTE_HDR_ID, QUOTE_REV_NBR, and ITEM_SEQ_NUMBER.
• CZ_QUOTE_SPARES — Child table of spares lines; references CZ_SPARES_SPECIALS via PACKAGE_SEQ, QUOTE_HDR_ID, QUOTE_REV_NBR, and TYPE_FLAG.
• CZ_QUOTE_SPECIAL_ITEMS — Child table of special items; references the same composite key as CZ_QUOTE_SPARES.
• CZ_SPARES_SPECIALS_PK — Primary key constraint and unique index exposing the business-key candidate columns.

These relationships place CZ_SPARES_SPECIALS as a mid-level object between the quote header and the downstream spares/specials line tables, a position that reinforces its satellite interpretation within the CZ quoting model.