View: AS_LISTS_V

View Text

SELECT L.ROWID
, L.LIST_ID
, L.LIST_RULE_ID
, RULE1.RULE_NAME
, L.LIST_PRIORITY_ID
, RULE2.RULE_NAME
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.CREATION_DATE
, L.CREATED_BY
, L.LAST_UPDATE_LOGIN
, L.NAME
, L.TYPE
, ASLKP1.MEANING
, L.ENABLED_FLAG
, L.OWNER_PERSON_ID
, L.ASSIGN_PERSON_ID
, L.PUBLIC_FLAG
, L.LIST_SOURCE
, L.LIST_ONLINE_FLAG
, DECODE( L.LIST_ONLINE_FLAG
, 'Y'
, '*'
, NULL)
, L.ATTRIBUTE_CATEGORY
, L.ATTRIBUTE1
, L.ATTRIBUTE2
, L.ATTRIBUTE3
, L.ATTRIBUTE4
, L.ATTRIBUTE5
, L.ATTRIBUTE6
, L.ATTRIBUTE7
, L.ATTRIBUTE8
, L.ATTRIBUTE9
, L.ATTRIBUTE10
, L.ATTRIBUTE11
, L.ATTRIBUTE12
, L.ATTRIBUTE13
, L.ATTRIBUTE14
, L.ATTRIBUTE15
, PER1.FIRST_NAME
, PER1.LAST_NAME
FROM AS_LOOKUPS ASLKP1
, PER_EMPLOYEES_CURRENT_X PER1
, PER_EMPLOYEES_CURRENT_X PER2
, AS_LISTS L
, AS_LIST_RULES RULE1
, AS_LIST_RULES RULE2
WHERE L.OWNER_PERSON_ID = PER1.EMPLOYEE_ID(+)
AND L.ASSIGN_PERSON_ID = PER2.EMPLOYEE_ID(+)
AND L.TYPE = ASLKP1.LOOKUP_CODE(+)
AND ASLKP1.LOOKUP_TYPE(+) ='LIST_TYPE'
AND RULE1.LIST_RULE_ID(+) = L.LIST_RULE_ID
AND RULE2.LIST_RULE_ID(+) = L.LIST_PRIORITY_ID

Columns