[Home] [Help] [Dependency Information]
Object Name: | PAY_JP_SS_BANK_BRANCH_LOV_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_JP_SS_BANK_BRANCH_LOV_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
View for Japanese Bank Branch LOV in payments self-service V3.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BANK_CODE | VARCHAR2 | (4) | Yes | Bank code for the bank this branch belongs to. |
BRANCH_CODE | VARCHAR2 | (3) | Yes | Three digit branch code string. |
BRANCH_NAME | VARCHAR2 | (60) | Yes | The branch name. |
BRANCH_NAME_KANA | VARCHAR2 | (90) | Yes | The kana branch name. |
START_DATE_ACTIVE | DATE | The date from which this branch record is active. | ||
END_DATE_ACTIVE | DATE | The last date upon which this branch record is active. |
Cut, paste (and edit) the following text to query this object:
SELECT BANK_CODE
, BRANCH_CODE
, BRANCH_NAME
, BRANCH_NAME_KANA
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM APPS.PAY_JP_SS_BANK_BRANCH_LOV_V;
APPS.PAY_JP_SS_BANK_BRANCH_LOV_V is not referenced by any database object
|
|
|