QP_RATE_PLAN_ASSOCIATIONS

Details

Schema: FUSION
Object owner: QP
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
QP_RATE_PLAN_ASSOCIATIONS_PK	RATE_PLAN_ASSOCIATION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RATE_PLAN_ASSOCIATION_ID	NUMBER		18	Yes	Value that uniquely identifies an association for the rate plan. Oracle Fusion automatically creates this value.
RATE_PLAN_ID	NUMBER		18	Yes	Value that uniquely identifies the rate plan. Oracle Fusion automatically creates this value.
PARENT_ENTITY_TYPE_CODE	VARCHAR2	30		Yes	Value that uniquely identifies the parent entity of the rate plan. The ORA_QP_RATE_PLAN_PARENT_ENTITY lookup type contains the values that you can use.
SUBSCRIPTION_ID	NUMBER		18		Value that uniquely identifies the subscription for the associated rate plan.
SUBSCRIPTION_PRODUCT_ID	NUMBER		18		Value that uniquely identifies the subscription product for the associated rate plan.
PRICE_LIST_ID	NUMBER		18		Value that uniquely identifies the price list for the rate plan.
PRICE_LIST_ITEM_ID	NUMBER		18		Value that uniquely identifies the item on the price list for the rate plan.
START_DATE	TIMESTAMP				Date when the association with the rate plan goes into effect.
END_DATE	TIMESTAMP				Date when the association with the rate plan expires.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
PARENT_ENTITY_KEY_COLUMN1	VARCHAR2	30			The first key that identifies the rate plan's parent, such as the sales order line, quote line, contract line, and so on.
PARENT_ENTITY_KEY_COLUMN2	VARCHAR2	30			The second key that identifies the rate plan's parent, such as the sales order line, quote line, contract line, and so on.
PARENT_ENTITY_KEY_COLUMN3	VARCHAR2	30			The third key that identifies the rate plan's parent, such as the sales order line, quote line, contract line, and so on.
PARENT_ENTITY_KEY_COLUMN4	VARCHAR2	30			The fourth key that identifies the rate plan's parent, such as the sales order line, quote line, contract line, and so on.
PARENT_ENTITY_KEY_COLUMN5	VARCHAR2	30			The fifth key that identifies the rate plan's parent, such as the sales order line, quote line, contract line, and so on.

Foreign Keys

Table	Foreign Table	Foreign Key Column
QP_RATE_PLAN_ASSOCIATIONS	qp_rate_plans_b	RATE_PLAN_ID

Indexes

Index	Uniqueness	Tablespace	Columns
QP_RATE_PLAN_ASSOCIATIONS_FK	Non Unique	FUSION_TS_TX_IDX	RATE_PLAN_ID
QP_RATE_PLAN_ASSOCIATIONS_N1	Non Unique	FUSION_TS_TX_IDX	PRICE_LIST_ITEM_ID, PRICE_LIST_ID
QP_RATE_PLAN_ASSOCIATIONS_N2	Non Unique	FUSION_TS_TX_IDX	PARENT_ENTITY_TYPE_CODE, PARENT_ENTITY_KEY_COLUMN1, PARENT_ENTITY_KEY_COLUMN2, PARENT_ENTITY_KEY_COLUMN3, PARENT_ENTITY_KEY_COLUMN4, PARENT_ENTITY_KEY_COLUMN5
QP_RATE_PLAN_ASSOCIATIONS_PK	Unique	FUSION_TS_TX_IDX	RATE_PLAN_ASSOCIATION_ID
QP_RATE_PLAN_ASSOCIATIONS_U1	Unique	FUSION_TS_TX_IDX	SUBSCRIPTION_PRODUCT_ID, SUBSCRIPTION_ID