[Home] [Help] [Dependency Information]
Object Name: | PQH_TXN_CATEGORY_ATTRIBUTES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PQH.PQH_TXN_CATEGORY_ATTRIBUTES |
Subobject Name: | |
Status: | VALID |
Intersection entity between transaction category and table attributes
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PQH_TXN_CATEGORY_ATTRIBUTES_PK | NORMAL | UNIQUE | APPS_TS_SEED |
TXN_CATEGORY_ATTRIBUTE_ID
ZD_EDITION_NAME |
PQH_TXN_CATEGORY_ATTRIBUTES_FK | NORMAL | NONUNIQUE | APPS_TS_SEED | TRANSACTION_TABLE_ROUTE_ID |
PQH_TXN_CATEGORY_ATTRIBUTES_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | IDENTIFIER_FLAG |
PQH_TXN_CATEGORY_ATTRIBUTE_FK1 | NORMAL | NONUNIQUE | APPS_TS_SEED | ATTRIBUTE_ID |
PQH_TXN_CATEGORY_ATTRIBUTE_FK2 | NORMAL | NONUNIQUE | APPS_TS_SEED | TRANSACTION_CATEGORY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TXN_CATEGORY_ATTRIBUTE_ID | NUMBER | (15) | Yes | Primary Key |
ATTRIBUTE_ID | NUMBER | (15) | Yes | Attribute Identifier |
TRANSACTION_CATEGORY_ID | NUMBER | (15) | Yes | Transaction Category identifier |
TRANSACTION_TABLE_ROUTE_ID | NUMBER | (15) | Table identifier | |
SELECT_FLAG | VARCHAR2 | (30) | Selected or not (Yes / no) | |
FORM_COLUMN_NAME | VARCHAR2 | (30) | Field on which the security is applied | |
IDENTIFIER_FLAG | VARCHAR2 | (10) | Attribute can be used to identify List and / or Member | |
LIST_IDENTIFYING_FLAG | VARCHAR2 | (10) | Attribute can be used to identify Routing List | |
MEMBER_IDENTIFYING_FLAG | VARCHAR2 | (10) | Attribute can be used to identify Routing List member. | |
REFRESH_FLAG | VARCHAR2 | (30) | Attribute is to be refreshed or not | |
VALUE_STYLE_CD | VARCHAR2 | (30) | Yes | Value for the Attribute in Attribute is Range / extact |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object version Number |
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
VALUE_SET_ID | NUMBER | (15) | Value Set identifier | |
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
TAB_PAGE_NAME | VARCHAR2 | (30) | Form Tab Page Name for Tab Security | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT TXN_CATEGORY_ATTRIBUTE_ID
, ATTRIBUTE_ID
, TRANSACTION_CATEGORY_ID
, TRANSACTION_TABLE_ROUTE_ID
, SELECT_FLAG
, FORM_COLUMN_NAME
, IDENTIFIER_FLAG
, LIST_IDENTIFYING_FLAG
, MEMBER_IDENTIFYING_FLAG
, REFRESH_FLAG
, VALUE_STYLE_CD
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, VALUE_SET_ID
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, TAB_PAGE_NAME
, ZD_EDITION_NAME
FROM HR.PQH_TXN_CATEGORY_ATTRIBUTES;
HR.PQH_TXN_CATEGORY_ATTRIBUTES does not reference any database object
HR.PQH_TXN_CATEGORY_ATTRIBUTES is referenced by following:
|
|
|