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.OKI_HBILLTO_DTL_V

Object Details

Object Name:	OKI_HBILLTO_DTL_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

This view contains Billing information for Contract Headers, like billing address. Billed party account etc.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BILL_SITE_ID	NUMBER	(15)	Yes	Site use identifier
BILL_TO_PARTY_ACCOUNT	VARCHAR2	(603)		Party account being billed
BILL_TO_LOCATION	VARCHAR2	(40)	Yes	Location of party being billed
BILL_TO_ADDRESS1	VARCHAR2	(240)	Yes	Billing address
BILL_TO_ADDRESS2	VARCHAR2	(240)		Billing address
BILL_TO_ADDRESS3	VARCHAR2	(240)		Billing address
BILL_TO_CITY	VARCHAR2	(60)		City to which Billing address belongs to
BILL_TO_POSTAL_CODE	VARCHAR2	(60)		Postal code of the Billing address
BILL_TO_STATE	VARCHAR2	(60)		State where party is being billed to
BILL_TO_COUNTRY	VARCHAR2	(60)	Yes	Country of the Billing address

Query Text

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


SELECT BILL_SITE_ID
,      BILL_TO_PARTY_ACCOUNT
,      BILL_TO_LOCATION
,      BILL_TO_ADDRESS1
,      BILL_TO_ADDRESS2
,      BILL_TO_ADDRESS3
,      BILL_TO_CITY
,      BILL_TO_POSTAL_CODE
,      BILL_TO_STATE
,      BILL_TO_COUNTRY
FROM APPS.OKI_HBILLTO_DTL_V;

Dependencies

[top of page]

APPS.OKI_HBILLTO_DTL_V references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES

APPS.OKI_HBILLTO_DTL_V is not referenced by any database object