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

VIEW: APPS.QPBV_PRODUCTS

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

View Type

A Business Intelligence System view


This view gives information about a 'Buy' Product of a Modifier or Product of a Price list.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2 (30)
PRODUCT_ATTRIBUTE VARCHAR2 (30)
PRODUCT_ATTR_VALUE VARCHAR2 (240)
PRODUCT_UOM_CODE VARCHAR2 (3)
LIST_LINE_ID NUMBER
Yes
LIST_HEADER_ID NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
ORIG_SYS_HEADER_REF VARCHAR2 (50)
The combination of ORIG_SYS_HEADER_REF, ORIG_SYS_LINE_REF, ORIG_SYS_PRICING_ATTR_REF is the primary key of the equivalent of the pricing attribute table of the external system from where the price data is loaded.
ORIG_SYS_LINE_REF VARCHAR2 (50)
The combination of ORIG_SYS_HEADER_REF, ORIG_SYS_LINE_REF, ORIG_SYS_PRICING_ATTR_REF is the primary key of the equivalent of the pricing attribute table of the external system from where the price data is loaded.
Query Text

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


SELECT PRODUCT_ATTRIBUTE_CONTEXT
,      PRODUCT_ATTRIBUTE
,      PRODUCT_ATTR_VALUE
,      PRODUCT_UOM_CODE
,      LIST_LINE_ID
,      LIST_HEADER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ORIG_SYS_HEADER_REF
,      ORIG_SYS_LINE_REF
FROM APPS.QPBV_PRODUCTS;

Dependencies

[top of page]

APPS.QPBV_PRODUCTS references the following:

SchemaAPPS
SynonymQP_PRICING_ATTRIBUTES

APPS.QPBV_PRODUCTS is not referenced by any database object