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_RECEIPT_APPLIC_UV

Object Details

Object Name:	OKL_BPD_RECEIPT_APPLIC_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_BPD_RECEIPT_APPLIC_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
CUSTOMER_ID	NUMBER
CUSTOMER_NAME	VARCHAR2	(50)
CUSTOMER_NUMBER	VARCHAR2	(30)
CONSOLIDATED_INVOICE_ID	NUMBER
CONSOLIDATED_INVOICE_NUMBER	VARCHAR2	(90)
RCPT_CURRENCY	VARCHAR2	(15)
CONTRACT_ID	NUMBER
CONTRACT_LINE_ID	NUMBER
CONTRACT_NUMBER	VARCHAR2	(120)	Contract Number
RECEIPT_NUMBER	VARCHAR2	(90)
CASH_RECEIPT_ID	NUMBER		Cash Receipt ID
RECEIPT_DATE	DATE
EXT_CASH_APPS_ID	NUMBER
XTL_CASH_APPS_ID	NUMBER
RECEIVABLES_INVOICE_ID	NUMBER
AR_INVOICE_NUMBER	VARCHAR2	(30)
ASSET_ID	NUMBER
ASSET_NUMBER	VARCHAR2	(15)	Asset Number
ASSET_NAME	VARCHAR2	(80)
LSM_ID	NUMBER		Foreign key to view OKL_CNSLD_AR_STRMS_V
STREAM_ID	NUMBER
STREAM_NAME	VARCHAR2	(150)
OUTSTANDING_STREAM_AMOUNT	NUMBER
APPLIED_STREAM_AMOUNT	NUMBER
GL_DATE	DATE		GL processing date
IRM_ID	NUMBER
RECEIPT_AMOUNT	NUMBER
EXCHANGE_RATE	NUMBER
EXCHANGE_RATE_TYPE	VARCHAR2	(30)
EXCHANGE_RATE_DATE	DATE
STREAM_PURPOSE_MEANING	VARCHAR2	(4000)

Query Text

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


SELECT CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      CONSOLIDATED_INVOICE_ID
,      CONSOLIDATED_INVOICE_NUMBER
,      RCPT_CURRENCY
,      CONTRACT_ID
,      CONTRACT_LINE_ID
,      CONTRACT_NUMBER
,      RECEIPT_NUMBER
,      CASH_RECEIPT_ID
,      RECEIPT_DATE
,      EXT_CASH_APPS_ID
,      XTL_CASH_APPS_ID
,      RECEIVABLES_INVOICE_ID
,      AR_INVOICE_NUMBER
,      ASSET_ID
,      ASSET_NUMBER
,      ASSET_NAME
,      LSM_ID
,      STREAM_ID
,      STREAM_NAME
,      OUTSTANDING_STREAM_AMOUNT
,      APPLIED_STREAM_AMOUNT
,      GL_DATE
,      IRM_ID
,      RECEIPT_AMOUNT
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      STREAM_PURPOSE_MEANING
FROM APPS.OKL_BPD_RECEIPT_APPLIC_UV;

Dependencies

[top of page]

APPS.OKL_BPD_RECEIPT_APPLIC_UV references the following:

APPS: AR_PAYMENT_SCHEDULES_ALL; FA_ADDITIONS_V; HZ_CUST_ACCOUNTS; HZ_PARTIES; OKC_K_HEADERS_ALL_B; OKC_K_ITEMS; OKC_K_LINES_B; OKC_LINE_STYLES_B; OKL_ACCOUNTING_UTIL - show dependent code; OKL_CNSLD_AR_HDRS_B; OKL_CNSLD_AR_LINES_B; OKL_CNSLD_AR_STRMS_B; OKL_EXT_CSH_RCPTS_ALL_B; OKL_STRM_TYPE_V; OKL_TRX_CSH_RCPT_ALL_B; OKL_XTL_CSH_APPS_ALL_B

APPS.OKL_BPD_RECEIPT_APPLIC_UV is not referenced by any database object