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.
ENTITY_APPRV_STATUS_CODE	VARCHAR2	30			Approval status of the associated rate plan on the price list. Values are ORA_DRAFT, ORA_PENDING_APPROVAL, ORA_APPROVED, or ORA_REJECTED. Values come from the ORA_QP_ENTITY_APPROVAL_STATUS lookup. An empty value or NULL means Approved.
DELETED_FLAG	VARCHAR2	1			Contains Y or N. Y: Record is marked for deletion and will be deleted upon approval. N: Not marked for deletion. An empty value or NULL means N.

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, ENTITY_APPRV_STATUS_CODE
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