VIEW: APPS.BIM_DIMV_PROD_LOV

Source

View Text - Preformatted

SELECT HIER.INTEREST_TYPE_ID, INTYP.INTEREST_TYPE, HIER.PRIMARY_INTEREST_CODE_ID, PCODE.CODE, HIER.SECONDARY_INTEREST_CODE_ID, SCODE.CODE FROM BIM_SALES_CATEGORY_HIER HIER, AS_INTEREST_TYPES_TL INTYP, AS_INTEREST_CODES_TL PCODE, AS_INTEREST_CODES_TL SCODE WHERE HIER.INTEREST_TYPE_ID = INTYP.INTEREST_TYPE_ID AND INTYP.LANGUAGE = userenv('LANG') AND HIER.PRIMARY_INTEREST_CODE_ID = PCODE.INTEREST_CODE_ID (+) AND PCODE.LANGUAGE (+) = userenv('LANG') AND HIER.SECONDARY_INTEREST_CODE_ID = SCODE.INTEREST_CODE_ID (+) AND SCODE.LANGUAGE (+) = userenv( 'LANG' ) UNION ALL SELECT -999 , MEANING , -999 , MEANING , -999 , MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE' AND LOOKUP_CODE = '-999' WITH READ ONLY

View Text - HTML Formatted

SELECT HIER.INTEREST_TYPE_ID
, INTYP.INTEREST_TYPE
, HIER.PRIMARY_INTEREST_CODE_ID
, PCODE.CODE
, HIER.SECONDARY_INTEREST_CODE_ID
, SCODE.CODE
FROM BIM_SALES_CATEGORY_HIER HIER
, AS_INTEREST_TYPES_TL INTYP
, AS_INTEREST_CODES_TL PCODE
, AS_INTEREST_CODES_TL SCODE
WHERE HIER.INTEREST_TYPE_ID = INTYP.INTEREST_TYPE_ID
AND INTYP.LANGUAGE = USERENV('LANG')
AND HIER.PRIMARY_INTEREST_CODE_ID = PCODE.INTEREST_CODE_ID (+)
AND PCODE.LANGUAGE (+) = USERENV('LANG')
AND HIER.SECONDARY_INTEREST_CODE_ID = SCODE.INTEREST_CODE_ID (+)
AND SCODE.LANGUAGE (+) = USERENV( 'LANG' ) UNION ALL SELECT -999
, MEANING
, -999
, MEANING
, -999
, MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' WITH READ ONLY