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_KHR_TNC_RVI_UV

Object Details

Object Name:	OKL_KHR_TNC_RVI_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_KHR_TNC_RVI_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
DNZ_CHR_ID	NUMBER			Contract ID. Denormalized for performance.
LINE_ID	NUMBER			Placeholder for Contract Line Identifier
RGP_ID	NUMBER		Yes	Rule Group Identifier for Rule Group LARVIN
RGD_CODE	VARCHAR2	(30)	Yes	Rule Group Definition Code for Rule Group LARVIN
RGP_LARVIN_LARVAU_ID	NUMBER		Yes	Rule Group Identifier for Rule Group LARVIN
RGP_LARVIN_LARVAM_ID	NUMBER		Yes	Rule Group Identifier for Rule Group LARVIN
RUL_LARVAU_ID	NUMBER		Yes	Rule Identifier for Rule LARVAU
LARVAU_RULE_INFO_CAT	VARCHAR2	(90)	Yes	Rule Information Category for Rule LARVAU
RUL_LARVAM_ID	NUMBER		Yes	Rule Identifier for Rule LARVAM
LARVAM_RULE_INFO_CAT	VARCHAR2	(90)	Yes	Rule Information Category for Rule LARVAM
LARVAU_RULE_INFORMATION1	VARCHAR2	(450)		Rule Information1 for Rule LARVAU
LARVAM_RULE_INFORMATRION4	VARCHAR2	(450)		Rule Information4 for Rule LARVAM
ITEM_ID1	NUMBER			Placeholder for Item Id1
ITEM_NAME	VARCHAR2	(0)		Placeholder for Item Name

Query Text

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


SELECT DNZ_CHR_ID
,      LINE_ID
,      RGP_ID
,      RGD_CODE
,      RGP_LARVIN_LARVAU_ID
,      RGP_LARVIN_LARVAM_ID
,      RUL_LARVAU_ID
,      LARVAU_RULE_INFO_CAT
,      RUL_LARVAM_ID
,      LARVAM_RULE_INFO_CAT
,      LARVAU_RULE_INFORMATION1
,      LARVAM_RULE_INFORMATRION4
,      ITEM_ID1
,      ITEM_NAME
FROM APPS.OKL_KHR_TNC_RVI_UV;

Dependencies

[top of page]

APPS.OKL_KHR_TNC_RVI_UV references the following:

APPS: OKC_RULES_B; OKC_RULE_GROUPS_B

APPS.OKL_KHR_TNC_RVI_UV is not referenced by any database object