[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
, IPYT.NAME IP_NAME
, IIRB.ITEM_ID1 ITEM_ID1
, IIRB.ITEM_ID2 ITEM_ID2
, SITV.NAME ITEM_NAME
, IIRB.CHR_ID CHR_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, IIRB.RGT_CLE_ID RGT_CLE_ID
, IIRB.RGT_TXN_ID RGT_TXN_ID
, CLEB.START_DATE_ACTIVE RGT_START_DATE
, CLET.NAME RGT_NAME
, CLEB.END_DATE_ACTIVE RGT_END_DATE
, IIRT.DESCRIPTION DESCRIPTION
, IIRT.NOTE NOTE
, IIRB.PLAN_SPLIT_PERCENTAGE PLAN_SPLIT_PERCENTAGE
, 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_COMMON_TL IPYT
, OKR_IP_ITEM_RELS_B IIRB
, OKR_IP_ITEM_RELS_TL IIRT
, OKX_SYSTEM_ITEMS_V SITV
, OKC_K_HEADERS_B CHRB
, OKR_IP_RGTS_TXN_B CLEB
, OKR_IP_RGTS_TXN_TL CLET
WHERE IIRB.IIR_ID = IIRT.IIR_ID
AND IIRT.LANGUAGE = USERENV('LANG')
AND IPYT.IP_ID = IIRB.IP_ID
AND IPYT.LANGUAGE = USERENV('LANG')
AND IIRB.CHR_ID = CHRB.ID
AND CLEB.ID = IIRB.RGT_TXN_ID
AND CLET.ID = CLEB.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND SITV.ID1 = IIRB.ITEM_ID1
AND SITV.ID2 = IIRB.ITEM_ID2