[Home] [Help] [Dependency Information]
Object Name: | PA_RBS_MAPPING_RULES# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ELEMENT_VERSION_ID | NUMBER | (15) | Yes | |
RULE_ID | NUMBER | (15) | Yes | |
LEVEL1 | VARCHAR2 | (30) | ||
LEVEL2 | VARCHAR2 | (30) | ||
LEVEL3 | VARCHAR2 | (30) | ||
LEVEL4 | VARCHAR2 | (30) | ||
LEVEL5 | VARCHAR2 | (30) | ||
LEVEL6 | VARCHAR2 | (30) | ||
LEVEL7 | VARCHAR2 | (30) | ||
LEVEL8 | VARCHAR2 | (30) | ||
LEVEL9 | VARCHAR2 | (30) | ||
LEVEL10 | VARCHAR2 | (30) | ||
LEVEL11 | VARCHAR2 | (30) | ||
LEVEL12 | VARCHAR2 | (30) | ||
LEVEL13 | VARCHAR2 | (30) | ||
LEVEL14 | VARCHAR2 | (30) | ||
LEVEL15 | VARCHAR2 | (30) | ||
PERSON_RC_PRECEDENCE | NUMBER | (15) | ||
EQUIPMENT_RC_PRECEDENCE | NUMBER | (15) | ||
MATERIAL_RC_PRECEDENCE | NUMBER | (15) | ||
FIN_ELEM_RC_PRECEDENCE | NUMBER | (15) | ||
MAX_LEVEL | NUMBER | (15) | Yes | |
RULE_FLAG | VARCHAR2 | (1) | ||
RBS_ELEMENT_ID | NUMBER | (15) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ELEMENT_VERSION_ID
, RULE_ID
, LEVEL1
, LEVEL2
, LEVEL3
, LEVEL4
, LEVEL5
, LEVEL6
, LEVEL7
, LEVEL8
, LEVEL9
, LEVEL10
, LEVEL11
, LEVEL12
, LEVEL13
, LEVEL14
, LEVEL15
, PERSON_RC_PRECEDENCE
, EQUIPMENT_RC_PRECEDENCE
, MATERIAL_RC_PRECEDENCE
, FIN_ELEM_RC_PRECEDENCE
, MAX_LEVEL
, RULE_FLAG
, RBS_ELEMENT_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM PA.PA_RBS_MAPPING_RULES#;
|
|
|