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_ASSET_BILLING_SETUP_UV

Object Details

Object Name:	OKL_OR_ASSET_BILLING_SETUP_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_OR_ASSET_BILLING_SETUP_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
NAME	VARCHAR2	(150)		Asset Number
ITEM_DESCRIPTION	VARCHAR2	(1995)		Asset Description
ID	NUMBER		Yes	Contract line Identifier
DNZ_CHR_ID	NUMBER		Yes	Contract Identifier
BILL_TO_SITE_USE_ID	NUMBER	(15)		Bill-to Site Use Identifier
BILL_TO_SITE_NAME	VARCHAR2	(40)		Bill-to Site Use name
CUST_ACCT_SITE_ID	NUMBER	(15)		Customer Account Site Identifier
RGP_LABILL_LAPMTH_ID	VARCHAR2	(0)		Rule Group Identifier for Rule Group LABILL
RGP_LABILL_LABACC_ID	VARCHAR2	(0)		Rule Group Identifier for Rule Group LABILL
RGP_LABILL_LAINVD_ID	VARCHAR2	(0)		Rule Group Identifier for Rule Group LABILL
RGP_LABILL_LAINPR_ID	VARCHAR2	(0)		Rule Group Identifier for Rule Group LABILL
RUL_LAPMTH_ID	VARCHAR2	(0)		Rule Identifier for Rule LAPMTH
RUL_LABACC_ID	VARCHAR2	(0)		Rule Identifier for Rule LABACC
RUL_LAINVD_ID	VARCHAR2	(0)		Rule Identifier for Rule LAINVD
RUL_LAINPR_ID	VARCHAR2	(0)		Rule Identifier for Rule LAINPR
RUL_LAPMTH_OBJECT1_ID1	VARCHAR2	(0)		Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view
RUL_LAPMTH_OBJECT1_ID2	VARCHAR2	(0)		Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view
RUL_LAPMTH_NAME	VARCHAR2	(0)		Payment method name
RUL_LABACC_OBJECT1_ID1	VARCHAR2	(0)		Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view
RUL_LABACC_OBJECT1_ID2	VARCHAR2	(0)		Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view
RUL_LABACC_NAME	VARCHAR2	(0)		Bank account name
RUL_LABACC_BANK_NAME	VARCHAR2	(0)		Bank name
RGP_ID	VARCHAR2	(0)		Rule Group Identifier for Rule Group LABILL

Query Text

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


SELECT NAME
,      ITEM_DESCRIPTION
,      ID
,      DNZ_CHR_ID
,      BILL_TO_SITE_USE_ID
,      BILL_TO_SITE_NAME
,      CUST_ACCT_SITE_ID
,      RGP_LABILL_LAPMTH_ID
,      RGP_LABILL_LABACC_ID
,      RGP_LABILL_LAINVD_ID
,      RGP_LABILL_LAINPR_ID
,      RUL_LAPMTH_ID
,      RUL_LABACC_ID
,      RUL_LAINVD_ID
,      RUL_LAINPR_ID
,      RUL_LAPMTH_OBJECT1_ID1
,      RUL_LAPMTH_OBJECT1_ID2
,      RUL_LAPMTH_NAME
,      RUL_LABACC_OBJECT1_ID1
,      RUL_LABACC_OBJECT1_ID2
,      RUL_LABACC_NAME
,      RUL_LABACC_BANK_NAME
,      RGP_ID
FROM APPS.OKL_OR_ASSET_BILLING_SETUP_UV;

Dependencies

[top of page]

APPS.OKL_OR_ASSET_BILLING_SETUP_UV references the following:

APPS: HZ_CUST_SITE_USES_ALL; OKC_K_LINES_B; OKC_K_LINES_TL

APPS.OKL_OR_ASSET_BILLING_SETUP_UV is not referenced by any database object