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: EDW_PMI_PRTG_PRTG_LCV

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT 'ALL' ALL_FK
, R.ROUTING_NO || '-' || R.ROUTING_VERS || '-' || I.INSTANCE_CODE ||'-'||'OPM' ROUTING_PK
, R.ROUTING_NO ROUTING_NUMBER
, R.ROUTING_VERS VERSION
, R.ROUTING_DESC DESCRIPTION
, R.ROUTING_CLASS ROUTING_CLASS
, R.ROUTING_NO || ':' || R.ROUTING_VERS ROUTING_DP
, R.ROUTING_NO || ':' || R.ROUTING_VERS NAME
, I.INSTANCE_CODE INSTANCE_CODE
, R.LAST_UPDATE_DATE
, R.CREATION_DATE
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM FM_ROUT_HDR R
, EDW_LOCAL_INSTANCE I

Columns

Name
ALL_FK
ROUTING_PK
ROUTING_NUMBER
VERSION
DESCRIPTION
ROUTING_CLASS
ROUTING_DP
NAME
INSTANCE_CODE
LAST_UPDATE_DATE
CREATION_DATE
USER_ATTRIBUTE1
USER_ATTRIBUTE2
USER_ATTRIBUTE3
USER_ATTRIBUTE4
USER_ATTRIBUTE5