View: AS_LIST_ENTRIES_V

View Text

SELECT LIST.ROWID ROW_ID
, LIST.LIST_ENTRY_ID
, LIST.LAST_UPDATE_DATE
, LIST.LAST_UPDATED_BY
, LIST.CREATION_DATE
, LIST.CREATED_BY
, LIST.LAST_UPDATE_LOGIN
, LIST.REQUEST_ID
, LIST.PROGRAM_APPLICATION_ID
, LIST.PROGRAM_ID
, LIST.PROGRAM_UPDATE_DATE
, LIST.LIST_ID
, LIST.LIST_SOURCE
, LIST.CUSTOMER_ID
, LIST.ADDRESS_ID
, LIST.CONTACT_ID
, LIST.PHONE_ID
, LIST.LEAD_ID
, LIST.PERSON_ID
, LIST.PERSON_USER_ID
, LIST.LETTER_ID
, LIST.EVENT_ID
, LIST.PICKING_HEADER_ID
, LIST.BATCH_ID
, LIST.MARKED_FLAG
, LIST.USE_PVT_MAILING_ADDRESS
, LIST.ATTRIBUTE_CATEGORY
, LIST.ATTRIBUTE1
, LIST.ATTRIBUTE2
, LIST.ATTRIBUTE3
, LIST.ATTRIBUTE4
, LIST.ATTRIBUTE5
, LIST.ATTRIBUTE6
, LIST.ATTRIBUTE7
, LIST.ATTRIBUTE8
, LIST.ATTRIBUTE9
, LIST.ATTRIBUTE10
, LIST.ATTRIBUTE11
, LIST.ATTRIBUTE12
, LIST.ATTRIBUTE13
, LIST.ATTRIBUTE14
, LIST.ATTRIBUTE15
, LIST.TRANSFER_FLAG
, LIST.TRANSFER_STATUS
, LIST.COMPANY_NAME
, LIST.ADDRESS1
, LIST.ADDRESS2
, LIST.ADDRESS3
, LIST.ADDRESS4
, LIST.CITY
, LIST.COUNTY
, LIST.STATE
, LIST.PROVINCE
, LIST.POSTAL_CODE
, LIST.COUNTRY_CODE
, LIST.FIRST_NAME
, LIST.LAST_NAME
, LIST.TITLE_CODE
, LOOK1.MEANING TITLE
, LIST.JOB_TITLE_CODE
, JOBS.MEANING
, LIST.JOB_TITLE
, LIST.MAIL_STOP
, LIST.EMAIL_ADDRESS
, LIST.PHONE_TYPE_CODE
, LIST.AREA_CODE
, LIST.PHONE_NUMBER
, LIST.AREA_CODE||LIST.PHONE_NUMBER
, LIST.EXTENSION
, LIST.ATTRIBUTE16
, LIST.ATTRIBUTE17
, LIST.ATTRIBUTE18
, LIST.ATTRIBUTE19
, LIST.ATTRIBUTE20
, LIST.ATTRIBUTE21
, LIST.ATTRIBUTE22
, LIST.ATTRIBUTE23
, LIST.ATTRIBUTE24
, LIST.ATTRIBUTE25
, LIST.CONTACT_SUFFIX
, LIST.CUSTOMER_ORIG_SYSTEM_REFERENCE
, LIST.ADDRESS_ORIG_SYSTEM_REFERENCE
, LIST.CONTACT_ORIG_SYSTEM_REFERENCE
, LIST.NUM_OF_EMPLOYEES
, LIST.PARENT_CUSTOMER_ID
, LIST.PARENT_COMPANY_NAME
, LIST.POTENTIAL_REVENUE_CURR_FY
, LIST.POTENTIAL_REVENUE_NEXT_FY
, LIST.FISCAL_YEAREND_MONTH
, LIST.ANALYSIS_FY
, LIST.MISSION_STATEMENT
, LIST.TAX_REFERENCE
, LIST.NET_WORTH
, LIST.YEAR_ESTABLISHED
, LIST.DEPARTMENT_CODE
, LOOK5.MEANING DEPARTMENT_MEANING
, LIST.DEPARTMENT
, LIST.RANK
, LIST.MANAGED_BY
, LIST.MANAGER_FIRST_NAME
, LIST.MANAGER_LAST_NAME
, LIST.NATIVE_LANGUAGE
, LOOK2.MEANING NATIVE_LANGUAGE_MEANING
, LIST.OTHER_LANGUAGE_1
, LOOK3.MEANING OTHER_LANGUAGE1_MEANING
, LIST.OTHER_LANGUAGE_2
, LOOK4.MEANING OTHER_LANGUAGE2_MEANING
, LIST.ADDRESS_PHONE_TYPE_CODE1
, LIST.ADDRESS_PHONE_TYPE_CODE2
, LIST.ADDRESS_PHONE_TYPE_CODE3
, LIST.ADDRESS_PHONE_TYPE_CODE4
, LIST.ADDRESS_PHONE_TYPE_CODE5
, LIST.ADDRESS_PHONE_AREA_CODE1
, LIST.ADDRESS_PHONE_AREA_CODE2
, LIST.ADDRESS_PHONE_AREA_CODE3
, LIST.ADDRESS_PHONE_AREA_CODE4
, LIST.ADDRESS_PHONE_AREA_CODE5
, LIST.ADDRESS_PHONE_NUMBER1
, LIST.ADDRESS_PHONE_NUMBER2
, LIST.ADDRESS_PHONE_NUMBER3
, LIST.ADDRESS_PHONE_NUMBER4
, LIST.ADDRESS_PHONE_NUMBER5
, LIST.ADDRESS_PHONE_AREA_CODE1|| LIST.ADDRESS_PHONE_NUMBER1 ADDRESS_FULL_NUMBER1
, LIST.ADDRESS_PHONE_AREA_CODE2|| LIST.ADDRESS_PHONE_NUMBER2 ADDRESS_FULL_NUMBER2
, LIST.ADDRESS_PHONE_AREA_CODE3|| LIST.ADDRESS_PHONE_NUMBER3 ADDRESS_FULL_NUMBER3
, LIST.ADDRESS_PHONE_AREA_CODE4|| LIST.ADDRESS_PHONE_NUMBER4 ADDRESS_FULL_NUMBER4
, LIST.ADDRESS_PHONE_AREA_CODE5|| LIST.ADDRESS_PHONE_NUMBER5 ADDRESS_FULL_NUMBER5
, LIST.ADDRESS_PHONE_EXTENSION1
, LIST.ADDRESS_PHONE_EXTENSION2
, LIST.ADDRESS_PHONE_EXTENSION3
, LIST.ADDRESS_PHONE_EXTENSION4
, LIST.ADDRESS_PHONE_EXTENSION5
, LIST.CONTACT_PHONE_TYPE_CODE1
, LIST.CONTACT_PHONE_TYPE_CODE2
, LIST.CONTACT_PHONE_TYPE_CODE3
, LIST.CONTACT_PHONE_TYPE_CODE4
, LIST.CONTACT_PHONE_TYPE_CODE5
, LIST.CONTACT_PHONE_AREA_CODE1
, LIST.CONTACT_PHONE_AREA_CODE2
, LIST.CONTACT_PHONE_AREA_CODE3
, LIST.CONTACT_PHONE_AREA_CODE4
, LIST.CONTACT_PHONE_AREA_CODE5
, LIST.CONTACT_PHONE_NUMBER1
, LIST.CONTACT_PHONE_NUMBER2
, LIST.CONTACT_PHONE_NUMBER3
, LIST.CONTACT_PHONE_NUMBER4
, LIST.CONTACT_PHONE_NUMBER5
, LIST.CONTACT_PHONE_AREA_CODE1|| LIST.CONTACT_PHONE_NUMBER1 CONTACT_FULL_NUMBER1
, LIST.CONTACT_PHONE_AREA_CODE2|| LIST.CONTACT_PHONE_NUMBER2 CONTACT_FULL_NUMBER2
, LIST.CONTACT_PHONE_AREA_CODE3|| LIST.CONTACT_PHONE_NUMBER3 CONTACT_FULL_NUMBER3
, LIST.CONTACT_PHONE_AREA_CODE4|| LIST.CONTACT_PHONE_NUMBER4 CONTACT_FULL_NUMBER4
, LIST.CONTACT_PHONE_AREA_CODE5|| LIST.CONTACT_PHONE_NUMBER5 CONTACT_FULL_NUMBER5
, LIST.CONTACT_PHONE_EXTENSION1
, LIST.CONTACT_PHONE_EXTENSION2
, LIST.CONTACT_PHONE_EXTENSION3
, LIST.CONTACT_PHONE_EXTENSION4
, LIST.CONTACT_PHONE_EXTENSION5
, LIST.CUSTOMER_USER_DEFINED1
, LIST.CUSTOMER_USER_DEFINED2
, LIST.CUSTOMER_USER_DEFINED3
, LIST.CUSTOMER_USER_DEFINED4
, LIST.CUSTOMER_USER_DEFINED5
, LIST.CUSTOMER_USER_DEFINED6
, LIST.CUSTOMER_USER_DEFINED7
, LIST.CUSTOMER_USER_DEFINED8
, LIST.CUSTOMER_USER_DEFINED9
, LIST.CUSTOMER_USER_DEFINED10
, LIST.CUSTOMER_USER_DEFINED11
, LIST.CUSTOMER_USER_DEFINED12
, LIST.CUSTOMER_USER_DEFINED13
, LIST.CUSTOMER_USER_DEFINED14
, LIST.CUSTOMER_USER_DEFINED15
, LIST.ADDRESS_USER_DEFINED1
, LIST.ADDRESS_USER_DEFINED2
, LIST.ADDRESS_USER_DEFINED3
, LIST.ADDRESS_USER_DEFINED4
, LIST.ADDRESS_USER_DEFINED5
, LIST.ADDRESS_USER_DEFINED6
, LIST.ADDRESS_USER_DEFINED7
, LIST.ADDRESS_USER_DEFINED8
, LIST.ADDRESS_USER_DEFINED9
, LIST.ADDRESS_USER_DEFINED10
, LIST.ADDRESS_USER_DEFINED11
, LIST.ADDRESS_USER_DEFINED12
, LIST.ADDRESS_USER_DEFINED13
, LIST.ADDRESS_USER_DEFINED14
, LIST.ADDRESS_USER_DEFINED15
, LIST.CONTACT_USER_DEFINED1
, LIST.CONTACT_USER_DEFINED2
, LIST.CONTACT_USER_DEFINED3
, LIST.CONTACT_USER_DEFINED4
, LIST.CONTACT_USER_DEFINED5
, LIST.CONTACT_USER_DEFINED6
, LIST.CONTACT_USER_DEFINED7
, LIST.CONTACT_USER_DEFINED8
, LIST.CONTACT_USER_DEFINED9
, LIST.CONTACT_USER_DEFINED10
, LIST.CONTACT_USER_DEFINED11
, LIST.CONTACT_USER_DEFINED12
, LIST.CONTACT_USER_DEFINED13
, LIST.CONTACT_USER_DEFINED14
, LIST.CONTACT_USER_DEFINED15
, LIST.CONTACT_USER_DEFINED16
, LIST.CONTACT_USER_DEFINED17
, LIST.CONTACT_USER_DEFINED18
, LIST.CONTACT_USER_DEFINED19
, LIST.CONTACT_USER_DEFINED20
, LIST.CONTACT_USER_DEFINED21
, LIST.CONTACT_USER_DEFINED22
, LIST.CONTACT_USER_DEFINED23
, LIST.CONTACT_USER_DEFINED24
, LIST.CONTACT_USER_DEFINED25
, TERR1.TERRITORY_SHORT_NAME COUNTRY
FROM AS_LIST_ENTRIES LIST
, FND_TERRITORIES_TL TERR1
, AR_LOOKUPS LOOK1
, AS_LOOKUPS LOOK2
, AS_LOOKUPS LOOK3
, AS_LOOKUPS LOOK4
, AR_LOOKUPS LOOK5
, AR_LOOKUPS JOBS
WHERE TERR1.TERRITORY_CODE(+) = LIST.COUNTRY_CODE
AND TERR1.LANGUAGE(+) = USERENV('LANG')
AND LOOK1.LOOKUP_CODE(+) = LIST.TITLE_CODE
AND LOOK1.LOOKUP_TYPE(+) = 'CONTACT_TITLE'
AND LOOK2.LOOKUP_CODE(+) = LIST.NATIVE_LANGUAGE
AND LOOK2.LOOKUP_TYPE(+) = 'LANGUAGE'
AND LOOK3.LOOKUP_CODE(+) = LIST.OTHER_LANGUAGE_1
AND LOOK3.LOOKUP_TYPE(+) = 'LANGUAGE'
AND LOOK4.LOOKUP_CODE(+) = LIST.OTHER_LANGUAGE_2
AND LOOK4.LOOKUP_TYPE(+) = 'LANGUAGE'
AND JOBS.LOOKUP_CODE(+) = LIST.JOB_TITLE_CODE
AND JOBS.LOOKUP_TYPE(+) = 'RESPONSIBILITY'
AND JOBS.ENABLED_FLAG(+) = 'Y'
AND SYSDATE BETWEEN JOBS.START_DATE_ACTIVE(+)
AND NVL(JOBS.END_DATE_ACTIVE(+)
, SYSDATE + 1)
AND LOOK5.LOOKUP_CODE(+) = LIST.DEPARTMENT_CODE
AND LOOK5.LOOKUP_TYPE(+) = 'DEPARTMENT'

Columns