[Home] [Help] [Dependency Information]
Object Name: | IA_RULE_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | IA |
FND Design Data: | IA.IA_RULE_DETAILS |
Subobject Name: | |
Status: | VALID |
IA_RULE_DETAILS stores detailed information about rules that will govern the self-service asset transfer process.
Oracle iAssets inserts a row in this table for each book in which you define rules. For example, if you define a rule for three different books, Oracle iAssets inserts three rows in this table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IA_RULE_DETAILS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
RULE_ID
BOOK_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ID | NUMBER | (15) | Yes | Unique identification number for a rule |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book name with which rule is associated |
ENABLE_TRANSFER_FLAG | VARCHAR2 | (1) | Yes | Indicates whether or not creating a transfer request is allowed |
ALLOW_TRANSACTION_DATE_FLAG | VARCHAR2 | (1) | Yes | Indicates whether or not the transaction date is enterable |
RESPONSIBILITY_TYPE | VARCHAR2 | (15) | Indicates the type of responsibility. Valid code are: REQUEST_ONLY (create transfer request) or REQUEST_APPROVE (create and approve transfer request) | |
REQUIRE_SUPERUSER_FLAG | VARCHAR2 | (1) | Indicates whether or not super user approval is required | |
APPROVAL_TYPE | VARCHAR2 | (30) | Indicates the type of approval. Valid codes are: ALL (both releasing and receiving approval is required), RELEASE (releasing approval is required), RECEIVE (receiving approval is required), NONE (no approval is required) | |
APPROVAL_METHOD | VARCHAR2 | (30) | Indicates method type of approval. Valid codes are: COST_CENTER (cost center based approval) HIERARCHY (Management hierarchy based approval) | |
ALLOW_SEARCH_ALL_FLAG | VARCHAR2 | (1) | Indicates whether or not the search is allowed for your own requests or all requests | |
ALLOW_CUSTOM_TEXT_FLAG | VARCHAR2 | (1) | Indicates whether or not to enable custom text input | |
CUSTOM_TEXT | VARCHAR2 | (1996) | Custom text which will appear in the first step of the transfer process | |
SECURE_BY_COST_CTR_FLAG | VARCHAR2 | (1) | Indicates whether or not the user can transact within his/her own cost center | |
SEGMENT1 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during the transfer process | |
SEGMENT2 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT3 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT4 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT5 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT6 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT7 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT8 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT9 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT10 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT11 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT12 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT13 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT14 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT15 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT16 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT17 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT18 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT19 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT20 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT21 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT22 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT23 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT24 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT25 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT26 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT27 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT28 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT29 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
SEGMENT30 | VARCHAR2 | (30) | Indicates whether or not this accounting segment is selected for display and update during transfer process | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_ID
, BOOK_TYPE_CODE
, ENABLE_TRANSFER_FLAG
, ALLOW_TRANSACTION_DATE_FLAG
, RESPONSIBILITY_TYPE
, REQUIRE_SUPERUSER_FLAG
, APPROVAL_TYPE
, APPROVAL_METHOD
, ALLOW_SEARCH_ALL_FLAG
, ALLOW_CUSTOM_TEXT_FLAG
, CUSTOM_TEXT
, SECURE_BY_COST_CTR_FLAG
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM IA.IA_RULE_DETAILS;
IA.IA_RULE_DETAILS does not reference any database object
IA.IA_RULE_DETAILS is referenced by following:
|
|
|