[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | View for table OKR_IP_ITEM_RELS_B |
| Implementation/DBA Data: | Not implemented in this database |
SELECT IIRB.IIR_ID IIR_ID
, IIRB.IP_ID IP_ID
, IIRB.ITEM_ID1 ITEM_ID1
, IIRB.ITEM_ID2 ITEM_ID2
, IIRB.CHR_ID CHR_ID
, IIRB.RGT_CLE_ID RGT_CLE_ID
, IIRT.DESCRIPTION DESCRIPTION
, IIRT.NOTE NOTE
, IIRB.PLAN_SPLIT_PERCENTAGE PLAN_SPLIT_PERCENTAGE
, IIRB.RGT_TXN_ID RGT_TXN_ID
, IIRB.START_DATE START_DATE
, IIRB.END_DATE END_DATE
, IIRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IIRB.CREATED_BY CREATED_BY
, IIRB.CREATION_DATE CREATION_DATE
, IIRB.LAST_UPDATED_BY LAST_UPDATED_BY
, IIRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IIRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IIRB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, IIRB.ATTRIBUTE1 ATTRIBUTE1
, IIRB.ATTRIBUTE2 ATTRIBUTE2
, IIRB.ATTRIBUTE3 ATTRIBUTE3
, IIRB.ATTRIBUTE4 ATTRIBUTE4
, IIRB.ATTRIBUTE5 ATTRIBUTE5
, IIRB.ATTRIBUTE6 ATTRIBUTE6
, IIRB.ATTRIBUTE7 ATTRIBUTE7
, IIRB.ATTRIBUTE8 ATTRIBUTE8
, IIRB.ATTRIBUTE9 ATTRIBUTE9
, IIRB.ATTRIBUTE10 ATTRIBUTE10
, IIRB.ATTRIBUTE11 ATTRIBUTE11
, IIRB.ATTRIBUTE12 ATTRIBUTE12
, IIRB.ATTRIBUTE13 ATTRIBUTE13
, IIRB.ATTRIBUTE14 ATTRIBUTE14
, IIRB.ATTRIBUTE15 ATTRIBUTE15
FROM OKR_IP_ITEM_RELS_B IIRB
, OKR_IP_ITEM_RELS_TL IIRT
WHERE IIRB.IIR_ID = IIRT.IIR_ID
AND IIRT.LANGUAGE = USERENV('LANG')