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.OKL_LSE_SCS_RULES_V

Object Details

Object Name:	OKL_LSE_SCS_RULES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_LSE_SCS_RULES_V
Subobject Name:
Status:	VALID

View Type

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

View for getting the rule information required for product. This view provides information about line style ,subclass,rule group and the rule itself.
It is based on top of
OKC_LSE_RULE_GROUPS LRG
OKC_SUBCLASS_RG_DEFS SRD
OKC_RG_DEF_RULES RGR
OKC_LINE_STYLES_B LSEB
OKC_LINE_STYLES_TL LSET

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LSE_ID	VARCHAR2	(0)		Holds Id of the line style.
LINE_STYLE	VARCHAR2	(0)		Holds the name of the line style.
LINE_TYPE	VARCHAR2	(0)		Holds the type of line weather its a asset line or a contract line.
PARENT_ID	VARCHAR2	(0)		Foreign Key to OKC_LINE_STYLE_B. This column is linked to parent id in OKC_LINE_STYLE_B
SRD_ID	NUMBER		Yes	Foreign Key to OKC_SUBCLASS_RG_DEF
SUBCLASS	VARCHAR2	(30)	Yes	Holds subclass information.
RULE_GROUP	VARCHAR2	(30)	Yes	Holds rule group,used to categorize rule in groups.
RULE	VARCHAR2	(30)	Yes	Holds the rule code for all the seeded rules.
CONCATENATED_RULE	VARCHAR2	(92)		Holds all the concatenation of Rule,Subclass,Linstyle,Rule Group
START_DATE	DATE		Yes	The Start date for the Rule.
END_DATE	DATE			The End date for the Rule.
MEANING	VARCHAR2	(4000)		Holds the rule meaning.

Query Text

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


SELECT LSE_ID
,      LINE_STYLE
,      LINE_TYPE
,      PARENT_ID
,      SRD_ID
,      SUBCLASS
,      RULE_GROUP
,      RULE
,      CONCATENATED_RULE
,      START_DATE
,      END_DATE
,      MEANING
FROM APPS.OKL_LSE_SCS_RULES_V;

Dependencies

[top of page]

APPS.OKL_LSE_SCS_RULES_V references the following:

APPS: OKC_RG_DEF_RULES; OKC_SUBCLASS_RG_DEFS; OKL_ACCOUNTING_UTIL - show dependent code

APPS.OKL_LSE_SCS_RULES_V is referenced by following:

APPS: OKL_SETUPOPTIONS_PVT - show dependent code; OKL_SETUPOPTRULES_PVT - show dependent code; OKL_SETUPOPTVALUES_PVT - show dependent code; OKL_SETUPOVERULES_PVT - show dependent code