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_BILL_SETUP_UV

Object Details

Object Name:	OKL_KHR_TNC_BILL_SETUP_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_KHR_TNC_BILL_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
CHR_ID	NUMBER		Yes	Unique identifier of Contract. Also primary key column of the table.
BILL_TO_SITE_USE_ID	NUMBER	(15)		Stores account site use identifier. This column is used to identify the billing address of the customer account. References HZ_CUST_ACCT_SITES_ALL.SITE_USE_ID where SITE_USE_CODE='BILL_TO'.
BILL_TO_SITE_NAME	VARCHAR2	(40)		Site use identifier
RGP_ID	VARCHAR2	(0)		Placeholder for Rule Group Identifier
RGP_LABILL_LAPMTH_ID	VARCHAR2	(0)		Placeholder for Rule Group Identifier
RGP_LABILL_LABACC_ID	VARCHAR2	(0)		Placeholder for Rule Group Identifier
RGP_LABILL_LAINVD_ID	VARCHAR2	(0)		Placeholder for Rule Group Identifier
RGP_LABILL_LAINPR_ID	VARCHAR2	(0)		Placeholder for Rule Group Identifier
RUL_LAPMTH_ID	VARCHAR2	(0)		Placeholder for Rule Identifier for Rule LAPMTH
RUL_LABACC_ID	VARCHAR2	(0)		Placeholder for Rule Identifier for Rule LABACC
RUL_LAINVD_ID	VARCHAR2	(0)		Placeholder for Rule Identifier for Rule LAINVD
RUL_LAINPR_ID	VARCHAR2	(0)		Placeholder for 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)		Placeholder for 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)		Placeholder for Bank Account Name
RUL_LABACC_BANK_NAME	VARCHAR2	(0)		Placeholder for Bank Name
LAINVD_RULE_INFORMATION1	VARCHAR2	(0)		Placeholder for RULE_INFORMATION1 for Rule LAINVD
LAINVD_INVOICE_FORMAT_MEANING	VARCHAR2	(0)		Placeholder for Invoice Format Name
LAINVD_RULE_INFORMATION3	VARCHAR2	(0)		Placeholder for RULE_INFORMATION3 for Rule LAINVD
LAINVD_RULE_INFORMATION4	VARCHAR2	(0)		Placeholder for RULE_INFORMATION4 for Rule LAINVD
RUL_LAINVD_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_LAINVD_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_LAINVD_NAME	VARCHAR2	(0)		Placeholder for Cash Application Rule Name
LAINPR_RULE_INFORMATION1	VARCHAR2	(0)		Placeholder for RULE_INFORMATION1 for Rule LAINPR
LAINPR_RULE_INFORMATION2	VARCHAR2	(0)		Placeholder for RULE_INFORMATION2 for Rule LAINPR
CUST_ACCT_ID	NUMBER	(15)		Customer Acccount Identifier

Query Text

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


SELECT CHR_ID
,      BILL_TO_SITE_USE_ID
,      BILL_TO_SITE_NAME
,      RGP_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
,      LAINVD_RULE_INFORMATION1
,      LAINVD_INVOICE_FORMAT_MEANING
,      LAINVD_RULE_INFORMATION3
,      LAINVD_RULE_INFORMATION4
,      RUL_LAINVD_OBJECT1_ID1
,      RUL_LAINVD_OBJECT1_ID2
,      RUL_LAINVD_NAME
,      LAINPR_RULE_INFORMATION1
,      LAINPR_RULE_INFORMATION2
,      CUST_ACCT_ID
FROM APPS.OKL_KHR_TNC_BILL_SETUP_UV;

Dependencies

[top of page]

APPS.OKL_KHR_TNC_BILL_SETUP_UV references the following:

APPS: HZ_CUST_SITE_USES_ALL; OKC_K_HEADERS_B

APPS.OKL_KHR_TNC_BILL_SETUP_UV is not referenced by any database object