[Home] [Help] [Dependency Information]
Object Name: | IGS_FI_APP_RULES |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_FI_APP_RULES |
Subobject Name: | |
Status: | VALID |
Contains information about each Application Rules associated to an Application Hierarchy that you define. The information captured here are Fee Types and sequence in which these Fee Types would be selected for application purposes.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_FI_APP_RULES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | APPL_RULE_ID |
IGS_FI_APP_RULES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
APPL_HIERARCHY_ID
FEE_TYPE RULE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPL_RULE_ID | NUMBER | (15) | Yes | Sequence generated number - Primary Key for this table |
APPL_HIERARCHY_ID | NUMBER | (15) | Yes | Application Hierarchy identifier |
RULE_SEQUENCE | NUMBER | Yes | Hierarchy sequence - lower the number , higher the hierarchy level | |
FEE_TYPE | VARCHAR2 | (10) | Yes | Fee Type Name |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Default is 'Y', Enable/Disable a fee type from the rule |
RULE_TYPE | VARCHAR2 | (30) | Yes | Denotes whether the Fee Type defined as an Application Hierarchy rule is of type "Allowable" or "Additional Authorized". |
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 | |
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 APPL_RULE_ID
, APPL_HIERARCHY_ID
, RULE_SEQUENCE
, FEE_TYPE
, ENABLED_FLAG
, RULE_TYPE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM IGS.IGS_FI_APP_RULES;
IGS.IGS_FI_APP_RULES does not reference any database object
IGS.IGS_FI_APP_RULES is referenced by following:
|
|
|