[Home] [Help] [Dependency Information]
Object Name: | IBY_VISBLTY_CLASS_DTLS |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_VISBLTY_CLASS_DTLS |
Subobject Name: | |
Status: | VALID |
IBY_VISBLTY_CLASS_DTLS is used to store the combinations of EC app, payee and org id for a visibility class.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VISBLTY_CLASS_DTL_ID | NUMBER | (15) | Yes | System generated primary key |
VISIBILITY_CLASS_ID | NUMBER | (15) | Yes | Foreign key to parent visibility class |
VIS_PAYEEID | VARCHAR2 | (80) | The payee for the visibility detial | |
VIS_ECAPPID | NUMBER | (15) | The EC app for the visibility detial | |
VIS_ORG_ID | NUMBER | (15) | The orgnization for the visibility detial | |
VIS_ALL_PAYEE_FLAG | VARCHAR2 | (1) | Indicating if this visibility class details is for all payees. Value are 'Y', 'N', or null. If 'Y', the VIS_PAYEEID is ignored | |
VIS_ALL_ECAPP_FLAG | VARCHAR2 | (1) | Indicating if this visibility class details is for all EC applications. Value are 'Y', 'N', or null. If 'Y', the VIS_ECAPPID is ignored | |
VIS_ALL_ORG_FLAG | VARCHAR2 | (1) | Indicating if this visibility class details is for all organizations. Value are 'Y', 'N', or null. If 'Y', the VIS_ORG_ID is ignored | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Application level record locking for three tier stateless applications | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT VISBLTY_CLASS_DTL_ID
, VISIBILITY_CLASS_ID
, VIS_PAYEEID
, VIS_ECAPPID
, VIS_ORG_ID
, VIS_ALL_PAYEE_FLAG
, VIS_ALL_ECAPP_FLAG
, VIS_ALL_ORG_FLAG
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM IBY.IBY_VISBLTY_CLASS_DTLS;
IBY.IBY_VISBLTY_CLASS_DTLS does not reference any database object
IBY.IBY_VISBLTY_CLASS_DTLS is referenced by following:
|
|
|