QP_TIER_LINES_OVERLAP_GT

This table is a global temporary table which is used by the Price Lists Import FBDI process and will contain the tier line rows copied from both the base table (qp_tier_lines) and the interface table(qp_tier_lines_int). This will help quickly compare all the tier lines for a tier header and identify if there are any overlapping rows. The data in this table will be deleted on commit.

Details

• Schema: FUSION

• Object owner: QP

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TIERED_PRICING_LINE_ID	NUMBER		18		Number that uniquely identifies the tier line copied from the qp_tier_lines for overlap check.
TIER_LINE_INT_ID	NUMBER		18		A system generated unique ID for a tier line copied from the qp_tier_lines_int table. It is used to identify whether the record is from the interface or base table. Only the rows copied from Interface table will have this attribute value populated.
TIERED_PRICING_HEADER_ID	NUMBER		18	Yes	Number that uniquely identifies the tier header for a tier line.
MINIMUM_VALUE	NUMBER				Minimum value of the range for a tier line.
MAXIMUM_VALUE	NUMBER				Maximum value of the range for a tier line.
STATUS	VARCHAR2	30			Status of each tier line record. It can be either ERROR or PARTIAL_ERROR.
CHILD_BATCH_NAME	VARCHAR2	50		Yes	Name of the child pricing batch to be processed. This will be the unique identifier for all the rows loaded in that child batch.
OPERATION_CODE	VARCHAR2	30			Indicates the operation on the records to be imported. It can be CREATE, UPDATE or END-INSERT.

Indexes

Index	Uniqueness	Columns
QP_TIER_LINES_OVERLAP_GT_N1	Non Unique	TIERED_PRICING_HEADER_ID, TIER_LINE_INT_ID, CHILD_BATCH_NAME