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_RECEIPT_SUMMARY_UV

Object Details

Object Name:	OKL_RECEIPT_SUMMARY_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_RECEIPT_SUMMARY_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	Mandatory	Comments
CASH_RECEIPT_ID	NUMBER	(15)	Yes	Cash Receipt Id
RECEIPT_NUMBER	VARCHAR2	(30)		Cash Receipt Id
RECEIPT_DATE	DATE		Yes	RECEIPT_DATE
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency Code
ORG_ID	NUMBER	(15)		Org Id
OPERATING_UNIT	VARCHAR2	(240)	Yes	Operating Unit
LEGAL_ENTITY_ID	NUMBER	(15)		Legal Entity Id
RECEIPT_AMOUNT	NUMBER		Yes	Receipt Amount
RECEIPT_STATUS	VARCHAR2	(30)	Yes	Receipt Status
CUSTOMER_ACCOUNT_ID	NUMBER	(15)		Customer Account Id
CUSTOMER_ACCOUNT_NUMBER	VARCHAR2	(30)		Customer Account Number
CUSTOMER_ID	VARCHAR2	(30)		Customer Id
CUSTOMER_NAME	VARCHAR2	(360)		Customer Name
RECEIPT_METHOD	VARCHAR2	(30)	Yes	Receipt Method
RECEIPT_METHOD_ID	NUMBER	(15)	Yes	Receipt Method Id
GL_DATE	DATE		Yes	Gl Date
RECEIPT_TYPE	VARCHAR2	(10)		Receipt Type

Query Text

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


SELECT CASH_RECEIPT_ID
,      RECEIPT_NUMBER
,      RECEIPT_DATE
,      CURRENCY_CODE
,      ORG_ID
,      OPERATING_UNIT
,      LEGAL_ENTITY_ID
,      RECEIPT_AMOUNT
,      RECEIPT_STATUS
,      CUSTOMER_ACCOUNT_ID
,      CUSTOMER_ACCOUNT_NUMBER
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      RECEIPT_METHOD
,      RECEIPT_METHOD_ID
,      GL_DATE
,      RECEIPT_TYPE
FROM APPS.OKL_RECEIPT_SUMMARY_UV;

Dependencies

[top of page]

APPS.OKL_RECEIPT_SUMMARY_UV references the following:

APPS: AR_CASH_RECEIPTS_ALL; AR_CASH_RECEIPT_HISTORY_ALL; AR_RECEIPT_METHODS; HR_OPERATING_UNITS; HZ_CUST_ACCOUNTS_ALL; HZ_PARTIES; OKL_TRX_CSH_RCPT_ALL_B

APPS.OKL_RECEIPT_SUMMARY_UV is not referenced by any database object