eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: PA.PA_RBS_MAPPING_RULES#

Source

View Text - Preformatted


select ELEMENT_VERSION_ID ELEMENT_VERSION_ID, RULE_ID RULE_ID, LEVEL1 LEVEL1, LEVEL2 LEVEL2, LEVEL3 LEVEL3, LEVEL4 LEVEL4, LEVEL5 LEVEL5, LEVEL6 LEVEL6, LEVEL7 LEVEL7, LEVEL8 LEVEL8, LEVEL9 LEVEL9, LEVEL10 LEVEL10, LEVEL11 LEVEL11, LEVEL12 LEVEL12, LEVEL13 LEVEL13, LEVEL14 LEVEL14, LEVEL15 LEVEL15, PERSON_RC_PRECEDENCE PERSON_RC_PRECEDENCE, EQUIPMENT_RC_PRECEDENCE EQUIPMENT_RC_PRECEDENCE, MATERIAL_RC_PRECEDENCE MATERIAL_RC_PRECEDENCE, FIN_ELEM_RC_PRECEDENCE FIN_ELEM_RC_PRECEDENCE, MAX_LEVEL MAX_LEVEL, RULE_FLAG RULE_FLAG, RBS_ELEMENT_ID RBS_ELEMENT_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE from "PA"."PA_RBS_MAPPING_RULES"

View Text - HTML Formatted

SELECT ELEMENT_VERSION_ID ELEMENT_VERSION_ID
, RULE_ID RULE_ID
, LEVEL1 LEVEL1
, LEVEL2 LEVEL2
, LEVEL3 LEVEL3
, LEVEL4 LEVEL4
, LEVEL5 LEVEL5
, LEVEL6 LEVEL6
, LEVEL7 LEVEL7
, LEVEL8 LEVEL8
, LEVEL9 LEVEL9
, LEVEL10 LEVEL10
, LEVEL11 LEVEL11
, LEVEL12 LEVEL12
, LEVEL13 LEVEL13
, LEVEL14 LEVEL14
, LEVEL15 LEVEL15
, PERSON_RC_PRECEDENCE PERSON_RC_PRECEDENCE
, EQUIPMENT_RC_PRECEDENCE EQUIPMENT_RC_PRECEDENCE
, MATERIAL_RC_PRECEDENCE MATERIAL_RC_PRECEDENCE
, FIN_ELEM_RC_PRECEDENCE FIN_ELEM_RC_PRECEDENCE
, MAX_LEVEL MAX_LEVEL
, RULE_FLAG RULE_FLAG
, RBS_ELEMENT_ID RBS_ELEMENT_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM "PA"."PA_RBS_MAPPING_RULES"