eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IEX_LM_ORG_EXPAND_V

Source

View Text - Preformatted


SELECT PARTY.PARTY_ID , PARTY.PARTY_NUMBER , to_char(null) , to_number(null) , PARTY.PARTY_NAME , loc.ADDRESS1||' '||loc.ADDRESS2||' '||loc.ADDRESS3||' '||loc.ADDRESS4 , loc.ADDRESS1 , loc.ADDRESS2 , loc.ADDRESS3 , loc.ADDRESS4 , loc.CITY , loc.COUNTY , loc.STATE , loc.PROVINCE , loc.POSTAL_CODE , loc.ADDRESS_LINES_PHONETIC , loc.ACTUAL_CONTENT_SOURCE , loc.ADDRESS_EFFECTIVE_DATE , loc.ADDRESS_ERROR_CODE , loc.ADDRESS_EXPIRATION_DATE , loc.ADDRESS_KEY , loc.ADDRESS_STYLE , loc.APARTMENT_FLAG , loc.APARTMENT_NUMBER , loc.APPLICATION_ID , loc.BUILDING , loc.CLLI_CODE , loc.CONTENT_SOURCE_TYPE , loc.COUNTRY , loc.CREATED_BY , loc.CREATED_BY_MODULE , loc.CREATION_DATE , loc.DELIVERY_POINT_CODE , loc.DESCRIPTION , loc.DODAAC , loc.FA_LOCATION_ID , loc.FLOOR , loc.GEOMETRY_STATUS_CODE , loc.GLOBAL_ATTRIBUTE_CATEGORY , loc.GLOBAL_ATTRIBUTE1 , loc.GLOBAL_ATTRIBUTE10 , loc.GLOBAL_ATTRIBUTE11 , loc.GLOBAL_ATTRIBUTE12 , loc.GLOBAL_ATTRIBUTE13 , loc.GLOBAL_ATTRIBUTE14 , loc.GLOBAL_ATTRIBUTE15 , loc.GLOBAL_ATTRIBUTE16 , loc.GLOBAL_ATTRIBUTE17 , loc.GLOBAL_ATTRIBUTE18 , loc.GLOBAL_ATTRIBUTE19 , loc.GLOBAL_ATTRIBUTE2 , loc.GLOBAL_ATTRIBUTE20 , loc.GLOBAL_ATTRIBUTE3 , loc.GLOBAL_ATTRIBUTE4 , loc.GLOBAL_ATTRIBUTE5 , loc.GLOBAL_ATTRIBUTE6 , loc.GLOBAL_ATTRIBUTE7 , loc.GLOBAL_ATTRIBUTE8 , loc.GLOBAL_ATTRIBUTE9 , loc.HOUSE_NUMBER , loc.LAST_UPDATE_DATE , loc.LAST_UPDATE_LOGIN , loc.LAST_UPDATED_BY , loc.LIFE_CYCLE_STATUS , loc.LOC_HIERARCHY_ID , loc.LOCATION_DIRECTIONS , loc.OBJECT_VERSION_NUMBER , loc.ORIG_SYSTEM_REFERENCE , loc.OVERSEAS_ADDRESS_FLAG , loc.PO_BOX_NUMBER , loc.POSITION , loc.POST_OFFICE , loc.POSTAL_PLUS4_CODE , loc.PROGRAM_APPLICATION_ID , loc.PROGRAM_ID , loc.PROGRAM_UPDATE_DATE , loc.REQUEST_ID , loc.ROOM , loc.RURAL_ROUTE_NUMBER , loc.RURAL_ROUTE_TYPE , loc.SALES_TAX_GEOCODE , loc.SALES_TAX_INSIDE_CITY_LIMITS , loc.SECONDARY_SUFFIX_ELEMENT , loc.SHORT_DESCRIPTION , loc.STREET , loc.STREET_NUMBER , loc.STREET_SUFFIX , loc.SUITE , time.timezone_code TIME_ZONE , loc.TRAILING_DIRECTORY_CODE , loc.VALIDATED_FLAG , loc.WH_UPDATE_DATE , FTT.TERRITORY_SHORT_NAME , HCP2.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 , CONT_POINT.PHONE_AREA_CODE||CONT_POINT.PHONE_NUMBER , PARTY.STATUS , ALK.MEANING , PARTY.URL , PARTY.EMPLOYEES_TOTAL , ALK1.MEANING , PARTY.JGZZ_FISCAL_CODE , PARTY.CURR_FY_POTENTIAL_REVENUE , PARTY.DUNS_NUMBER , PARTY.FISCAL_YEAREND_MONTH , PARTY.SIC_CODE , PARTY.TAX_REFERENCE , 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 , CONT_POINT.PRIMARY_FLAG FROM HZ_PARTIES PARTY , HZ_CONTACT_POINTS CONT_POINT , HZ_CONTACT_POINTS HCP2 , FND_TERRITORIES_TL FTT , AR_LOOKUPS ALK , AR_LOOKUPS ALK1 , HZ_PARTY_SITES SITE , HZ_LOCATIONS LOC , fnd_TIMEZONES_TL TIME, fnd_timezones_b time_b, hz_party_usg_assignments USAGE WHERE SITE.LOCATION_ID = LOC.LOCATION_ID(+) AND TIME_B.UPGRADE_TZ_ID(+) = LOC.TIMEZONE_ID AND time_b.timezone_code = time.timezone_code (+) and TIME.LANGUAGE(+) = userenv('LANG') AND party.party_id = site.party_id(+) and site.IDENTIFYING_ADDRESS_FLAG(+) = 'Y' and PARTY.PARTY_TYPE = 'ORGANIZATION' 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.STATUS(+) = 'A' AND HCP2.CONTACT_POINT_TYPE(+) = 'EMAIL' AND HCP2.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' AND HCP2.OWNER_TABLE_ID(+) = PARTY.PARTY_ID AND loc.COUNTRY = FTT.TERRITORY_CODE(+) AND FTT.LANGUAGE(+) = userenv('LANG') AND FTT.SOURCE_LANG(+) = userenv('LANG') AND ALK.LOOKUP_TYPE (+) = 'CODE_STATUS' AND ALK.LOOKUP_CODE (+) = PARTY.STATUS AND ALK1.LOOKUP_TYPE (+) = 'CUSTOMER_CATEGORY' AND ALK1.ENABLED_FLAG (+) = 'Y' AND ALK1.LOOKUP_CODE (+) = PARTY.CATEGORY_CODE AND PARTY.PARTY_ID = USAGE.PARTY_ID AND upper(USAGE.party_usage_code) IN ('CUSTOMER','ORG_CONTACT')

View Text - HTML Formatted

SELECT PARTY.PARTY_ID
, PARTY.PARTY_NUMBER
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, PARTY.PARTY_NAME
, LOC.ADDRESS1||' '||LOC.ADDRESS2||' '||LOC.ADDRESS3||' '||LOC.ADDRESS4
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.COUNTY
, LOC.STATE
, LOC.PROVINCE
, LOC.POSTAL_CODE
, LOC.ADDRESS_LINES_PHONETIC
, LOC.ACTUAL_CONTENT_SOURCE
, LOC.ADDRESS_EFFECTIVE_DATE
, LOC.ADDRESS_ERROR_CODE
, LOC.ADDRESS_EXPIRATION_DATE
, LOC.ADDRESS_KEY
, LOC.ADDRESS_STYLE
, LOC.APARTMENT_FLAG
, LOC.APARTMENT_NUMBER
, LOC.APPLICATION_ID
, LOC.BUILDING
, LOC.CLLI_CODE
, LOC.CONTENT_SOURCE_TYPE
, LOC.COUNTRY
, LOC.CREATED_BY
, LOC.CREATED_BY_MODULE
, LOC.CREATION_DATE
, LOC.DELIVERY_POINT_CODE
, LOC.DESCRIPTION
, LOC.DODAAC
, LOC.FA_LOCATION_ID
, LOC.FLOOR
, LOC.GEOMETRY_STATUS_CODE
, LOC.GLOBAL_ATTRIBUTE_CATEGORY
, LOC.GLOBAL_ATTRIBUTE1
, LOC.GLOBAL_ATTRIBUTE10
, LOC.GLOBAL_ATTRIBUTE11
, LOC.GLOBAL_ATTRIBUTE12
, LOC.GLOBAL_ATTRIBUTE13
, LOC.GLOBAL_ATTRIBUTE14
, LOC.GLOBAL_ATTRIBUTE15
, LOC.GLOBAL_ATTRIBUTE16
, LOC.GLOBAL_ATTRIBUTE17
, LOC.GLOBAL_ATTRIBUTE18
, LOC.GLOBAL_ATTRIBUTE19
, LOC.GLOBAL_ATTRIBUTE2
, LOC.GLOBAL_ATTRIBUTE20
, LOC.GLOBAL_ATTRIBUTE3
, LOC.GLOBAL_ATTRIBUTE4
, LOC.GLOBAL_ATTRIBUTE5
, LOC.GLOBAL_ATTRIBUTE6
, LOC.GLOBAL_ATTRIBUTE7
, LOC.GLOBAL_ATTRIBUTE8
, LOC.GLOBAL_ATTRIBUTE9
, LOC.HOUSE_NUMBER
, LOC.LAST_UPDATE_DATE
, LOC.LAST_UPDATE_LOGIN
, LOC.LAST_UPDATED_BY
, LOC.LIFE_CYCLE_STATUS
, LOC.LOC_HIERARCHY_ID
, LOC.LOCATION_DIRECTIONS
, LOC.OBJECT_VERSION_NUMBER
, LOC.ORIG_SYSTEM_REFERENCE
, LOC.OVERSEAS_ADDRESS_FLAG
, LOC.PO_BOX_NUMBER
, LOC.POSITION
, LOC.POST_OFFICE
, LOC.POSTAL_PLUS4_CODE
, LOC.PROGRAM_APPLICATION_ID
, LOC.PROGRAM_ID
, LOC.PROGRAM_UPDATE_DATE
, LOC.REQUEST_ID
, LOC.ROOM
, LOC.RURAL_ROUTE_NUMBER
, LOC.RURAL_ROUTE_TYPE
, LOC.SALES_TAX_GEOCODE
, LOC.SALES_TAX_INSIDE_CITY_LIMITS
, LOC.SECONDARY_SUFFIX_ELEMENT
, LOC.SHORT_DESCRIPTION
, LOC.STREET
, LOC.STREET_NUMBER
, LOC.STREET_SUFFIX
, LOC.SUITE
, TIME.TIMEZONE_CODE TIME_ZONE
, LOC.TRAILING_DIRECTORY_CODE
, LOC.VALIDATED_FLAG
, LOC.WH_UPDATE_DATE
, FTT.TERRITORY_SHORT_NAME
, HCP2.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
, CONT_POINT.PHONE_AREA_CODE||CONT_POINT.PHONE_NUMBER
, PARTY.STATUS
, ALK.MEANING
, PARTY.URL
, PARTY.EMPLOYEES_TOTAL
, ALK1.MEANING
, PARTY.JGZZ_FISCAL_CODE
, PARTY.CURR_FY_POTENTIAL_REVENUE
, PARTY.DUNS_NUMBER
, PARTY.FISCAL_YEAREND_MONTH
, PARTY.SIC_CODE
, PARTY.TAX_REFERENCE
, 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
, CONT_POINT.PRIMARY_FLAG
FROM HZ_PARTIES PARTY
, HZ_CONTACT_POINTS CONT_POINT
, HZ_CONTACT_POINTS HCP2
, FND_TERRITORIES_TL FTT
, AR_LOOKUPS ALK
, AR_LOOKUPS ALK1
, HZ_PARTY_SITES SITE
, HZ_LOCATIONS LOC
, FND_TIMEZONES_TL TIME
, FND_TIMEZONES_B TIME_B
, HZ_PARTY_USG_ASSIGNMENTS USAGE
WHERE SITE.LOCATION_ID = LOC.LOCATION_ID(+)
AND TIME_B.UPGRADE_TZ_ID(+) = LOC.TIMEZONE_ID
AND TIME_B.TIMEZONE_CODE = TIME.TIMEZONE_CODE (+)
AND TIME.LANGUAGE(+) = USERENV('LANG')
AND PARTY.PARTY_ID = SITE.PARTY_ID(+)
AND SITE.IDENTIFYING_ADDRESS_FLAG(+) = 'Y'
AND PARTY.PARTY_TYPE = 'ORGANIZATION'
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.STATUS(+) = 'A'
AND HCP2.CONTACT_POINT_TYPE(+) = 'EMAIL'
AND HCP2.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND HCP2.OWNER_TABLE_ID(+) = PARTY.PARTY_ID
AND LOC.COUNTRY = FTT.TERRITORY_CODE(+)
AND FTT.LANGUAGE(+) = USERENV('LANG')
AND FTT.SOURCE_LANG(+) = USERENV('LANG')
AND ALK.LOOKUP_TYPE (+) = 'CODE_STATUS'
AND ALK.LOOKUP_CODE (+) = PARTY.STATUS
AND ALK1.LOOKUP_TYPE (+) = 'CUSTOMER_CATEGORY'
AND ALK1.ENABLED_FLAG (+) = 'Y'
AND ALK1.LOOKUP_CODE (+) = PARTY.CATEGORY_CODE
AND PARTY.PARTY_ID = USAGE.PARTY_ID
AND UPPER(USAGE.PARTY_USAGE_CODE) IN ('CUSTOMER'
, 'ORG_CONTACT')