VIEW: APPS.AST_LM_ORG_EXP_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'