[Home] [Help]
[Dependency Information]
| Object Name: | ARBV_RECEIPT_HISTORIES |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | AR.ARBV_RECEIPT_HISTORIES
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| 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 |
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;
APPS
AR_CASH_RECEIPT_HISTORY
APPS.ARBV_RECEIPT_HISTORIES is not referenced by any database object
|
|
|
|