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_BILL_HIST_V

Object Details

Object Name:	OKI_BILL_HIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKI.OKI_BILL_HIST_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view shows the billing for a service contract.
A bill will show in this view if it has been interfaced to AR. If AR has not created an invoice, or if the program to fetch invoice numbers from AR has not been run, then the invoice number will show as -99.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONTRACT_ID	NUMBER		Yes	The contract header identifier for this billing activity.
CONTRACT_LINE_ID	NUMBER		Yes	Internal contract line identifier.
CONTRACT_NUMBER	VARCHAR2	(120)		Contract number for this contract.
CONTRACT_NUMBER_MODIFIER	VARCHAR2	(120)		Contract number modifier for this contract.
LINE_NUMBER	VARCHAR2	(150)		The external idenfitier of the billed line.
INVOICE_DATE	DATE			Transaction date.
INVOICE_NUMBER	VARCHAR2	(60)		The invoice number.
INVOICE_AMOUNT	NUMBER			Transaction amount. Includes any tax amount added by AR.
CURRENCY_CODE	VARCHAR2	(45)	Yes	Billing currency code.
INVOICE_CLASS	VARCHAR2	(60)		The class of the invoice.
LINE_AMOUNT	NUMBER	(17)		Resulting monetary amount.
DATE_BILLED_FROM	DATE		Yes	The starting date of the billed period.
DATE_BILLED_TO	DATE		Yes	The ending date of the billed period.
BILL_ACTION	VARCHAR2	(9)		Billing action (e.g. 'REG'ular, 'AVE'rage, 'SET'tlle).

Query Text

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


SELECT CONTRACT_ID
,      CONTRACT_LINE_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      LINE_NUMBER
,      INVOICE_DATE
,      INVOICE_NUMBER
,      INVOICE_AMOUNT
,      CURRENCY_CODE
,      INVOICE_CLASS
,      LINE_AMOUNT
,      DATE_BILLED_FROM
,      DATE_BILLED_TO
,      BILL_ACTION
FROM APPS.OKI_BILL_HIST_V;

Dependencies

[top of page]

APPS.OKI_BILL_HIST_V references the following:

APPS: OKI_SOLD_ITM_LINES; OKS_BILL_CONT_LINES; OKS_BILL_TRANSACTIONS

APPS.OKI_BILL_HIST_V is not referenced by any database object