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_CURE_RULE_UV

Object Details

Object Name:	OKL_CURE_RULE_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_CURE_RULE_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
VENDOR_ID	NUMBER		Yes
VENDOR_NAME	VARCHAR2	(240)
VENDOR_PROGRAM_ID	NUMBER		Yes
VENDOR_PROGRAM_NUMBER	VARCHAR2	(120)	Yes
VENDOR_PROGRAM_NAME	VARCHAR2	(600)
CONTRACT_ID	NUMBER		Yes
CONTRACT_NUMBER	VARCHAR2	(120)	Yes	Contract Number
CONTRACT_DESCRIPTION	VARCHAR2	(600)
RULE_CODE	VARCHAR2	(90)	Yes
RULE_INFORMATION1	VARCHAR2	(450)
RULE_INFORMATION2	VARCHAR2	(450)
RULE_INFORMATION3	VARCHAR2	(450)
RULE_INFORMATION4	VARCHAR2	(450)
RULE_INFORMATION5	DATE
RULE_INFORMATION6	VARCHAR2	(450)
RULE_INFORMATION7	DATE
RULE_INFORMATION8	VARCHAR2	(450)
RULE_INFORMATION9	VARCHAR2	(450)
RULE_INFORMATION10	VARCHAR2	(450)
RULE_INFORMATION11	VARCHAR2	(450)
RULE_INFORMATION12	VARCHAR2	(450)
RULE_INFORMATION13	VARCHAR2	(450)
RULE_INFORMATION14	VARCHAR2	(450)
RULE_INFORMATION15	VARCHAR2	(450)

Query Text

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


SELECT VENDOR_ID
,      VENDOR_NAME
,      VENDOR_PROGRAM_ID
,      VENDOR_PROGRAM_NUMBER
,      VENDOR_PROGRAM_NAME
,      CONTRACT_ID
,      CONTRACT_NUMBER
,      CONTRACT_DESCRIPTION
,      RULE_CODE
,      RULE_INFORMATION1
,      RULE_INFORMATION2
,      RULE_INFORMATION3
,      RULE_INFORMATION4
,      RULE_INFORMATION5
,      RULE_INFORMATION6
,      RULE_INFORMATION7
,      RULE_INFORMATION8
,      RULE_INFORMATION9
,      RULE_INFORMATION10
,      RULE_INFORMATION11
,      RULE_INFORMATION12
,      RULE_INFORMATION13
,      RULE_INFORMATION14
,      RULE_INFORMATION15
FROM APPS.OKL_CURE_RULE_UV;

Dependencies

[top of page]

APPS.OKL_CURE_RULE_UV references the following:

APPS: OKC_UTIL - show dependent code; OKL_C_V_RULES_UV

APPS.OKL_CURE_RULE_UV is referenced by following:

APPS: OKL_CURE_CONTRACT_UV