View: AST_LM_ORG_EXP_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_LM_ORG_EXP_V

View Text

SELECT LE.PARTY_ID
, PARTY.PARTY_NAME
, PARTY.ADDRESS1||' '||PARTY.ADDRESS2||' '||PARTY.ADDRESS3||' '||PARTY.ADDRESS4
, PARTY.ADDRESS1
, PARTY.ADDRESS2
, PARTY.ADDRESS3
, PARTY.ADDRESS4
, PARTY.CITY
, PARTY.STATE
, PARTY.POSTAL_CODE
, PARTY.PROVINCE
, PARTY.COUNTRY
, FTT.TERRITORY_SHORT_NAME
, PARTY.EMAIL_ADDRESS
, CONT_POINT.PHONE_COUNTRY_CODE
, CONT_POINT.PHONE_AREA_CODE
, CONT_POINT.PHONE_NUMBER
, CONT_POINT.PHONE_EXTENSION
, NVL(CONT_POINT.PHONE_COUNTRY_CODE
, ' ')||'-'|| NVL(CONT_POINT.PHONE_AREA_CODE
, ' ')||'-'|| CONT_POINT.PHONE_NUMBER ||' '|| CONT_POINT.PHONE_EXTENSION
, PARTY.STATUS
, AL.MEANING
, PARTY.URL
, PARTY.EMPLOYEES_TOTAL
, PARTY.CATEGORY_CODE
, PARTY.ATTRIBUTE1
, PARTY.ATTRIBUTE2
, PARTY.ATTRIBUTE3
, PARTY.ATTRIBUTE4
, PARTY.ATTRIBUTE5
, PARTY.ATTRIBUTE6
, PARTY.ATTRIBUTE7
, PARTY.ATTRIBUTE8
, PARTY.ATTRIBUTE9
, PARTY.ATTRIBUTE10
, PARTY.ATTRIBUTE11
, PARTY.ATTRIBUTE12
, PARTY.ATTRIBUTE13
, PARTY.ATTRIBUTE14
, PARTY.ATTRIBUTE15
, PARTY.ATTRIBUTE16
, PARTY.ATTRIBUTE17
, PARTY.ATTRIBUTE18
, PARTY.ATTRIBUTE19
, PARTY.ATTRIBUTE20
FROM HZ_PARTIES PARTY
, FND_TERRITORIES_TL FTT
, AMS_SOURCE_CODES SC
, AMS_LIST_ENTRIES LE
, AMS_LOOKUPS AL
, HZ_CONTACT_POINTS CONT_POINT
WHERE PARTY.COUNTRY = FTT.TERRITORY_CODE(+)
AND SC.SOURCE_CODE = LE.SOURCE_CODE
AND SC.SOURCE_CODE_FOR_ID = LE.SOURCE_CODE_FOR_ID
AND LE.ENABLED_FLAG = 'Y'
AND SC.ARC_SOURCE_CODE_FOR=AL.LOOKUP_CODE(+)
AND AL.ENABLED_FLAG(+) = 'Y'
AND AL.LOOKUP_TYPE(+) = 'AMS_USING_OBJECT_TYPE'
AND LE.PARTY_ID IS NOT NULL
AND LE.PARTY_ID = PARTY.PARTY_ID(+)
AND CONT_POINT.CONTACT_POINT_TYPE(+) = 'PHONE'
AND CONT_POINT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND CONT_POINT.OWNER_TABLE_ID(+) = PARTY.PARTY_ID
AND CONT_POINT.PRIMARY_FLAG(+) = 'Y'

Columns