View: PA_CONFIG_LISTS_DISPLAY_V

View Text

SELECT LIST_NAME
, TO_CHAR(LIST_ID) LIST_ID
, USER_ID
, NVL(DEFAULT_FLAG
, 'N')
, OBJECT_ID
, SUBOBJECT_TYPE_CODE
FROM PA_CONFIG_LISTS_V UNION SELECT PCL.LIST_NAME
, TO_CHAR(PCL.LIST_ID)
, XPM1.USER_ID
, 'N'
, PCL.OBJECT_ID
, PCL.SUBOBJECT_TYPE_CODE
FROM PA_CONFIG_LISTS_V PCL
, PA_XC_KEY_MEMBERS_V XPM1
WHERE PCL.PUBLIC_FLAG ='Y'
AND XPM1.COMPANY_ID = (SELECT DISTINCT XPM2.COMPANY_ID
FROM PA_XC_KEY_MEMBERS_V XPM2
WHERE XPM2.USER_ID = PCL.USER_ID)
AND PCL.LIST_ID NOT IN (SELECT LIST_ID
FROM PA_CONFIG_LISTS_V
WHERE USER_ID = XPM1.USER_ID) UNION SELECT PL.MEANING
, PL.LOOKUP_CODE
, FU.USER_ID
, 'A'
, OBJ.OBJECT_ID
, FL.LOOKUP_CODE
FROM PA_LOOKUPS PL
, FND_USER FU
, FND_OBJECTS OBJ
, FND_LOOKUPS FL
WHERE PL.LOOKUP_TYPE = 'PA_CONFIG_LIST'
AND FL.LOOKUP_TYPE (+) = OBJ.OBJ_NAME || '_SUBTYPES'

Columns