[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | View for OKR_IP_TGT_PRODUCTS_B and OKR_TGT_PRODUCTS_TL |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ITPB.ROWID
, ITPB.ID ID
, ITPB.IP_ID IP_ID
, IPCT.NAME IP_NAME
, ITPB.TGT_PRODUCT_CODE TGT_PRODUCT_CODE
, QSL.MEANING TGT_PRODUCT_NAME
, ITPT.DESCRIPTION DESCRIPTION
, ITPB.START_DATE_ACTIVE START_DATE_ACTIVE
, ITPB.END_DATE_ACTIVE END_DATE_ACTIVE
, ITPT.SFWT_FLAG SFWT_FLAG
, ITPB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ITPB.CREATED_BY CREATED_BY
, ITPB.CREATION_DATE CREATION_DATE
, ITPB.LAST_UPDATED_BY LAST_UPDATED_BY
, ITPB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ITPB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ITPB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ITPB.ATTRIBUTE1 ATTRIBUTE1
, ITPB.ATTRIBUTE2 ATTRIBUTE2
, ITPB.ATTRIBUTE3 ATTRIBUTE3
, ITPB.ATTRIBUTE4 ATTRIBUTE4
, ITPB.ATTRIBUTE5 ATTRIBUTE5
, ITPB.ATTRIBUTE6 ATTRIBUTE6
, ITPB.ATTRIBUTE7 ATTRIBUTE7
, ITPB.ATTRIBUTE8 ATTRIBUTE8
, ITPB.ATTRIBUTE9 ATTRIBUTE9
, ITPB.ATTRIBUTE10 ATTRIBUTE10
, ITPB.ATTRIBUTE11 ATTRIBUTE11
, ITPB.ATTRIBUTE12 ATTRIBUTE12
, ITPB.ATTRIBUTE13 ATTRIBUTE13
, ITPB.ATTRIBUTE14 ATTRIBUTE14
, ITPB.ATTRIBUTE15 ATTRIBUTE15
FROM FND_LOOKUPS QSL
, OKR_IP_COMMON_TL IPCT
, OKR_IP_TGT_PRODUCTS_TL ITPT
, OKR_IP_TGT_PRODUCTS_B ITPB
WHERE ITPB.ID = ITPT.ID
AND ITPT.LANGUAGE = USERENV('LANG')
AND ITPB.IP_ID = IPCT.IP_ID
AND IPCT.LANGUAGE = USERENV('LANG')
AND QSL.LOOKUP_TYPE = 'OKR_TARGETED_PRODUCT'
AND QSL.LOOKUP_CODE = ITPB.TGT_PRODUCT_CODE