[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | Complex View for OKR_PROP_QSTNS_B and OKR_PROP_QSTNS_TL |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PQNB.ROWID
, PQNB.ID ID
, PQNT.NAME NAME
, PQNT.DESCRIPTION DESCRIPTION
, PQNB.IP_TYPE IP_TYPE
, PTYT.IP_TYPE_MEANING IP_TYPE_MEANING
, PQNB.QUERY_TYPE_CODE QUERY_TYPE_CODE
, QSL.MEANING QUERY_TYPE_MEANING
, PQNB.RESP_SET_ID RESP_SET_ID
, RPST.NAME RESP_SET_NAME
, PQNB.DETAIL_REQ_YN DETAIL_REQ_YN
, PQNB.RESP_REQ_YN RESP_REQ_YN
, PQNB.START_DATE_ACTIVE START_DATE_ACTIVE
, PQNB.END_DATE_ACTIVE END_DATE_ACTIVE
, PQNT.SFWT_FLAG SFWT_FLAG
, PQNB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PQNB.CREATED_BY CREATED_BY
, PQNB.CREATION_DATE CREATION_DATE
, PQNB.LAST_UPDATED_BY LAST_UPDATED_BY
, PQNB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PQNB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PQNB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PQNB.ATTRIBUTE1 ATTRIBUTE1
, PQNB.ATTRIBUTE2 ATTRIBUTE2
, PQNB.ATTRIBUTE3 ATTRIBUTE3
, PQNB.ATTRIBUTE4 ATTRIBUTE4
, PQNB.ATTRIBUTE5 ATTRIBUTE5
, PQNB.ATTRIBUTE6 ATTRIBUTE6
, PQNB.ATTRIBUTE7 ATTRIBUTE7
, PQNB.ATTRIBUTE8 ATTRIBUTE8
, PQNB.ATTRIBUTE9 ATTRIBUTE9
, PQNB.ATTRIBUTE10 ATTRIBUTE10
, PQNB.ATTRIBUTE11 ATTRIBUTE11
, PQNB.ATTRIBUTE12 ATTRIBUTE12
, PQNB.ATTRIBUTE13 ATTRIBUTE13
, PQNB.ATTRIBUTE14 ATTRIBUTE14
, PQNB.ATTRIBUTE15 ATTRIBUTE15
FROM OKR_PROP_QSTNS_B PQNB
, OKR_PROP_QSTNS_TL PQNT
, OKR_PROP_RESP_SET_TL RPST
, FND_LOOKUPS QSL
, OKR_PROP_TYPES_TL PTYT
WHERE PQNB.ID = PQNT.ID
AND PQNT.LANGUAGE = USERENV('LANG')
AND PQNB.IP_TYPE = PTYT.IP_TYPE
AND PTYT.LANGUAGE = USERENV('LANG')
AND PQNB.RESP_SET_ID = RPST.ID
AND RPST.LANGUAGE = USERENV('LANG')
AND QSL.LOOKUP_TYPE = 'OKR_QUERY_TYPE'
AND QSL.LOOKUP_CODE = PQNB.QUERY_TYPE_CODE