[Home] [Help] [Dependency Information]
Object Name: | BEN_EXT_WHERE_CLAUSE |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_EXT_WHERE_CLAUSE |
Subobject Name: | |
Status: | VALID |
BEN_EXT_WHERE_CLAUSE contains the specifics of the advanced condition selection criteria defined for selecting a data element to be extracted for an extract record or an extract record in an extract file. The where clause identifies the sequence number of execution of the selection criteria,the operation code, whether the criteria should be applied in addition to or instead of other criteria and a value. This table is also used for constructing criteria for totalling when defining data elements.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_EXT_WHERE_CLAUSE_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
EXT_WHERE_CLAUSE_ID
ZD_EDITION_NAME |
BEN_EXT_WHERE_CLAUSE_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXT_DATA_ELMT_ID |
BEN_EXT_WHERE_CLAUSE_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COND_EXT_DATA_ELMT_ID |
BEN_EXT_WHERE_CLAUSE_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXT_DATA_ELMT_IN_RCD_ID |
BEN_EXT_WHERE_CLAUSE_FK4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXT_RCD_IN_FILE_ID |
BEN_EXT_WHERE_CLAUSE_FK5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXT_WHERE_CLAUSE_ID | NUMBER | (15) | Yes | System generated primary key column. |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign Key to HR_ORGANIZATION_UNITS | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | 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). | |
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated primary key. Increments by one each update. | |
SEQ_NUM | NUMBER | (15) | Sequence number. | |
OPER_CD | VARCHAR2 | (30) | Operation code. | |
VAL | VARCHAR2 | (300) | Value. | |
AND_OR_CD | VARCHAR2 | (30) | And or Or. | |
EXT_DATA_ELMT_ID | NUMBER | (15) | Foreign key to BEN_EXT_DATA_ELMT. | |
COND_EXT_DATA_ELMT_ID | NUMBER | (15) | Foreign key to BEN_COND_EXT_DATA_ELMT_F. | |
EXT_RCD_IN_FILE_ID | NUMBER | (15) | Foreign key to BEN_EXT_RCD_IN_FILE. | |
EXT_DATA_ELMT_IN_RCD_ID | NUMBER | (15) | Foreign key to BEN_EXT_DATA_ELMT_IN_RCD. | |
COND_EXT_DATA_ELMT_IN_RCD_ID | NUMBER | (15) | Foreign key to BEN_COND_EXT_DATA_ELMT_IN_RCD_F. | |
LEGISLATION_CODE | VARCHAR2 | (30) | Legislation Code. | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT EXT_WHERE_CLAUSE_ID
, BUSINESS_GROUP_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, SEQ_NUM
, OPER_CD
, VAL
, AND_OR_CD
, EXT_DATA_ELMT_ID
, COND_EXT_DATA_ELMT_ID
, EXT_RCD_IN_FILE_ID
, EXT_DATA_ELMT_IN_RCD_ID
, COND_EXT_DATA_ELMT_IN_RCD_ID
, LEGISLATION_CODE
, ZD_EDITION_NAME
FROM BEN.BEN_EXT_WHERE_CLAUSE;
BEN.BEN_EXT_WHERE_CLAUSE does not reference any database object
BEN.BEN_EXT_WHERE_CLAUSE is referenced by following:
|
|
|