[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IBY_F_LENDERS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IBY.IBY_F_LENDERS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BEPID | NUMBER | (15) | Yes | Back End Payment System identifier |
| BEPINFO_OVN | NUMBER | Yes | This column is used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. The situation occurs when the HTML application is an 'stateless' application. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated 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_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| SYSTEM_NAME | VARCHAR2 | (80) | Yes | Name of the Back End Payment System like Cybercash, Verifone etc |
| BASEURL | VARCHAR2 | (1024) | URL to the Back End Payment System | |
| SUFFIX | VARCHAR2 | (10) | Yes | Three-letter Back End Payment System suffix. This is unique per Back End Payment System |
| BEPUSERNAME | VARCHAR2 | (80) | Username for authenticating from iPayment to Back End Payment System. | |
| BEPPASSWORD | VARCHAR2 | (80) | password for BEPUSERNAME. | |
| SUPPORTEDOP | NUMBER | bitmap to denote operations supported by Back End Payment System | ||
| ADMINURL | VARCHAR2 | (1024) | URL to the native Back End Payment System admin pages | |
| LOGINURL | VARCHAR2 | (1024) | loginurl to the Back End Payment System | |
| ACTIVESTATUS | VARCHAR2 | (1) | Indicates whether Back End Payment System is active or not | |
| BEP_TYPE | VARCHAR2 | (10) | ||
| DEFAULT_BEP_FLAG | VARCHAR2 | (1) | ||
| BEPLANG | VARCHAR2 | (80) | language supported by the Back End Payment System | |
| PREFERRED_FLAG | NUMBER | denotes whether this is the preferred language of the Back End Payment System | ||
| PARTY_ID | NUMBER | (15) | ||
| LENDER_NAME | VARCHAR2 | (360) | Name of this party | |
| LOCATION_ID | NUMBER | (15) | Yes | |
| ADDRESS1 | VARCHAR2 | (240) | Yes | First line of the Identifying address |
| ADDRESS2 | VARCHAR2 | (724) | Second line of the Identifying address | |
| CITY | VARCHAR2 | (60) | City of the Identifying address | |
| POSTAL_CODE | VARCHAR2 | (60) | Postal Code of the Identifying address | |
| STATE | VARCHAR2 | (60) | State of the Identifying address | |
| PROVINCE | VARCHAR2 | (60) | Province of the Identifying address | |
| COUNTRY | VARCHAR2 | (60) | Yes | County of the Identifying address |
| LOCATION_OVN | NUMBER | |||
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
| PARTY_OVN | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT BEPID
, BEPINFO_OVN
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SYSTEM_NAME
, BASEURL
, SUFFIX
, BEPUSERNAME
, BEPPASSWORD
, SUPPORTEDOP
, ADMINURL
, LOGINURL
, ACTIVESTATUS
, BEP_TYPE
, DEFAULT_BEP_FLAG
, BEPLANG
, PREFERRED_FLAG
, PARTY_ID
, LENDER_NAME
, LOCATION_ID
, ADDRESS1
, ADDRESS2
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTRY
, LOCATION_OVN
, SECURITY_GROUP_ID
, PARTY_OVN
FROM APPS.IBY_F_LENDERS_V;
APPS
HZ_LOCATIONS
HZ_PARTIES
HZ_PARTY_SITES
HZ_PARTY_SITE_USES
IBY_BEPINFO
IBY_BEPLANGS
IBY_DEFAULT_BEP
APPS.IBY_F_LENDERS_V is not referenced by any database object
|
|
|
|