[Home] [Help] [Dependency Information]
Object Name: | EDR_RULE_DETAIL_TEMP |
---|---|
Object Type: | TABLE |
Owner: | EDR |
FND Design Data: | EDR.EDR_RULE_DETAIL_TEMP |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | Yes | current sql session id | |
TRANSACTION_TYPE_ID | VARCHAR2 | (100) | Yes | current transaction type id |
RULE_ID | NUMBER | Yes | current rule id for a rule under the transaction | |
RULE_NAME | VARCHAR2 | (100) | rule name for rule id | |
RULE_TYPE | VARCHAR2 | (100) | rule type for rule id | |
APPR_TYPE | VARCHAR2 | (100) | rule approval type | |
APPR_DESC | VARCHAR2 | (100) | rule approval description | |
DEFAULT_VAR | VARCHAR2 | (1) | whether this rule use default value of the transaction variable | |
START_DATE | DATE | Yes | rule effective start date | |
END_DATE | DATE | rule effective end date |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, TRANSACTION_TYPE_ID
, RULE_ID
, RULE_NAME
, RULE_TYPE
, APPR_TYPE
, APPR_DESC
, DEFAULT_VAR
, START_DATE
, END_DATE
FROM EDR.EDR_RULE_DETAIL_TEMP;
EDR.EDR_RULE_DETAIL_TEMP does not reference any database object
EDR.EDR_RULE_DETAIL_TEMP is referenced by following:
|
|
|