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


VIEW: APPS.CE_BANK_ACCT_USES

Object Details
Object Name: CE_BANK_ACCT_USES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_BANK_ACCT_USES
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
BANK_ACCT_USE_ID NUMBER (15)
BANK_ACCOUNT_ID NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
PRIMARY_FLAG VARCHAR2 (1)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

ORG_ID NUMBER (15)
ORG_PARTY_ID NUMBER (15)
AP_USE_ENABLE_FLAG VARCHAR2 (1)
AR_USE_ENABLE_FLAG VARCHAR2 (1)
XTR_USE_ENABLE_FLAG VARCHAR2 (1)
PAY_USE_ENABLE_FLAG VARCHAR2 (1)
EDISC_RECEIVABLES_TRX_ID NUMBER (15)
UNEDISC_RECEIVABLES_TRX_ID NUMBER (15)
POOLED_FLAG VARCHAR2 (1)
END_DATE DATE

BR_STD_RECEIVABLES_TRX_ID NUMBER (15)
INVESTMENT_LIMIT_CODE VARCHAR2 (7)
FUNDING_LIMIT_CODE VARCHAR2 (7)
LEGAL_ENTITY_ID NUMBER (15)
AP_DEFAULT_SETTLEMENT_FLAG VARCHAR2 (1)
XTR_DEFAULT_SETTLEMENT_FLAG VARCHAR2 (1)
PAYROLL_BANK_ACCOUNT_ID NUMBER (15)
PRICING_MODEL VARCHAR2 (30)
AUTHORIZED_FLAG VARCHAR2 (1)
EFT_SCRIPT_NAME VARCHAR2 (50)
PORTFOLIO_CODE VARCHAR2 (7)
DEFAULT_ACCOUNT_FLAG VARCHAR2 (1)
OBJECT_VERSION_NUMBER NUMBER (15)
AR_CLAIM_INV_ACT_ID NUMBER (15)
NEW_AR_RCPTS_RECEIVABLE_TRX_ID NUMBER (15)
PAYMENT_DOC_CATEGORY VARCHAR2 (30)
Query Text

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


SELECT BANK_ACCT_USE_ID
,      BANK_ACCOUNT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PRIMARY_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
,      ORG_PARTY_ID
,      AP_USE_ENABLE_FLAG
,      AR_USE_ENABLE_FLAG
,      XTR_USE_ENABLE_FLAG
,      PAY_USE_ENABLE_FLAG
,      EDISC_RECEIVABLES_TRX_ID
,      UNEDISC_RECEIVABLES_TRX_ID
,      POOLED_FLAG
,      END_DATE
,      BR_STD_RECEIVABLES_TRX_ID
,      INVESTMENT_LIMIT_CODE
,      FUNDING_LIMIT_CODE
,      LEGAL_ENTITY_ID
,      AP_DEFAULT_SETTLEMENT_FLAG
,      XTR_DEFAULT_SETTLEMENT_FLAG
,      PAYROLL_BANK_ACCOUNT_ID
,      PRICING_MODEL
,      AUTHORIZED_FLAG
,      EFT_SCRIPT_NAME
,      PORTFOLIO_CODE
,      DEFAULT_ACCOUNT_FLAG
,      OBJECT_VERSION_NUMBER
,      AR_CLAIM_INV_ACT_ID
,      NEW_AR_RCPTS_RECEIVABLE_TRX_ID
,      PAYMENT_DOC_CATEGORY
FROM APPS.CE_BANK_ACCT_USES;

Dependencies

[top of page]

APPS.CE_BANK_ACCT_USES references the following:

SchemaAPPS
SynonymCE_BANK_ACCT_USES_ALL
SynonymCE_BANK_ACCT_USES_OU
ViewCE_SECURITY_PROFILES_V
PL/SQL PackageFND_ACCESS_CONTROL_UTIL - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageMO_GLOBAL - show dependent code
PL/SQL PackageXTR_USER_ACCESS - show dependent code
APPS.CE_BANK_ACCT_USES is referenced by following:

SchemaAPPS
Package BodyARP_BR_REMIT_BATCHES - show dependent code
Package BodyARP_PROCESS_APPLICATION - show dependent code
Package BodyARP_PROCESS_APPLICATION2 - show dependent code
Package BodyARP_PROCESS_CREDIT_UTIL - show dependent code
Package BodyARP_PROCESS_DET_PKG - show dependent code
Package BodyARP_PROGRAM_BR_REMIT - show dependent code
Package BodyARP_RW_BATCHES_PKG - show dependent code
Package BodyARP_TRX_VAL - show dependent code
Package BodyARP_TRX_VALIDATE - show dependent code
ViewAR_AEL_GL_CB_REC_V
ViewAR_AEL_GL_REC_V
ViewAR_AEL_SL_CB_REC_V
ViewAR_AEL_SL_REC_MRC_V
ViewAR_AEL_SL_REC_V
Package BodyAR_ARXAPRCL_XMLP_PKG - show dependent code
Package BodyAR_ARXAPRMB_XMLP_PKG - show dependent code
Package BodyAR_ARXSOC2_XMLP_PKG - show dependent code
Package BodyAR_ARXSOC_XMLP_PKG - show dependent code
Package BodyAR_ARZACS_XMLP_PKG - show dependent code
ViewAR_AUTOMATIC_RECEIPTS_FORMAT_V
ViewAR_BATCHES_V
Package BodyAR_BILLS_CREATION_VAL_PVT - show dependent code
ViewAR_BOE_REMIT_RECEIPTS_CBR_V
ViewAR_BOE_REMIT_RECEIPTS_CBUNR_V
ViewAR_BOE_REMIT_RECEIPTS_V
Package BodyAR_BR_REMIT_IMPORT_API_PUB - show dependent code
ViewAR_INTERIM_CASH_RECEIPTS_V
ViewAR_INTERIM_CR_LINES_V
Package BodyAR_PURGE - show dependent code
Package BodyAR_RECEIPT_LIB_PVT - show dependent code
Package BodyAR_RECEIPT_VAL_PVT - show dependent code
ViewAR_REMITTED_RECEIPTS_FORMAT_V
ViewAR_REMIT_BANK_ACCT_S_V
ViewAR_RX_OTHER_APPLICATIONS_V
Package BodyCE_AUTO_BANK_CLEAR1 - show dependent code
Package BodyFUN_NET_ARAP_PKG - show dependent code