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


VIEW: APPS.QPFV_PRODUCTS

Object Details
Object Name: QPFV_PRODUCTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewQP.QPFV_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 (4000)
PRODUCT_ATTR_VALUE VARCHAR2 (4000)
PRODUCT_UOM_CODE VARCHAR2 (3)
UOM_NAME VARCHAR2 (25)
This is the name of the product uom code.
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
_DF CHAR (31)
Descriptive Flexfield column values of qp_pricing_attributes table.
ORIG_SYS_HEADER_REF VARCHAR2 (50)
ORIG_SYS_LINE_REF VARCHAR2 (50)
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
,      UOM_NAME
,      LIST_LINE_ID
,      LIST_HEADER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      _DF
,      ORIG_SYS_HEADER_REF
,      ORIG_SYS_LINE_REF
FROM APPS.QPFV_PRODUCTS;

Dependencies

[top of page]

APPS.QPFV_PRODUCTS references the following:

SchemaAPPS
SynonymMTL_UNITS_OF_MEASURE
PL/SQL PackageQP_PRICE_LIST_LINE_UTIL - show dependent code
SynonymQP_PRICING_ATTRIBUTES
PL/SQL PackageQP_QP_FORM_PRICING_ATTR - show dependent code

APPS.QPFV_PRODUCTS is not referenced by any database object