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_BUS_VARIABLES_SEARCH_V

Object Details

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

View Type

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

Variables Search view definition

[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.
VARIABLE_TYPE	VARCHAR2	(1)	Yes	This defined the type of the variable. The valid values are S=System, U=User Defined, T=Table, D=Deliverable.
DESCRIPTION	VARCHAR2	(450)		This is a short description of the variable.
VARIABLE_INTENT	VARCHAR2	(80)	Yes	This defines the Intent of the variable i.e. Buy or Sell. Foreign Key to FND_LOOKUPS of lookup_type OKC_ARTICLE_INTENT.
VARIABLE_TYPE_MEANING	VARCHAR2	(80)	Yes	The Description for FND Lookups for the Variable Type
USED_IN_ARTICLES	VARCHAR2	(1)		Derived column indicating whether the Variable is used in an Clause.
DISABLED_YN	VARCHAR2	(1)	Yes	Yes/No flag to indicate whether this variable can no longer be used.
EXTERNAL_YN	VARCHAR2	(1)	Yes	Yes/No flag to indicate whether this variable can be updated by external users or not e.g. supplier.
VALUE_SET_ID	NUMBER	(10)		This defines the source of the user-defined variable value. This is mandatory for user-defined variables. Foreign Key to FND FLEX Value Sets.
VALUE_SET_NAME	VARCHAR2	(60)		The Value Set Name that is associated with this variable.
APPLICATION_NAME	VARCHAR2	(240)		The Application name which is associated with the Variable
DEFAULT_VALUE	VARCHAR2	(30)		This column stores the default value for user-defined variables.
DATATYPE	VARCHAR2	(80)		This is the Variable Datatype (D= Date, N=Number, V=Varchar2).
APPLICATION_ID	NUMBER			This column references the owning application in the case of system variables. This is a foreign Key to FND_APPLICATION.
XPRT_VALUE_SET_NAME	VARCHAR2	(60)		This is the Master Value Set Name of the System Variables for Contract Expert
CONTRACT_EXPERT_YN	VARCHAR2	(1)		This column determines whether the Variable can be used for Contract Expert
LINE_LEVEL_FLAG	VARCHAR2	(1)		Identify if the system variable is a line level variable. For all other variable types this would always be 'N'
DATE_PUBLISHED	DATE			Date the variable was published , specifically used for XML based Clause Import.
PROCEDURE_NAME	VARCHAR2	(200)		This column stores the PACKAGE.PROCEDURENAME to source user defined variables. This is not applicable / not used in base R12 and prior releases.
VARIABLE_SOURCE	VARCHAR2	(1)	Yes	Indicator to identify user defined variable source. Possible values are M (Manual) and P (PL/SQL Procedure)
TEMPLATE_NAME	VARCHAR2	(4000)
CLM_SOURCE	VARCHAR2	(30)
MRV_FLAG	VARCHAR2	(1)
ATTRIBUTE_GROUP_NAME	VARCHAR2	(4000)

Query Text

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


SELECT VARIABLE_CODE
,      VARIABLE_NAME
,      VARIABLE_TYPE
,      DESCRIPTION
,      VARIABLE_INTENT
,      VARIABLE_TYPE_MEANING
,      USED_IN_ARTICLES
,      DISABLED_YN
,      EXTERNAL_YN
,      VALUE_SET_ID
,      VALUE_SET_NAME
,      APPLICATION_NAME
,      DEFAULT_VALUE
,      DATATYPE
,      APPLICATION_ID
,      XPRT_VALUE_SET_NAME
,      CONTRACT_EXPERT_YN
,      LINE_LEVEL_FLAG
,      DATE_PUBLISHED
,      PROCEDURE_NAME
,      VARIABLE_SOURCE
,      TEMPLATE_NAME
,      CLM_SOURCE
,      MRV_FLAG
,      ATTRIBUTE_GROUP_NAME
FROM APPS.OKC_BUS_VARIABLES_SEARCH_V;

Dependencies

[top of page]

APPS.OKC_BUS_VARIABLES_SEARCH_V references the following:

APPS: FND_APPLICATION_VL; FND_FLEX_VALUE_SETS; FND_GLOBAL - show dependent code; FND_LOOKUPS; OKC_ARTICLE_VARIABLES; OKC_BUS_VARIABLES_B; OKC_BUS_VARIABLES_TL; OKC_MRV_UTIL - show dependent code

APPS.OKC_BUS_VARIABLES_SEARCH_V is not referenced by any database object