DBA Data[Home] [Help]

VIEW: APPS.CZ_ITEMMASTEROPS_LKV

Source

View Text - Preformatted

SELECT "LIST_NAME","DATA_VALUE","VALUE_SEQ","DATA_TYPE_ID","NULL_VALUE_FLAG","VALUE_LABEL","VALUE_DESCRIPTION","VALUE_NOTES","LANGUAGE","SOURCE_LANG","CREATION_DATE","LAST_UPDATE_DATE","CREATED_BY","LAST_UPDATED_BY","LAST_UPDATE_LOGIN","NUMERIC_ID_VALUE" from cz_lookup_values_vl WHERE list_name = 'ITEMMASTER_OPS'
View Text - HTML Formatted

SELECT "LIST_NAME"
, "DATA_VALUE"
, "VALUE_SEQ"
, "DATA_TYPE_ID"
, "NULL_VALUE_FLAG"
, "VALUE_LABEL"
, "VALUE_DESCRIPTION"
, "VALUE_NOTES"
, "LANGUAGE"
, "SOURCE_LANG"
, "CREATION_DATE"
, "LAST_UPDATE_DATE"
, "CREATED_BY"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_LOGIN"
, "NUMERIC_ID_VALUE"
FROM CZ_LOOKUP_VALUES_VL
WHERE LIST_NAME = 'ITEMMASTER_OPS'