Product: | OKR - Contracts for Rights (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT TXUD.ID ID
, TXUD.IP_RGTS_TXN_ID IP_RGTS_TXN_ID
, TXUD.DNZ_IP_ID DNZ_IP_ID
, TXUD.DNZ_RGTP_ID DNZ_RGTP_ID
, TXUD.DNZ_IP_RIGHTS_ID DNZ_IP_RIGHTS_ID
, TXUD.IP_DIM_VAL_ID IP_DIM_VAL_ID
, DIVAB.DIMENSION_CODE DIMENSION_CODE
, DIMT.DIMENSION_NAME DIMENSION_NAME
, DIMT.DIMENSION_DESCRIPTION DIMENSION_DESCRIPTION
, DIVAT.DIMENSION_VALUE DIMENSION_VALUE
, TXUD.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TXUD.CREATED_BY CREATED_BY
, TXUD.CREATION_DATE CREATION_DATE
, TXUD.LAST_UPDATED_BY LAST_UPDATED_BY
, TXUD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TXUD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TXUD.START_DATE_ACTIVE START_DATE_ACTIVE
, TXUD.END_DATE_ACTIVE END_DATE_ACTIVE
FROM OKR_IP_RGTS_TXN_UDDIM TXUD
, OKR_IP_UDEF_DIM_B DIMB
, OKR_IP_UDEF_DIM_TL DIMT
, OKR_IP_UDEF_DIM_VAL_B DIVAB
, OKR_IP_UDEF_DIM_VAL_TL DIVAT
WHERE TXUD.IP_DIM_VAL_ID = DIVAB.ID
AND DIVAB.ID = DIVAT.ID
AND DIVAB.DIMENSION_CODE = DIMB.DIMENSION_CODE
AND DIMB.ID = DIMT.ID
AND DIVAT.LANGUAGE = USERENV('LANG')
AND DIMT.LANGUAGE = USERENV('LANG')