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_OR_PAYMENT_HEADER_UV

Object Details

Object Name:	OKL_OR_PAYMENT_HEADER_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_OR_PAYMENT_HEADER_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
START_DATE	DATE			The beginning of the active period, one second after midnight on the date indicated.
DURATION	NUMBER	(10)		The duration of the contract in months
RGP_LALEVL_ID	NUMBER		Yes	Primary key column.
RGP_LALEVL_RGD_CODE	VARCHAR2	(30)	Yes	Rule groups code.
DNZ_CHR_ID	NUMBER			Contract ID. Denormalized for performance.
CLE_ID	NUMBER			ID of the contract line with which this rule group is associated.
SERVICE_FEE_CLE_ID	VARCHAR2	(0)		Placeholder for Service or Fee Line Identifier
SERVICE_FEE_NAME	VARCHAR2	(0)		Placeholder for Service or Fee Line name
ASSET_CLE_ID	VARCHAR2	(0)		Placeholder for Asset Line Identifier
ASSET_NUMBER	VARCHAR2	(0)		Placeholder for Asset Number
ASSET_DESCRIPTION	VARCHAR2	(0)		Placeholder for Asset Description
RUL_LASLH_ID	NUMBER		Yes	Rule Identifier for Rule LASLH
RUL_LASLS_RULE_INFO_CAT	VARCHAR2	(90)	Yes	Rule Information Category for Rule LASLH
RUL_LASLH_OBJECT1_ID1	VARCHAR2	(40)		Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view
RUL_LASLH_OBJECT1_ID2	VARCHAR2	(200)		Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view
RUL_LASLH_JTOT_OBJECT1_CODE	VARCHAR2	(30)		Foreign key to JTF_OBJECTS_B. Represents view referenced by OBJECT_ID columns
STY_NAME	VARCHAR2	(150)	Yes	Stream Type name
STRUCTURE_CODE	VARCHAR2	(450)		Structure code
STRUCTURE_NAME	VARCHAR2	(4000)		Structure name
FREQUENCY_CODE	VARCHAR2	(40)		Frequency code
FREQUENCY_NAME	VARCHAR2	(4000)		Frequency name
ARREARS_YN	VARCHAR2	(450)		Flag to indicate whether payment is in Arrears. Valid values Y and N.
ARREARS_YN_NAME	VARCHAR2	(4000)		Lookup Meaning from FND Lookups.

Query Text

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


SELECT START_DATE
,      DURATION
,      RGP_LALEVL_ID
,      RGP_LALEVL_RGD_CODE
,      DNZ_CHR_ID
,      CLE_ID
,      SERVICE_FEE_CLE_ID
,      SERVICE_FEE_NAME
,      ASSET_CLE_ID
,      ASSET_NUMBER
,      ASSET_DESCRIPTION
,      RUL_LASLH_ID
,      RUL_LASLS_RULE_INFO_CAT
,      RUL_LASLH_OBJECT1_ID1
,      RUL_LASLH_OBJECT1_ID2
,      RUL_LASLH_JTOT_OBJECT1_CODE
,      STY_NAME
,      STRUCTURE_CODE
,      STRUCTURE_NAME
,      FREQUENCY_CODE
,      FREQUENCY_NAME
,      ARREARS_YN
,      ARREARS_YN_NAME
FROM APPS.OKL_OR_PAYMENT_HEADER_UV;

Dependencies

[top of page]

APPS.OKL_OR_PAYMENT_HEADER_UV references the following:

APPS: OKC_K_HEADERS_B; OKC_RULES_B; OKC_RULE_GROUPS_B; OKL_K_HEADERS; OKL_LLA_UTIL_PVT - show dependent code; OKL_STRM_TYPE_TL

APPS.OKL_OR_PAYMENT_HEADER_UV is not referenced by any database object