Results for “bkpt_header_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The table PN.PN_VAR_BKPTS_DET_ALL is an Oracle E-Business Suite transactional table belonging to the Property Manager (PN) module. It stores breakpoint-related detail information used in the calculation of variable rent for each line item. In property management, variable rent is typically derived from sales volume thresholds, and breakpoints define the tiers of sales volume against which a rent rate is applied. This table therefore holds the tier-level definition rows that drive the variable rent computation for a given line item.
From a Data Vault modeling perspective, the metadata's FK structure suggests this object behaves as a link table — it sits at the intersection of breakpoint headers, variable rent records, and breakpoint defaults, carrying its own measures and descriptors. The table is owned by the PN schema and is status VALID in the documented 12.2.2 physical schema, where it comprises 36 columns.
Key Information Stored
The surrogate primary key is BKPT_DETAIL_ID, enforced by PN_VAR_BKPTS_DET_PK. A unique index, PN_VAR_BKPTS_DET_U1, also exists on BKPT_DETAIL_ID, making it the documented business-key candidate as well. The most significant columns are:
BKPT_DETAIL_ID— surrogate primary key and unique identifier of the breakpoint detail row.BKPT_DETAIL_NUM— sequence/number of the breakpoint tier within its parent header.BKPT_HEADER_ID— foreign key linking toPN_VAR_BKPTS_HEAD_ALL, the parent breakpoint header.VAR_RENT_ID— foreign key linking toPN_VAR_RENTS_ALL, associating the tier with its variable rent record.BKDT_DEFAULT_ID— foreign key linking toPN_VAR_BKDT_DEFAULTS_ALL, the breakpoint default source.PERIOD_BKPT_VOL_START/PERIOD_BKPT_VOL_END— period breakpoint volume range boundaries.GROUP_BKPT_VOL_START/GROUP_BKPT_VOL_END— group breakpoint volume range boundaries.BKPT_RATE— the rent rate applied within the defined breakpoint.BKPT_START_DATE/BKPT_END_DATE— effective date range of the breakpoint.ANNUAL_BASIS_AMOUNT— annualized basis amount used in variable rent calculation.ORG_ID— multi-org operating unit identifier.ATTRIBUTE_CATEGORYandATTRIBUTE1–ATTRIBUTE15— DFF (descriptive flexfield) columns for extensibility.CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN— standard who-columns for audit tracking.
Common Use Cases and Queries
Typical use cases include retrieving all breakpoint tiers for a given variable rent line item, reporting effective rent rates within a volume band, and reconciling breakpoint configurations against defaults. A common query pattern joins detail to header and rent records:
- Fetch tiers for a variable rent:
SELECT * FROM PN_VAR_BKPTS_DET_ALL WHERE VAR_RENT_ID = :p_rent_id ORDER BY BKPT_DETAIL_NUM; - Volume-band lookup: filter on
PERIOD_BKPT_VOL_START <= :sales AND PERIOD_BKPT_VOL_END > :salesfor a givenBKPT_HEADER_ID. - Date-effective tiers: filter using
BKPT_START_DATEandBKPT_END_DATEagainst a reporting period. - Audit/reporting: join to
PN_VAR_BKPTS_HEAD_ALLonBKPT_HEADER_IDto surface header context alongside tier rates.
Related Objects
The following objects are most significant to PN_VAR_BKPTS_DET_ALL, based on documented foreign key relationships:
PN_VAR_BKPTS_HEAD_ALL— parent breakpoint header; joined viaBKPT_HEADER_ID.PN_VAR_RENTS_ALL— variable rent record; joined viaVAR_RENT_ID.PN_VAR_BKDT_DEFAULTS_ALL— breakpoint defaults source; joined viaBKDT_DEFAULT_ID.PN_VAR_TRX_DETAILS_ALL— references this table viaBKPT_DETAIL_ID, linking calculated transaction details back to a breakpoint tier.
These relationships position PN_VAR_BKPTS_DET_ALL as a central link between header definitions, rent records, defaults, and calculated transaction details within the variable rent calculation flow.
-
Stores breakpoint related information to be used in the calculation of variable rent for each line item.
-
View: PN_VAR_BKPTS_DET_V 12.1.1
Form view used to input breakpoint detail
APPS.PN_VAR_BKPTS_DET_V·↳ PN_VAR_BKPTS_DET·Explore PN module →
-
View: PN_VAR_BKPTS_HEAD_V 12.2.2
Form view used to input breakpoint header information.
APPS.PN_VAR_BKPTS_HEAD_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ PN_VAR_BKPTS_HEAD·Explore PN module →
-
Stores breakpoint related information to be used in the calculation of variable rent for each line item.
-
View: PN_VAR_BKPTS_DET_V 12.2.2
Form view used to input breakpoint detail
APPS.PN_VAR_BKPTS_DET_V·↳ PN_VAR_BKPTS_DET·Explore PN module →
-
View: PN_VAR_BKPTS_HEAD_V 12.1.1
Form view used to input breakpoint header information.
APPS.PN_VAR_BKPTS_HEAD_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ PN_VAR_BKPTS_HEAD·Explore PN module →
-
Stores breakpoint related detail information to be used in the calculation of variable rent for each line item.
-
Stores breakpoint related detail information to be used in the calculation of variable rent for each line item.