[Home] [Help] [Dependency Information]
Object Name: | AR_RX_OTHER_APPLICATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AR.AR_RX_OTHER_APPLICATIONS_V |
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 |
---|---|---|---|---|
SET_OF_BOOKS | VARCHAR2 | (30) | Yes | |
COMPANY_SEGMENT | VARCHAR2 | (4000) | ||
CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
CUSTOMER_NAME | VARCHAR2 | (50) | ||
LOCATION_NAME | VARCHAR2 | (40) | ||
RECEIPT_NUMBER | VARCHAR2 | (30) | ||
RECEIPT_DATE | DATE | Yes | ||
APPLY_DATE | DATE | Yes | ||
GL_DATE | DATE | Yes | ||
RECEIPT_CURRENCY | VARCHAR2 | (15) | Yes | |
APPLICATION_TYPE | VARCHAR2 | (30) | ||
RECEIPT_AMOUNT | NUMBER | Yes | ||
AMOUNT_APPLIED | NUMBER | Yes | ||
ACCOUNTED_AMOUNT | NUMBER | Yes | ||
ACTIVITY_NAME | VARCHAR2 | (50) | ||
COMMENTS | VARCHAR2 | (240) | ||
BATCH_NAME | VARCHAR2 | (20) | ||
BATCH_SOURCE | VARCHAR2 | (50) | ||
DOC_SEQUENCE | NUMBER | (15) | ||
ACCTD_RECEIPT_AMOUNT | NUMBER | Yes | ||
POST_MARK_DATE | DATE | |||
DEPOSIT_DATE | DATE | |||
RECEIPT_METHOD | VARCHAR2 | (30) | ||
BANK_NAME | VARCHAR2 | (360) | Yes | |
BANK_BRANCH | VARCHAR2 | (360) | Yes | |
ACCOUNT_NUMBER | VARCHAR2 | (30) | ||
BANK_ACCOUNT_CURRENCY | VARCHAR2 | (15) | ||
ACCOUNTING_FLEXFIELD | VARCHAR2 | (4000) | ||
APPLICATION_REF_TYPE | VARCHAR2 | (4000) | ||
APPLICATION_REF_NUM | VARCHAR2 | (30) | ||
RECEIPT_BATCH_NAME | VARCHAR2 | (20) |
Cut, paste (and edit) the following text to query this object:
SELECT SET_OF_BOOKS
, COMPANY_SEGMENT
, CUSTOMER_NUMBER
, CUSTOMER_NAME
, LOCATION_NAME
, RECEIPT_NUMBER
, RECEIPT_DATE
, APPLY_DATE
, GL_DATE
, RECEIPT_CURRENCY
, APPLICATION_TYPE
, RECEIPT_AMOUNT
, AMOUNT_APPLIED
, ACCOUNTED_AMOUNT
, ACTIVITY_NAME
, COMMENTS
, BATCH_NAME
, BATCH_SOURCE
, DOC_SEQUENCE
, ACCTD_RECEIPT_AMOUNT
, POST_MARK_DATE
, DEPOSIT_DATE
, RECEIPT_METHOD
, BANK_NAME
, BANK_BRANCH
, ACCOUNT_NUMBER
, BANK_ACCOUNT_CURRENCY
, ACCOUNTING_FLEXFIELD
, APPLICATION_REF_TYPE
, APPLICATION_REF_NUM
, RECEIPT_BATCH_NAME
FROM APPS.AR_RX_OTHER_APPLICATIONS_V;
APPS.AR_RX_OTHER_APPLICATIONS_V is not referenced by any database object
|
|
|