QP_PRICE_LISTS_ALL_B is the table used by Oracle Fusion to store the Price List i.e. it is the base table for Price List. In this post we will discuss the structure of this table but before that couple of points to keep in mind before using it in the code:
- This table has a column called STATUS. Watch out for this column in your query.
- Records in this table are date sensitive i.e. price lists can expire. Use “Start Date” and “End Date” judiciously.
- Org_Id is yet another column you might want to keep an eye upon as different price list might be in use for same item across inventory orgs.
- PRICE_LIST_ID is the unique key here.
- Click here to see the query fetching item, price list and other details.
Related Posts:
Price List Query
QP_PRICE_LIST_ITEMS: Table to hold the relationship between item and price list
Below are the table structure and Index details of table QP_PRICE_LISTS_ALL_B.
QP_PRICE_LISTS_ALL_B Structure
| COLUMN_NAME | DATA_TYPE | NULLABLE |
| PRICE_LIST_ID | NUMBER | N |
| CALCULATION_METHOD_CODE | VARCHAR2(120) | Y |
| START_DATE | TIMESTAMP(6) | N |
| CHARGE_DEFINITION_ID | NUMBER | Y |
| END_DATE | TIMESTAMP(6) | Y |
| STATUS_CODE | VARCHAR2(120) | N |
| ATTRIBUTE_CATEGORY | VARCHAR2(600) | Y |
| CURRENCY_CODE | VARCHAR2(60) | N |
| PRICE_LIST_TYPE_CODE | VARCHAR2(120) | N |
| LINE_TYPE_CODE | VARCHAR2(120) | Y |
| ORG_ID | NUMBER | N |
| CATALOG_ID | NUMBER | 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 |
| ATTRIBUTE_CHAR1 – ATTRIBUTE_CHAR20 | VARCHAR2(600) | Y |
| ATTRIBUTE_NUMBER1 – ATTRIBUTE_NUMBER10 | NUMBER | Y |
| ATTRIBUTE_DATE1- ATTRIBUTE_DATE5 | DATE | Y |
| ATTRIBUTE_TIMESTAMP1-ATTRIBUTE_TIMESTAMP5 | TIMESTAMP(6) | Y |
Index
| INDEX_NAME | INDEX_TYPE | UNIQUENESS | COLUMN_NAME |
| QP_PRICE_LISTS_B_PK | NORMAL | UNIQUE | PRICE_LIST_ID |
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..
1 thought on “QP_PRICE_LISTS_ALL_B: Columns, Indexes & Imp Points”
Comments are closed.