DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.QPBV_PRICE_LISTS

Object Details
Object Name: QPBV_PRICE_LISTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewQP.QPBV_PRICE_LISTS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This view gives information about Standard and Agreement Price list headers.


[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (240) Yes
ROUNDING_FACTOR NUMBER

START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

COMMENTS VARCHAR2 (2000)
ACTIVE_FLAG VARCHAR2 (1)
DESCRIPTION VARCHAR2 (2000)
LIST_TYPE_CODE VARCHAR2 (30) Yes
CURRENCY_CODE VARCHAR2 (30)
SOURCE_SYSTEM_CODE VARCHAR2 (30)
SHIP_METHOD_CODE VARCHAR2 (30)
FREIGHT_TERMS_CODE VARCHAR2 (30)
LIST_HEADER_ID NUMBER
Yes
TERMS_ID NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
ORIG_SYSTEM_HEADER_REF VARCHAR2 (50)
Id of the source system that creates price list is stored in this column.
PTE_CODE VARCHAR2 (30)
If the list header is a Modifier , this column indicates Pricing Transaction Entity that created it.
LIST_SOURCE_CODE VARCHAR2 (30)
This column identifies the source system that creates price list.
ORIG_ORG_ID NUMBER

This is used by runtime engine security. Every List Header belongs to an Operating Unit that created it. Foreign key to HR_OPERATING_UNITS
GLOBAL_FLAG VARCHAR2 (1)
Indicates if the entity with this list_header_id can be used globally or by the Operating Unit that created it. The value of this flag helps the pricing Engine to make this decision.
SHAREABLE_FLAG VARCHAR2 (1)
Indicates whether or not pricelist/modifier can be shared across blankets
CURRENCY_HEADER_ID NUMBER

Identifies Multi-Currency List associated with a Price List. This is primary key of QP_CURRENCY_LISTS_B table.
SOLD_TO_ORG_ID NUMBER

This column is used as a reference for customer_item_id in qp_list_lines. This column does not indicate any pricing relationship with the customer.
LOCKED_FROM_LIST_HEADER_ID NUMBER

To store the parent list header id from which the locked list header is created.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT NAME
,      ROUNDING_FACTOR
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      COMMENTS
,      ACTIVE_FLAG
,      DESCRIPTION
,      LIST_TYPE_CODE
,      CURRENCY_CODE
,      SOURCE_SYSTEM_CODE
,      SHIP_METHOD_CODE
,      FREIGHT_TERMS_CODE
,      LIST_HEADER_ID
,      TERMS_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ORIG_SYSTEM_HEADER_REF
,      PTE_CODE
,      LIST_SOURCE_CODE
,      ORIG_ORG_ID
,      GLOBAL_FLAG
,      SHAREABLE_FLAG
,      CURRENCY_HEADER_ID
,      SOLD_TO_ORG_ID
,      LOCKED_FROM_LIST_HEADER_ID
FROM APPS.QPBV_PRICE_LISTS;

Dependencies

[top of page]

APPS.QPBV_PRICE_LISTS references the following:

SchemaAPPS
SynonymQP_LIST_HEADERS_B
SynonymQP_LIST_HEADERS_TL

APPS.QPBV_PRICE_LISTS is not referenced by any database object