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.ARFV_RECEIPT_HISTORIES

Object Details

Object Name:	ARFV_RECEIPT_HISTORIES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.ARFV_RECEIPT_HISTORIES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory
CASH_RECEIPT_HISTORY_ID	NUMBER	(15)	Yes
AMOUNT	NUMBER		Yes
FACTOR_DISCOUNT_AMOUNT	NUMBER
FUNCTIONAL_AMOUNT	NUMBER		Yes
FUNC_FACTOR_DISCOUNT_AMOUNT	NUMBER
_LA:RECEIPT_STATUS	CHAR	(57)
CURRENCY_EXCHANGE_DATE	DATE
CURRENCY_EXCHANGE_RATE	NUMBER
CURRENCY_EXCHANGE_RATE_TYPE	VARCHAR2	(30)
_LA:CURRENT_RECORD_FLAG	CHAR	(53)
_LA:FACTORING_FLAG	CHAR	(45)
_LA:NOTE_STATUS	CHAR	(53)
OPERATING_UNIT	VARCHAR2	(240)
RECEIPT_NUMBER	VARCHAR2	(30)
RECEIPT_BATCH_NAME	VARCHAR2	(20)
ORG_ID	NUMBER	(15)
CASH_RECEIPT_ID	NUMBER	(15)	Yes
BATCH_ID	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes

Query Text

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


SELECT CASH_RECEIPT_HISTORY_ID
,      AMOUNT
,      FACTOR_DISCOUNT_AMOUNT
,      FUNCTIONAL_AMOUNT
,      FUNC_FACTOR_DISCOUNT_AMOUNT
,      _LA:RECEIPT_STATUS
,      CURRENCY_EXCHANGE_DATE
,      CURRENCY_EXCHANGE_RATE
,      CURRENCY_EXCHANGE_RATE_TYPE
,      _LA:CURRENT_RECORD_FLAG
,      _LA:FACTORING_FLAG
,      _LA:NOTE_STATUS
,      OPERATING_UNIT
,      RECEIPT_NUMBER
,      RECEIPT_BATCH_NAME
,      ORG_ID
,      CASH_RECEIPT_ID
,      BATCH_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.ARFV_RECEIPT_HISTORIES;

Dependencies

[top of page]

APPS.ARFV_RECEIPT_HISTORIES references the following:

APPS: AR_BATCHES; AR_CASH_RECEIPTS; AR_CASH_RECEIPT_HISTORY; HR_ALL_ORGANIZATION_UNITS

APPS.ARFV_RECEIPT_HISTORIES is not referenced by any database object