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_CS_BILLINGTRX_UV

Object Details

Object Name:	OKL_CS_BILLINGTRX_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_CS_BILLINGTRX_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	Comments
LSM_ID	NUMBER		Foreign key to view OKL_CNSLD_AR_STRMS_V
CONTRACT_NUMBER	VARCHAR2	(150)	Contract Number
TRANSACTION_TYPE	VARCHAR2	(150)
INVOICE_NUMBER	VARCHAR2	(90)
INVOICE_AMOUNT	NUMBER
LINE_IDENTIFIER	NUMBER
ASSET_NUMBER	VARCHAR2	(4000)	Asset Number
INVOICE_DATE	DATE
DUE_DATE	DATE
TRANSACTION_AMOUNT	NUMBER		The original amount due
AMOUNT_APPLIED	NUMBER
AMOUNT_REMAINING	NUMBER
CUSTOMER_ACCOUNT_ID	NUMBER
CONTRACT_AUTHORING_ORG_ID	NUMBER	(15)
KHR_ID	NUMBER		Foreign key to view OKL_K_HEADERS_V
KLE_ID	NUMBER		Foreign key to view OKL_K_LINES_V
ASSET_ID	NUMBER
INVOICE_ID	NUMBER		Foreign key to view OKL_CNSLD_AR_HDRS_V
STY_ID	NUMBER		Foreign key to view OKL_STRM_TYPE_V
CURRENCY_CODE	VARCHAR2	(15)	Currency Code
AR_EXCHANGE_RATE_TYPE	VARCHAR2	(30)
AR_EXCHANGE_RATE	NUMBER
AR_EXCHANGE_DATE	DATE
AR_TRX_DATE	DATE
AMOUNT_LINE_ITEMS_ORIGINAL	NUMBER
AMOUNT_LINE_ITEMS_REMAINING	NUMBER
TAX_ORIGINAL	NUMBER
TAX_REMAINING	NUMBER
AMOUNT_CREDITED	NUMBER		Amount Credited
CUSTOMER_TRX_ID	NUMBER		Customer Trx Id
INVOICE_LINE_ID	NUMBER	(15)	Invoice Line Id for AR Invoice
PAYMENT_TERM	CHAR	(9)	Payment Term for AR Invoice
INVOICE_TYPE	VARCHAR2	(12)	Invoice type identifier
AMOUNT_ADJUSTED	NUMBER		Invoice amount adjusted

Query Text

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


SELECT LSM_ID
,      CONTRACT_NUMBER
,      TRANSACTION_TYPE
,      INVOICE_NUMBER
,      INVOICE_AMOUNT
,      LINE_IDENTIFIER
,      ASSET_NUMBER
,      INVOICE_DATE
,      DUE_DATE
,      TRANSACTION_AMOUNT
,      AMOUNT_APPLIED
,      AMOUNT_REMAINING
,      CUSTOMER_ACCOUNT_ID
,      CONTRACT_AUTHORING_ORG_ID
,      KHR_ID
,      KLE_ID
,      ASSET_ID
,      INVOICE_ID
,      STY_ID
,      CURRENCY_CODE
,      AR_EXCHANGE_RATE_TYPE
,      AR_EXCHANGE_RATE
,      AR_EXCHANGE_DATE
,      AR_TRX_DATE
,      AMOUNT_LINE_ITEMS_ORIGINAL
,      AMOUNT_LINE_ITEMS_REMAINING
,      TAX_ORIGINAL
,      TAX_REMAINING
,      AMOUNT_CREDITED
,      CUSTOMER_TRX_ID
,      INVOICE_LINE_ID
,      PAYMENT_TERM
,      INVOICE_TYPE
,      AMOUNT_ADJUSTED
FROM APPS.OKL_CS_BILLINGTRX_UV;

Dependencies

[top of page]

APPS.OKL_CS_BILLINGTRX_UV references the following:

APPS: AR_PAYMENT_SCHEDULES_ALL; FA_ADDITIONS_B; FND_GLOBAL - show dependent code; OKC_K_ITEMS; OKC_K_LINES_B; OKC_K_LINES_TL; OKC_LINE_STYLES_B; OKL_BILLING_UTIL_PVT - show dependent code; OKL_CS_BPD_INV_DTL_V; OKL_CS_LC_CONTRACT_PVT - show dependent code; OKL_K_HEADERS; OKL_STRM_TYPE_TL

APPS.OKL_CS_BILLINGTRX_UV is referenced by following:

APPS: OKL_CS_DEPRECN_SCHEDULES_UV; OKL_CS_VAT_SCHEDULES_UV