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.

VIEW: APPS.OKI_CCLASS_OLTP_V

Source

View Text - Preformatted


SELECT l.lookup_type class_category , l.lookup_code class_code , l.meaning class_code_meaning , l.description class_code_description , cat.meaning category_meaning FROM AR_LOOKUPS L , FND_LOOKUP_TYPES_TL CAT , HZ_CLASS_CATEGORY_USES HZ WHERE l.enabled_flag = 'Y' AND hz.class_category = l.lookup_type AND hz.owner_table = 'HZ_PARTIES' AND cat.lookup_type = hz.class_category AND cat.language = USERENV( 'LANG' ) AND cat.view_application_id = 222

View Text - HTML Formatted

SELECT L.LOOKUP_TYPE CLASS_CATEGORY
, L.LOOKUP_CODE CLASS_CODE
, L.MEANING CLASS_CODE_MEANING
, L.DESCRIPTION CLASS_CODE_DESCRIPTION
, CAT.MEANING CATEGORY_MEANING
FROM AR_LOOKUPS L
, FND_LOOKUP_TYPES_TL CAT
, HZ_CLASS_CATEGORY_USES HZ
WHERE L.ENABLED_FLAG = 'Y'
AND HZ.CLASS_CATEGORY = L.LOOKUP_TYPE
AND HZ.OWNER_TABLE = 'HZ_PARTIES'
AND CAT.LOOKUP_TYPE = HZ.CLASS_CATEGORY
AND CAT.LANGUAGE = USERENV( 'LANG' )
AND CAT.VIEW_APPLICATION_ID = 222