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

VIEW: APPS.OKX_RCPT_METHOD_ACCOUNTS_V

Object Details
Object Name: OKX_RCPT_METHOD_ACCOUNTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_RCPT_METHOD_ACCOUNTS_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 Comments
ID1 NUMBER (15)
Primary key column. Uniquely identifies the Bank Account uses
ID2 CHAR (1)
Primary key column
NAME VARCHAR2 (121)
Bank account name concatenated with location
DESCRIPTION VARCHAR2 (100)
Bank account number
BANK_NAME VARCHAR2 (360)
Bank name
BANK_ACCOUNT_ID NUMBER (15)
Bank account identifier
BANK_ACCOUNT_NUM VARCHAR2 (100)
Bank account number
BANK_BRANCH_ID NUMBER

Identifier for bank branch
SET_OF_BOOKS_ID VARCHAR2 (0)
No Longer Used
CURRENCY_CODE VARCHAR2 (15)
Account currency code
ACCOUNT_TYPE VARCHAR2 (30)
Bank account type code. Possible values are: INTERNAL or SUPPLIER for banks defined for Oracle Payables, INTERNAL or EXTERNAL for banks defined for Oracle Receivables and PAYROLL for banks defined for Payroll
CUSTOMER_ID NUMBER (15)
Identifier for customer
CUSTOMER_SITE_USE_ID NUMBER (15)
Identifier for customer site use
START_DATE_ACTIVE DATE

Effective from date
END_DATE_ACTIVE DATE

Effective to date
STATUS VARCHAR2 (1)
Indicates whether the record is active or inactive
ORG_ID NUMBER (15)
Identifier for operating unit
MULTI_CURRENCY_FLAG VARCHAR2 (0)
No Longer Used
RECEIPT_MULTI_CURRENCY_FLAG VARCHAR2 (0)
No Longer Used
CONTACT_FIRST_NAME VARCHAR2 (0)
No Longer Used
CONTACT_MIDDLE_NAME VARCHAR2 (0)
No Longer Used
CONTACT_LAST_NAME VARCHAR2 (0)
No Longer Used
CONTACT_PREFIX VARCHAR2 (0)
No Longer Used
CONTACT_TITLE VARCHAR2 (0)
No Longer Used
CONTACT_AREA_CODE VARCHAR2 (0)
No Longer Used
CONTACT_PHONE VARCHAR2 (0)
No Longer Used
BANK VARCHAR2 (360)
Bank Name or Credit Card Issuer Name
HOLDER_NAME VARCHAR2 (80)
Bank Account Name or Credit Card Holder Name
EXPIRATION_STATUS VARCHAR2 (80)
Null (for bank account) Or Credit Card Expiration Status (for Credit Card)
Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      BANK_NAME
,      BANK_ACCOUNT_ID
,      BANK_ACCOUNT_NUM
,      BANK_BRANCH_ID
,      SET_OF_BOOKS_ID
,      CURRENCY_CODE
,      ACCOUNT_TYPE
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      ORG_ID
,      MULTI_CURRENCY_FLAG
,      RECEIPT_MULTI_CURRENCY_FLAG
,      CONTACT_FIRST_NAME
,      CONTACT_MIDDLE_NAME
,      CONTACT_LAST_NAME
,      CONTACT_PREFIX
,      CONTACT_TITLE
,      CONTACT_AREA_CODE
,      CONTACT_PHONE
,      BANK
,      HOLDER_NAME
,      EXPIRATION_STATUS
FROM APPS.OKX_RCPT_METHOD_ACCOUNTS_V;

Dependencies

[top of page]

APPS.OKX_RCPT_METHOD_ACCOUNTS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
SynonymIBY_CREDITCARD
ViewIBY_CREDITCARD_ISSUERS_VL
SynonymIBY_EXTERNAL_PAYERS_ALL
SynonymIBY_EXT_BANK_ACCOUNTS
SynonymIBY_PMT_INSTR_USES_ALL
APPS.OKX_RCPT_METHOD_ACCOUNTS_V is referenced by following:

SchemaAPPS
Package BodyOKL_ARINTF_PVT - show dependent code
Package BodyOKL_BILL_UPFRONT_TAX_PVT - show dependent code
Package BodyOKL_CS_TRANSFER_ASSUMPTION_PVT - show dependent code
Package BodyOKL_DEAL_ASSET_PVT - show dependent code
PL/SQL PackageOKL_DEAL_TERMS_PVT - show dependent code
Package BodyOKL_DEAL_TERMS_PVT - show dependent code
Package BodyOKL_INTERNAL_BILLING_PVT - show dependent code
Package BodyOKL_INTERNAL_TO_EXTERNAL - show dependent code
Package BodyOKL_INVESTOR_BILLING_PVT - show dependent code
Package BodyOKL_K_LINE_FIN_EXT_PVT - show dependent code
Package BodyOKL_OPEN_INTERFACE_PVT - show dependent code
Package BodyOKL_QA_DATA_INTEGRITY - show dependent code
Package BodyOKL_RELEASE_PVT - show dependent code
Package BodyOKL_STREAM_BILLING_PVT - show dependent code
Package BodyOKL_SUBSIDY_PROCESS_PVT - show dependent code