[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PSRB.ID ID
, PSRB.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, PSRT.PTY_SOURCE_NAME PTY_SOURCE_NAME
, PSRT.PTY_SOURCE_DESCRIPTION PTY_SOURCE_DESCRIPTION
, PSRB.START_DATE_ACTIVE START_DATE_ACTIVE
, PSRT.SFWT_FLAG SFWT_FLAG
, PSRB.END_DATE_ACTIVE END_DATE_ACTIVE
, PSRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PSRB.CREATED_BY CREATED_BY
, PSRB.CREATION_DATE CREATION_DATE
, PSRB.LAST_UPDATED_BY LAST_UPDATED_BY
, PSRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PSRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PSRB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PSRB.ATTRIBUTE1 ATTRIBUTE1
, PSRB.ATTRIBUTE2 ATTRIBUTE2
, PSRB.ATTRIBUTE3 ATTRIBUTE3
, PSRB.ATTRIBUTE4 ATTRIBUTE4
, PSRB.ATTRIBUTE5 ATTRIBUTE5
, PSRB.ATTRIBUTE6 ATTRIBUTE6
, PSRB.ATTRIBUTE7 ATTRIBUTE7
, PSRB.ATTRIBUTE8 ATTRIBUTE8
, PSRB.ATTRIBUTE9 ATTRIBUTE9
, PSRB.ATTRIBUTE10 ATTRIBUTE10
, PSRB.ATTRIBUTE11 ATTRIBUTE11
, PSRB.ATTRIBUTE12 ATTRIBUTE12
, PSRB.ATTRIBUTE13 ATTRIBUTE13
, PSRB.ATTRIBUTE14 ATTRIBUTE14
, PSRB.ATTRIBUTE15 ATTRIBUTE15
FROM OKR_PARTY_SOURCES_B PSRB
, OKR_PARTY_SOURCES_TL PSRT
WHERE PSRB.ID = PSRT.ID
AND PSRT.LANGUAGE = USERENV('LANG')