DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.ARBV_RECEIPT_HISTORIES

Object Details
Object Name: ARBV_RECEIPT_HISTORIES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.ARBV_RECEIPT_HISTORIES
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
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)
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
,      ORG_ID
,      CASH_RECEIPT_ID
,      BATCH_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.ARBV_RECEIPT_HISTORIES;

Dependencies

[top of page]

APPS.ARBV_RECEIPT_HISTORIES references the following:

SchemaAPPS
SynonymAR_CASH_RECEIPT_HISTORY

APPS.ARBV_RECEIPT_HISTORIES is not referenced by any database object