[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IBY_PAYEE# |
|---|---|
| Object Type: | VIEW |
| Owner: | IBY |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| MPAYEEID | NUMBER | (15) | Yes | |
| PAYEEID | VARCHAR2 | (80) | Yes | |
| NAME | VARCHAR2 | (80) | Yes | |
| ECAPPID | NUMBER | (15) | Yes | |
| USERNAME | VARCHAR2 | (80) | ||
| PASSWORD | VARCHAR2 | (80) | ||
| ACTIVESTATUS | VARCHAR2 | (1) | Yes | |
| THRESHOLD | NUMBER | (15) | ||
| RISK_ENABLED | VARCHAR2 | (1) | ||
| SUPPORTEDOP | NUMBER | |||
| LAST_UPDATE_DATE | DATE | Yes | ||
| OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| SECURITY_GROUP_ID | NUMBER | |||
| MCC_CODE | NUMBER | (10) | ||
| EMAIL_ADDRESS | VARCHAR2 | (2000) | ||
| FINANCING_PAYEE_FLAG | VARCHAR2 | (1) | ||
| MASTER_KEY | VARCHAR2 | (24) | ||
| SECURITY_ENABLED | VARCHAR2 | (1) | ||
| DBA_NAME | VARCHAR2 | (80) | ||
| DBA_CITY | VARCHAR2 | (80) | ||
| DBA_STATE_PROVINCE | VARCHAR2 | (80) | ||
| DBA_COUNTRY | VARCHAR2 | (80) | ||
| INACTIVE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT MPAYEEID
, PAYEEID
, NAME
, ECAPPID
, USERNAME
, PASSWORD
, ACTIVESTATUS
, THRESHOLD
, RISK_ENABLED
, SUPPORTEDOP
, LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, MCC_CODE
, EMAIL_ADDRESS
, FINANCING_PAYEE_FLAG
, MASTER_KEY
, SECURITY_ENABLED
, DBA_NAME
, DBA_CITY
, DBA_STATE_PROVINCE
, DBA_COUNTRY
, INACTIVE_DATE
FROM IBY.IBY_PAYEE#;
IBY
IBY_PAYEE
APPS
IBY_PAYEE
|
|
|
|