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


VIEW: APPS.QP_PRICE_LIST_ITEMS_V

Object Details
Object Name: QP_PRICE_LIST_ITEMS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
LIST_ITEM VARCHAR2 (1943)
Price List name concatenated with the item
NAME VARCHAR2 (240) Yes Price List name
PRODUCT_ATTR_VALUE VARCHAR2 (240)
product attribute value
CONCATENATED_SEGMENTS VARCHAR2 (2000)
Concatenated value of the individual segments of the item key flexfield.
LIST_LINE_ID NUMBER
Yes List line id
OPERAND NUMBER

list price of the item
PRODUCT_UOM_CODE VARCHAR2 (3)
unit of measure
START_DATE_ACTIVE DATE

effective from
END_DATE_ACTIVE DATE

effective until
PRICE_BY_FORMULA_ID NUMBER

price formula id
Query Text

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


SELECT LIST_ITEM
,      NAME
,      PRODUCT_ATTR_VALUE
,      CONCATENATED_SEGMENTS
,      LIST_LINE_ID
,      OPERAND
,      PRODUCT_UOM_CODE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      PRICE_BY_FORMULA_ID
FROM APPS.QP_PRICE_LIST_ITEMS_V;

Dependencies

[top of page]

APPS.QP_PRICE_LIST_ITEMS_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymMTL_CATEGORIES_KFV
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymQP_LIST_LINES
SynonymQP_PRICING_ATTRIBUTES
ViewQP_SECU_LIST_HEADERS_VL
PL/SQL PackageQP_UTIL - show dependent code
SchemaPUBLIC
SynonymDUAL

APPS.QP_PRICE_LIST_ITEMS_V is not referenced by any database object