eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKR_IP_CLSFS_DV

Product:	OKR - Contracts for Rights (Obsolete)
Description:	View on OKR_IP_COMMON_B, OKR_IP_CLASSIFICATION and FND_LOOKUPS
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PCN.ID ID
, PCN.ROWID
, PCN.IP_ID IP_ID
, PCN.CLSF_TYPE CLSF_TYPE
, CSFT.MEANING CLSF_TYPE_MEANING
, PCN.CLSF_CODE CLSF_CODE
, CSFC.MEANING CLSF_CODE_MEANING
, IPYBB.IP_TYPE IP_TYPE
, IPYBB.IP_IDENTIFIER IP_IDENTIFIER
, IPYBT.NAME NAME
, IPYBT.SUBJECT SUBJECT
, IPYBT.DESCRIPTION DESCRIPTION
, IPYBB.COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN
, IPYBB.IP_LANG_CODE IP_LANG_CODE
, IPYBB.DATE_OF_CREATION DATE_OF_CREATION
, IPYBB.ORIG_CPRGT_DATE ORIG_CPRGT_DATE
, IPYBB.OWN_CPRGT OWN_CPRGT
, IPYBB.ASSET_ID ASSET_ID
, IPYBB.REFERENCE_PROPERTY REFERENCE_PROPERTY
, IPYBT.KEYWORD_TEXT KEYWORD_TEXT
, IPYBB.START_DATE_ACTIVE START_DATE_ACTIVE
, IPYBB.END_DATE_ACTIVE END_DATE_ACTIVE
FROM OKR_IP_COMMON_B IPYBB
, OKR_IP_COMMON_TL IPYBT
, OKR_IP_CLASSIFICATIONS PCN
, FND_LOOKUPS CSFT
, FND_LOOKUPS CSFC
WHERE IPYBB.IP_ID = IPYBT.IP_ID
AND IPYBT.LANGUAGE = USERENV('LANG')
AND PCN.IP_ID = IPYBB.IP_ID
AND CSFT.LOOKUP_TYPE = 'OKR_CLASSIFICATION_TYPES'
AND CSFT.LOOKUP_CODE = PCN.CLSF_TYPE
AND CSFC.LOOKUP_TYPE = 'OKR_CLASSIFICATION_CODES'
AND CSFC.LOOKUP_CODE = PCN.CLSF_CODE

Columns

Name
ID
ROW_ID
IP_ID
CLSF_TYPE
CLSF_TYPE_MEANING
CLSF_CODE
CLSF_CODE_MEANING
IP_TYPE
IP_IDENTIFIER
NAME
SUBJECT
DESCRIPTION
COUNTRY_OF_ORIGIN
IP_LANG_CODE
DATE_OF_CREATION
ORIG_CPRGT_DATE
OWN_CPRGT
ASSET_ID
REFERENCE_PROPERTY
KEYWORD_TEXT
START_DATE_ACTIVE
END_DATE_ACTIVE