eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKC_XPRT_BUS_VARIABLES_V

Object Details

Object Name:	OKC_XPRT_BUS_VARIABLES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKC.OKC_XPRT_BUS_VARIABLES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View for contract expert business variables

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
VARIABLE_CODE	VARCHAR2	(30)	Yes	This is the primary key. It will be sequence based system generated in the case of user defined variables and a code in the case of seeded variables i.e. system, table or deliverable variables. These seeded variables are prefixed as OKC$S and OKC$B where B and S indicate Buy and Sell respectively.
VARIABLE_NAME	VARCHAR2	(150)	Yes	This is the translatable name of the variable. The variable name enclosed in tags is embedded in the clause text. The variable is also used in defining contract expert rules.
DESCRIPTION	VARCHAR2	(450)		This is a short description of the variable.
VALUE_SET_NAME	VARCHAR2	(60)		Primary source for the contract expert enabled system and user defined variable values
VARIABLE_DATATYPE	VARCHAR2	(1)		Data type of the variable
LONGLIST_FLAG	VARCHAR2	(1)		Flag to indicate whether the LOV LongList feature for the value set is enabled
VALIDATION_TYPE	VARCHAR2	(1)		Validation type indicate the nature of variable. Valid values are Numeric, Boolean (Yes or No) and List of Values
FLEX_VALUE_SET_ID	NUMBER	(10)		Flexfield value set identifier

Query Text

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


SELECT VARIABLE_CODE
,      VARIABLE_NAME
,      DESCRIPTION
,      VALUE_SET_NAME
,      VARIABLE_DATATYPE
,      LONGLIST_FLAG
,      VALIDATION_TYPE
,      FLEX_VALUE_SET_ID
FROM APPS.OKC_XPRT_BUS_VARIABLES_V;

Dependencies

[top of page]

APPS.OKC_XPRT_BUS_VARIABLES_V references the following:

APPS: FND_FLEX_VALUE_SETS; OKC_BUS_VARIABLES_V

APPS.OKC_XPRT_BUS_VARIABLES_V is not referenced by any database object