DBA Data[Home] [Help]

VIEW: APPS.AS_SALES_LEAD_QUALS_VL

Source

View Text - Preformatted

SELECT B.SEED_QUAL_ID , B.CREATION_DATE , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.CREATED_BY , B.LAST_UPDATE_LOGIN , B.ENABLED_FLAG , B.LOV_SQL , T.DESCRIPTION , B.RANGE_FLAG , B.DATA_TYPE , T.MEANING , B.SOURCE_TABLE_NAME, B.SOURCE_COLUMN_NAME from AS_SALES_LEAD_QUALS_B b , AS_SALES_LEAD_QUALS_TL t where B.seed_qual_ID = T.seed_qual_ID and T.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT B.SEED_QUAL_ID
, B.CREATION_DATE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.ENABLED_FLAG
, B.LOV_SQL
, T.DESCRIPTION
, B.RANGE_FLAG
, B.DATA_TYPE
, T.MEANING
, B.SOURCE_TABLE_NAME
, B.SOURCE_COLUMN_NAME
FROM AS_SALES_LEAD_QUALS_B B
, AS_SALES_LEAD_QUALS_TL T
WHERE B.SEED_QUAL_ID = T.SEED_QUAL_ID
AND T.LANGUAGE = USERENV('LANG')