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: OPI.EDW_OPI_PRDL_M#

Source

View Text - Preformatted


select ALL_ALL_PK ALL_ALL_PK, ALL_ALL_PK_KEY ALL_ALL_PK_KEY, ALL_NAME ALL_NAME, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, PRDL_DESCRIPTION PRDL_DESCRIPTION, PRDL_NAME PRDL_NAME, PRDL_ORGN_CODE PRDL_ORGN_CODE, PRDL_PRDL_DP PRDL_PRDL_DP, PRDL_PRDL_NAME PRDL_PRDL_NAME, PRDL_PRDL_PK PRDL_PRDL_PK, PRDL_PRDL_PK_KEY PRDL_PRDL_PK_KEY, PRDL_PRODUCTION_LINE_CODE PRDL_PRODUCTION_LINE_CODE, PRDL_USER_ATTRIBUTE1 PRDL_USER_ATTRIBUTE1, PRDL_USER_ATTRIBUTE2 PRDL_USER_ATTRIBUTE2, PRDL_USER_ATTRIBUTE3 PRDL_USER_ATTRIBUTE3, PRDL_USER_ATTRIBUTE4 PRDL_USER_ATTRIBUTE4, PRDL_USER_ATTRIBUTE5 PRDL_USER_ATTRIBUTE5 from "OPI"."EDW_OPI_PRDL_M"

View Text - HTML Formatted

SELECT ALL_ALL_PK ALL_ALL_PK
, ALL_ALL_PK_KEY ALL_ALL_PK_KEY
, ALL_NAME ALL_NAME
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, PRDL_DESCRIPTION PRDL_DESCRIPTION
, PRDL_NAME PRDL_NAME
, PRDL_ORGN_CODE PRDL_ORGN_CODE
, PRDL_PRDL_DP PRDL_PRDL_DP
, PRDL_PRDL_NAME PRDL_PRDL_NAME
, PRDL_PRDL_PK PRDL_PRDL_PK
, PRDL_PRDL_PK_KEY PRDL_PRDL_PK_KEY
, PRDL_PRODUCTION_LINE_CODE PRDL_PRODUCTION_LINE_CODE
, PRDL_USER_ATTRIBUTE1 PRDL_USER_ATTRIBUTE1
, PRDL_USER_ATTRIBUTE2 PRDL_USER_ATTRIBUTE2
, PRDL_USER_ATTRIBUTE3 PRDL_USER_ATTRIBUTE3
, PRDL_USER_ATTRIBUTE4 PRDL_USER_ATTRIBUTE4
, PRDL_USER_ATTRIBUTE5 PRDL_USER_ATTRIBUTE5
FROM "OPI"."EDW_OPI_PRDL_M"