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

Object Details

Object Name:	AR_REMIT_BANK_ACCT_H_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.AR_REMIT_BANK_ACCT_H_V
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
RMT_BNK_ACCOUNT_USE	VARCHAR2	(30)	Yes
RMT_BNK_ASSET_CCID	NUMBER	(15)
RMT_BNK_ACCOUNT_ID	NUMBER	(15)	Yes
RMT_BNK_ACCOUNT_NAME	VARCHAR2	(100)	Yes
RMT_BNK_ACCOUNT_NAME_ALT	VARCHAR2	(240)
RMT_BNK_ACCOUNT_NUM	VARCHAR2	(30)
RMT_BNK_ACCOUNT_TYPE	VARCHAR2	(25)
RMT_BNK_BANK_CHARGES_CCID	NUMBER	(15)
RMT_BNK_BANK_ERRORS_CCID	NUMBER	(15)
RMT_BNK_CASH_CLEARING_CCID	NUMBER	(15)
RMT_BNK_CURRENCY_CODE	VARCHAR2	(15)
RMT_BNK_DESCRIPTION	VARCHAR2	(240)
RMT_BNK_FUTURE_PMT_CCID	NUMBER	(15)
RMT_BNK_GAIN_CCID	NUMBER	(15)
RMT_BNK_LOSS_CCID	NUMBER	(15)
RMT_BNK_RCT_CLEARING_CCID	NUMBER	(15)
RMT_BNK_SHORT_TRM_DEP_CCID	NUMBER	(15)
RMT_BNK_AGENCY_LOC_CODE	VARCHAR2	(30)
RMT_BNK_GLOBAL_ATTR1	VARCHAR2	(150)
RMT_BNK_GLOBAL_ATTR10	VARCHAR2	(150)
RMT_BNK_GLOBAL_ATTR18	VARCHAR2	(150)
RMT_BNK_GLOBAL_ATTR19	VARCHAR2	(150)
RMT_BNK_GLOBAL_ATTR2	VARCHAR2	(150)
RMT_BNK_GLOBAL_ATTR20	VARCHAR2	(150)
RMT_BNK_GLOBAL_ATTR3	VARCHAR2	(150)
RMT_BNK_GLOBAL_ATTR4	VARCHAR2	(150)
RMT_BNK_GLOBAL_ATTR5	VARCHAR2	(150)
RMT_BNK_GLOBAL_ATTR6	VARCHAR2	(150)
RMT_BNK_GLOBAL_ATTR7	VARCHAR2	(150)
RMT_BNK_GLOBAL_ATTR8	VARCHAR2	(150)
RMT_BNK_GLOBAL_ATTR9	VARCHAR2	(150)
RMT_BNK_GLOBAL_ATTR_CAT	VARCHAR2	(30)
RMT_BNK_IBAN_NUMBER	VARCHAR2	(50)
EVENT_ID	NUMBER	(15)
LEDGER_ID	NUMBER	(15)
RMT_BNK_CASH_CCID	NUMBER	(15)	Yes
RMT_BNK_CHARGES_CCID	NUMBER	(15)
RMT_BNK_BR_FACTOR_CCID	NUMBER	(15)
RMT_BNK_BR_REMITTANCE_CCID	NUMBER	(15)
RMT_BNK_EARNED_CCID	NUMBER
RMT_BNK_FACTOR_CCID	NUMBER	(15)
RMT_BNK_ON_ACCOUNT_CCID	NUMBER	(15)	Yes
RMT_BNK_CONFIRMATION_CCID	NUMBER	(15)
RMT_BNK_REMITTANCE_CCID	NUMBER	(15)
RMT_BNK_DEPOSIT_CCID	NUMBER	(15)
RMT_BNK_UNAPPLIED_CCID	NUMBER	(15)	Yes
RMT_BNK_UNEARNED_CCID	NUMBER
RMT_BNK_UNIDENTIFIED_CCID	NUMBER	(15)	Yes
RMT_BANK_NAME	VARCHAR2	(240)
RMT_BANK_NUM	VARCHAR2	(30)
RMT_BANK_BRANCH_NAME	VARCHAR2	(240)
RMT_BANK_BRANCH_NUM	VARCHAR2	(30)

Query Text

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


SELECT RMT_BNK_ACCOUNT_USE
,      RMT_BNK_ASSET_CCID
,      RMT_BNK_ACCOUNT_ID
,      RMT_BNK_ACCOUNT_NAME
,      RMT_BNK_ACCOUNT_NAME_ALT
,      RMT_BNK_ACCOUNT_NUM
,      RMT_BNK_ACCOUNT_TYPE
,      RMT_BNK_BANK_CHARGES_CCID
,      RMT_BNK_BANK_ERRORS_CCID
,      RMT_BNK_CASH_CLEARING_CCID
,      RMT_BNK_CURRENCY_CODE
,      RMT_BNK_DESCRIPTION
,      RMT_BNK_FUTURE_PMT_CCID
,      RMT_BNK_GAIN_CCID
,      RMT_BNK_LOSS_CCID
,      RMT_BNK_RCT_CLEARING_CCID
,      RMT_BNK_SHORT_TRM_DEP_CCID
,      RMT_BNK_AGENCY_LOC_CODE
,      RMT_BNK_GLOBAL_ATTR1
,      RMT_BNK_GLOBAL_ATTR10
,      RMT_BNK_GLOBAL_ATTR18
,      RMT_BNK_GLOBAL_ATTR19
,      RMT_BNK_GLOBAL_ATTR2
,      RMT_BNK_GLOBAL_ATTR20
,      RMT_BNK_GLOBAL_ATTR3
,      RMT_BNK_GLOBAL_ATTR4
,      RMT_BNK_GLOBAL_ATTR5
,      RMT_BNK_GLOBAL_ATTR6
,      RMT_BNK_GLOBAL_ATTR7
,      RMT_BNK_GLOBAL_ATTR8
,      RMT_BNK_GLOBAL_ATTR9
,      RMT_BNK_GLOBAL_ATTR_CAT
,      RMT_BNK_IBAN_NUMBER
,      EVENT_ID
,      LEDGER_ID
,      RMT_BNK_CASH_CCID
,      RMT_BNK_CHARGES_CCID
,      RMT_BNK_BR_FACTOR_CCID
,      RMT_BNK_BR_REMITTANCE_CCID
,      RMT_BNK_EARNED_CCID
,      RMT_BNK_FACTOR_CCID
,      RMT_BNK_ON_ACCOUNT_CCID
,      RMT_BNK_CONFIRMATION_CCID
,      RMT_BNK_REMITTANCE_CCID
,      RMT_BNK_DEPOSIT_CCID
,      RMT_BNK_UNAPPLIED_CCID
,      RMT_BNK_UNEARNED_CCID
,      RMT_BNK_UNIDENTIFIED_CCID
,      RMT_BANK_NAME
,      RMT_BANK_NUM
,      RMT_BANK_BRANCH_NAME
,      RMT_BANK_BRANCH_NUM
FROM APPS.AR_REMIT_BANK_ACCT_H_V;