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_BILLING_TRX_ALL_UV

Object Details

Object Name:	OKL_BILLING_TRX_ALL_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_BILLING_TRX_ALL_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	(120)	Contract Number
TRANSACTION_TYPE	VARCHAR2	(150)	Transaction Type.
CONSOLIDATED_INVOICE_NUMBER	VARCHAR2	(90)	Consolidated Invoice Number.
CONSOLIDATED_INVOICE_AMOUNT	NUMBER	(14)	Consolidated Invoice Amount.
AR_INVOICE_NUMBER	VARCHAR2	(30)	AR Invoice Number.
ASSET_NUMBER	VARCHAR2	(4000)	Asset Number
INVOICE_DATE	DATE		Invoice Date.
DUE_DATE	DATE		Due Date.
TRANSACTION_AMOUNT	NUMBER		The original amount due
AMOUNT_APPLIED	NUMBER		Amount Applied.
AMOUNT_REMAINING	NUMBER		Amount Remaining.
CUSTOMER_ACCOUNT_ID	NUMBER		Customer Account Identifier.
CONTRACT_AUTHORING_ORG_ID	NUMBER		Contract Authoring Operating Unit Identifier.
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		Asset Identifier.
CNR_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 Type.
AR_EXCHANGE_RATE	NUMBER		AR Exchange Rate.
AR_EXCHANGE_DATE	DATE		AR Exchange Date.
AR_TRX_DATE	DATE		AR Transaction Date.
AMOUNT_LINE_ITEMS_ORIGINAL	NUMBER		Line Item Original Amount.
AMOUNT_LINE_ITEMS_REMAINING	NUMBER		Line Item Remaining Amount.
TAX_ORIGINAL	NUMBER		Original Tax.
TAX_REMAINING	NUMBER		Tax Remaining.
AMOUNT_CREDITED	NUMBER		Amount Credited
CUSTOMER_TRX_ID	NUMBER	(15)	Customer Trx Id

Query Text

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


SELECT LSM_ID
,      CONTRACT_NUMBER
,      TRANSACTION_TYPE
,      CONSOLIDATED_INVOICE_NUMBER
,      CONSOLIDATED_INVOICE_AMOUNT
,      AR_INVOICE_NUMBER
,      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
,      CNR_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
FROM APPS.OKL_BILLING_TRX_ALL_UV;

Dependencies

[top of page]

APPS.OKL_BILLING_TRX_ALL_UV references the following:

APPS: AR_PAYMENT_SCHEDULES_ALL; FA_ADDITIONS_B; OKC_K_HEADERS_ALL_B; OKC_K_ITEMS; OKC_K_LINES_B; OKC_K_LINES_TL; OKC_LINE_STYLES_B; OKL_CNSLD_AR_HDRS_ALL_B; OKL_CNSLD_AR_LINES_B; OKL_CNSLD_AR_STRMS_B; OKL_CS_LC_CONTRACT_PVT - show dependent code; OKL_K_HEADERS; OKL_STRM_TYPE_TL

APPS.OKL_BILLING_TRX_ALL_UV is not referenced by any database object