QP_PRICE_LISTS_TL: Columns, Indexes and Few Tricks

QP_PRICE_LISTS_TL is the translation table used by Oracle fusion to store the name of Price List. This post is to share my knowledge of this table e.g. Table structure, Indexes etc but before that a few tricks which we need to remember while using this table:

1. Price_List_Id along with Language can be used to fetch the record uniquely. This is also the primary key of the table. you can use USERENV(‘LANG’) to get the language of the user to get the appropriate name.
2. Another way to get the unique record of this table is to query it for price list name along with Language.
3. This table is the translational table for table QP_PRICE_LISTS_ALL_B which is the base table for Price List.
4. You can refer the query to fetch the price list of an item and other details by clicking here.

Related Posts

• Query to fetch the Price list of an Item
• QP_PRICE_LISTS_ALL_B
• QP_PRICE_LIST_ITEMS

Now let’s have a look at the column details and indexes of the table QP_PRICE_LISTS_TL.

QP_PRICE_LISTS_TL Structure

COLUMN_NAME	DATA_TYPE	NULLABLE
PRICE_LIST_ID	NUMBER	N
LANGUAGE	VARCHAR2(16)	N
SOURCE_LANG	VARCHAR2(16)	N
NAME	VARCHAR2(320)	N
DESCRIPTION	VARCHAR2(4000)	Y
LAST_UPDATE_LOGIN	VARCHAR2(128)	Y
LAST_UPDATED_BY	VARCHAR2(256)	N
LAST_UPDATE_DATE	TIMESTAMP(6)	N
CREATED_BY	VARCHAR2(256)	N
CREATION_DATE	TIMESTAMP(6)	N
OBJECT_VERSION_NUMBER	NUMBER	N

Indexes

INDEX NAME	INDEX TYPE	UNIQUENESS	COLUMN NAME
QP_PRICE_LISTS_TL_PK	NORMAL	UNIQUE	PRICE_LIST_ID
QP_PRICE_LISTS_TL_PK	NORMAL	UNIQUE	LANGUAGE
QP_PRICE_LISTS_TL_U1	NORMAL	UNIQUE	NAME
QP_PRICE_LISTS_TL_U1	NORMAL	UNIQUE	LANGUAGE

Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.

Reference:
support.oracle.com

Check out the Amazon Deals of the day based on your interests..