[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 |