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

VIEW: APPS.OKL_BPD_CNTR_PRICE_LIST_UV

Object Details
Object Name: OKL_BPD_CNTR_PRICE_LIST_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_BPD_CNTR_PRICE_LIST_UV
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
PRICE_LIST_ID1 NUMBER
Yes Primary Key of QP_LIST_HEADERS_B. System Generated ID
USAGE_NAME VARCHAR2 (240)
Item name.
USAGE_DESCRIPTION VARCHAR2 (40)
This column contains Item translated description
PRICE_NAME VARCHAR2 (240) Yes Name of Modifier List
PRICE_DESCRIPTION VARCHAR2 (2000)
Description of Modifier List
MINIMUM_QUANTITY VARCHAR2 (450)
Stores rule flexfield information.
DEFAULT_QUANTITY VARCHAR2 (450)
Stores rule flexfield information.
CHR_ID NUMBER

Contract Identifier
LINE_ID NUMBER

ID of the contract line with which this rule group is associated.
USAGE_ORGANIZATION_ID NUMBER
Yes Organization identifier
Query Text

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


SELECT PRICE_LIST_ID1
,      USAGE_NAME
,      USAGE_DESCRIPTION
,      PRICE_NAME
,      PRICE_DESCRIPTION
,      MINIMUM_QUANTITY
,      DEFAULT_QUANTITY
,      CHR_ID
,      LINE_ID
,      USAGE_ORGANIZATION_ID
FROM APPS.OKL_BPD_CNTR_PRICE_LIST_UV;

Dependencies

[top of page]

APPS.OKL_BPD_CNTR_PRICE_LIST_UV references the following:

SchemaAPPS
SynonymOKC_RULES_B
SynonymOKC_RULE_GROUPS_B
ViewOKX_LIST_HEADERS_V
ViewOKX_SYSTEM_ITEMS_V

APPS.OKL_BPD_CNTR_PRICE_LIST_UV is not referenced by any database object