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

Product:	OKX - Contracts Integration
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT B.IP_ID ID1
, '#' ID2
, B.IP_IDENTIFIER NAME
, T.NAME DESCRIPTION
, 'A' STATUS
, B.START_DATE_ACTIVE START_DATE_ACTIVE
, B.END_DATE_ACTIVE END_DATE_ACTIVE
, B.IP_ID IP_ID
, B.IP_TYPE IP_TYPE
, B.IP_IDENTIFIER IP_IDENTIFIER
, T.NAME IP_NAME
, T.SUBJECT IP_SUBJECT
, T.DESCRIPTION IP_DESCRIPTION
FROM OKR_IP_COMMON_TL T
, OKR_IP_COMMON_B B
WHERE B.IP_ID = T.IP_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ID1
ID2
NAME
DESCRIPTION
STATUS
START_DATE_ACTIVE
END_DATE_ACTIVE
IP_ID
IP_TYPE
IP_IDENTIFIER
IP_NAME
IP_SUBJECT
IP_DESCRIPTION