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

VIEW: APPS.PAYBV_JP_BANKS_V

Object Details
Object Name: PAYBV_JP_BANKS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This view is used for Japanese localization only.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BANK_CODE VARCHAR2 (4) Yes Unique code for the bank.
BANK_NAME VARCHAR2 (60) Yes The name of the bank.
BANK_NAME_KANA VARCHAR2 (60) Yes The name of the bank in katakana.
ENABLED_FLAG VARCHAR2 (1) Yes Indicates if the bank is enabled.
START_DATE_ACTIVE DATE

The date when the bank becomes active.
END_DATE_ACTIVE DATE

The date when the bank becomes inactive.
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ENABLED_FLAG_M VARCHAR2 (4000)
Enabled flag
Query Text

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


SELECT BANK_CODE
,      BANK_NAME
,      BANK_NAME_KANA
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ENABLED_FLAG_M
FROM APPS.PAYBV_JP_BANKS_V;

Dependencies

[top of page]

APPS.PAYBV_JP_BANKS_V references the following:

SchemaAPPS
PL/SQL PackageHR_BIS - show dependent code
SynonymPAY_JP_BANKS

APPS.PAYBV_JP_BANKS_V is not referenced by any database object