VIEW: APPS.AS_INTEREST_TYPES_VL

Source

View Text - Preformatted

SELECT B.INTEREST_TYPE_ID , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_LOGIN , B.ENABLED_FLAG MASTER_ENABLED_FLAG , B.COMPANY_CLASSIFICATION_FLAG , B.CONTACT_INTEREST_FLAG , B.LEAD_CLASSIFICATION_FLAG , B.EXPECTED_PURCHASE_FLAG , B.CURRENT_ENVIRONMENT_FLAG , 'Y' , NULL , T.INTEREST_TYPE , T.DESCRIPTION , B.PRODUCT_CATEGORY_ID , B.PRODUCT_CAT_SET_ID FROM AS_INTEREST_TYPES_B B, AS_INTEREST_TYPES_TL T WHERE B.INTEREST_TYPE_ID = T.INTEREST_TYPE_ID AND T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.INTEREST_TYPE_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.ENABLED_FLAG MASTER_ENABLED_FLAG
, B.COMPANY_CLASSIFICATION_FLAG
, B.CONTACT_INTEREST_FLAG
, B.LEAD_CLASSIFICATION_FLAG
, B.EXPECTED_PURCHASE_FLAG
, B.CURRENT_ENVIRONMENT_FLAG
, 'Y'
, NULL
, T.INTEREST_TYPE
, T.DESCRIPTION
, B.PRODUCT_CATEGORY_ID
, B.PRODUCT_CAT_SET_ID
FROM AS_INTEREST_TYPES_B B
, AS_INTEREST_TYPES_TL T
WHERE B.INTEREST_TYPE_ID = T.INTEREST_TYPE_ID
AND T.LANGUAGE = USERENV('LANG')