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_BPD_AR_INV_LN_DTLS_V

Object Details

Object Name:	OKL_BPD_AR_INV_LN_DTLS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_BPD_AR_INV_LN_DTLS_V
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
CONTRACT_NUMBER	VARCHAR2	(150)	Contract Number
CONTRACT_LINE_ID	NUMBER		Contract Line identifier
CONSOLIDATED_LINE_NUMBER	NUMBER		Consolidated invoice line number
LINE_NAME	VARCHAR2	(150)	Invoice format line type name
AMOUNT_DUE_ORIGINAL	NUMBER		Amount due original
AMOUNT_PAID	NUMBER		Amount paid
BALANCE	NUMBER		Remaining amount
AMOUNT_APPLIED	NUMBER		Amount applied
AMOUNT_CREDITED	NUMBER		Amount credited
TAX_AMOUNT	NUMBER		Tax Amount
RECEIVABLES_INVOICE_NUMBER	VARCHAR2	(30)	Receivables invoice number
STREAM_TYPE	VARCHAR2	(150)	Stream Type
STREAM_PURPOSE_MEANING	VARCHAR2	(80)	Stream Purpose
CURRENCY_CODE	VARCHAR2	(15)	Currency Code
CUSTOMER_TRX_ID	NUMBER	(15)	Invoice identifier
CUSTOMER_TRX_LINE_ID	NUMBER	(15)	Invoice line identifier
CONSOLIDATED_INVOICE_NUMBER	VARCHAR2	(90)	Consolidated invoice number
IXX_ID	NUMBER	(15)	Customer account identifier
TXN_LINE_TYPE	VARCHAR2	(20)	Invoice format line type
TLD_ID	VARCHAR2	(150)	Foreign key of OKL_TXD_AR_LN_DTLS_B.id
ORG_ID	NUMBER	(15)	Operating unit identifier

Query Text

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


SELECT CONTRACT_NUMBER
,      CONTRACT_LINE_ID
,      CONSOLIDATED_LINE_NUMBER
,      LINE_NAME
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_PAID
,      BALANCE
,      AMOUNT_APPLIED
,      AMOUNT_CREDITED
,      TAX_AMOUNT
,      RECEIVABLES_INVOICE_NUMBER
,      STREAM_TYPE
,      STREAM_PURPOSE_MEANING
,      CURRENCY_CODE
,      CUSTOMER_TRX_ID
,      CUSTOMER_TRX_LINE_ID
,      CONSOLIDATED_INVOICE_NUMBER
,      IXX_ID
,      TXN_LINE_TYPE
,      TLD_ID
,      ORG_ID
FROM APPS.OKL_BPD_AR_INV_LN_DTLS_V;

Dependencies

[top of page]

APPS.OKL_BPD_AR_INV_LN_DTLS_V references the following:

APPS: AR_PAYMENT_SCHEDULES_ALL; AR_RECEIVABLE_APPLICATIONS_ALL; FND_GLOBAL - show dependent code; FND_LOOKUPS; HZ_CUST_ACCOUNTS; OKC_K_HEADERS_B; OKL_ACCOUNTING_UTIL - show dependent code; OKL_BILLING_UTIL_PVT - show dependent code; OKL_BPD_AR_INV_LINES_V; OKL_CNSLD_AR_HDRS_B; OKL_CNSLD_AR_LINES_B; OKL_CNSLD_AR_STRMS_B; OKL_INVC_LINE_TYPES_V; OKL_STRM_TYPE_V; RA_CUSTOMER_TRX_LINES_ALL

APPS.OKL_BPD_AR_INV_LN_DTLS_V is not referenced by any database object