[Home] [Help] [Dependency Information]
Object Name: | HXC_APPROVAL_COMPS |
---|---|
Object Type: | TABLE |
Owner: | HXC |
FND Design Data: | HXC.HXC_APPROVAL_COMPS |
Subobject Name: | |
Status: | VALID |
HXC_APPROVAL_COMPONENTS holds the individual components of an Approval Style. These components determine whether or not approval or re-approval is required, based on the Approval
Style associated with modified Time information.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HXC_APPROVAL_COMPS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | APPROVAL_COMP_ID |
HXC_APPROVAL_COMPS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | APPROVAL_STYLE_ID |
HXC_APPROVAL_COMPS_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TIME_RECIPIENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPROVAL_COMP_ID | NUMBER | (15) | Yes | Primary Key from sequence |
APPROVAL_STYLE_ID | NUMBER | (15) | Yes | Foreign Key to HXC_APPROVAL_STYLES |
TIME_RECIPIENT_ID | NUMBER | (15) | Yes | Foreign Key to HXC_TIME_RECIPIENTS. |
APPROVAL_MECHANISM | VARCHAR2 | (30) | Yes | Indicates the mehanism used for approval. |
APPROVAL_MECHANISM_ID | NUMBER | (15) | An implicit Foreign Key which may be required to complete the definition of the Approval Mechanism. | |
WF_ITEM_TYPE | VARCHAR2 | (8) | The type of the Workflow associated with the Apporval Component. | |
WF_NAME | VARCHAR2 | (30) | The name of the Workflow associated with the Approval Component. | |
START_DATE | DATE | Yes | The start date of the Approval Component. | |
END_DATE | DATE | Yes | The end date of the Approval Component. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Object Version Number | |
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. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | 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). | |
APPROVAL_ORDER | NUMBER | (15) | Indicates the sequencing of the Approval Compnent within the Approval Style. | |
TIME_CATEGORY_ID | NUMBER | (15) | Time category Id for which the approval style is defined | |
PARENT_COMP_ID | NUMBER | (15) | Parent Approval Component Id | |
PARENT_COMP_OVN | NUMBER | (9) | Parent Component Object version number | |
RUN_RECIPIENT_EXTENSIONS | VARCHAR2 | (1) | Run Recipient Extensions |
Cut, paste (and edit) the following text to query this object:
SELECT APPROVAL_COMP_ID
, APPROVAL_STYLE_ID
, TIME_RECIPIENT_ID
, APPROVAL_MECHANISM
, APPROVAL_MECHANISM_ID
, WF_ITEM_TYPE
, WF_NAME
, START_DATE
, END_DATE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, APPROVAL_ORDER
, TIME_CATEGORY_ID
, PARENT_COMP_ID
, PARENT_COMP_OVN
, RUN_RECIPIENT_EXTENSIONS
FROM HXC.HXC_APPROVAL_COMPS;
HXC.HXC_APPROVAL_COMPS does not reference any database object
HXC.HXC_APPROVAL_COMPS is referenced by following:
|
|
|