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.AST_LM_PER_EXPAND_V

Source

View Text - Preformatted


SELECT PARTY.PARTY_ID , SITE.PARTY_SITE_ID, PARTY.PARTY_NUMBER , ACCOUNT.ACCOUNT_NUMBER , account.cust_account_id , PARTY.PERSON_FIRST_NAME , PARTY.PERSON_MIDDLE_NAME , PARTY.PERSON_LAST_NAME , CPT.PHONE_COUNTRY_CODE , CPT.PHONE_AREA_CODE , CPT.PHONE_NUMBER , CPT.PHONE_EXTENSION , NVL(CPT.PHONE_COUNTRY_CODE, ' ')||'-'|| NVL(CPT.PHONE_AREA_CODE, ' ') ||'-'|| CPT.PHONE_NUMBER||' '|| CPT.PHONE_EXTENSION , CPT.PHONE_AREA_CODE|| CPT.PHONE_NUMBER , PARTY.ADDRESS1||' '|| PARTY.ADDRESS2||' '|| PARTY.ADDRESS3||' '|| PARTY.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 , FTT.TERRITORY_SHORT_NAME , CPT2.EMAIL_ADDRESS, PARTY.JGZZ_FISCAL_CODE , PARTY.STATUS , ALK.MEANING , 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 , HZ_CONTACT_POINTS CPT , HZ_CONTACT_POINTS CPT2 , AR_LOOKUPS ALK , FND_TERRITORIES_TL FTT , HZ_PARTY_SITES SITE , HZ_LOCATIONS LOC , HZ_CUST_ACCOUNTS ACCOUNT , FND_TIMEZONES_B TIME WHERE SITE.LOCATION_ID = LOC.LOCATION_ID(+) AND TIME.UPGRADE_TZ_ID(+) = LOC.TIMEZONE_ID AND party.party_id = site.party_id(+) AND site.IDENTIFYING_ADDRESS_FLAG(+) = 'Y' AND PARTY.PARTY_ID = CPT.OWNER_TABLE_ID(+) AND CPT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' AND CPT.CONTACT_POINT_TYPE(+) = 'PHONE' AND PARTY.PARTY_ID = CPT2.OWNER_TABLE_ID(+) AND CPT2.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' AND CPT2.CONTACT_POINT_TYPE(+) = 'EMAIL' AND PARTY.PARTY_TYPE = 'PERSON' AND ALK.LOOKUP_TYPE (+) = 'CODE_STATUS' AND ALK.LOOKUP_CODE (+) = PARTY.STATUS AND FTT.LANGUAGE(+) = userenv('LANG') AND FTT.SOURCE_LANG(+) = userenv('LANG') AND loc.COUNTRY = FTT.TERRITORY_CODE(+) AND ACCOUNT.PARTY_ID(+) = PARTY.PARTY_ID AND ACCOUNT.STATUS(+) = 'A' AND CPT.STATUS(+) = 'A' AND CPT2.STATUS(+) = 'A' AND PARTY.STATUS in ('A','I')

View Text - HTML Formatted

SELECT PARTY.PARTY_ID
, SITE.PARTY_SITE_ID
, PARTY.PARTY_NUMBER
, ACCOUNT.ACCOUNT_NUMBER
, ACCOUNT.CUST_ACCOUNT_ID
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_MIDDLE_NAME
, PARTY.PERSON_LAST_NAME
, CPT.PHONE_COUNTRY_CODE
, CPT.PHONE_AREA_CODE
, CPT.PHONE_NUMBER
, CPT.PHONE_EXTENSION
, NVL(CPT.PHONE_COUNTRY_CODE
, ' ')||'-'|| NVL(CPT.PHONE_AREA_CODE
, ' ') ||'-'|| CPT.PHONE_NUMBER||' '|| CPT.PHONE_EXTENSION
, CPT.PHONE_AREA_CODE|| CPT.PHONE_NUMBER
, PARTY.ADDRESS1||' '|| PARTY.ADDRESS2||' '|| PARTY.ADDRESS3||' '|| PARTY.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
, FTT.TERRITORY_SHORT_NAME
, CPT2.EMAIL_ADDRESS
, PARTY.JGZZ_FISCAL_CODE
, PARTY.STATUS
, ALK.MEANING
, 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
, HZ_CONTACT_POINTS CPT
, HZ_CONTACT_POINTS CPT2
, AR_LOOKUPS ALK
, FND_TERRITORIES_TL FTT
, HZ_PARTY_SITES SITE
, HZ_LOCATIONS LOC
, HZ_CUST_ACCOUNTS ACCOUNT
, FND_TIMEZONES_B TIME
WHERE SITE.LOCATION_ID = LOC.LOCATION_ID(+)
AND TIME.UPGRADE_TZ_ID(+) = LOC.TIMEZONE_ID
AND PARTY.PARTY_ID = SITE.PARTY_ID(+)
AND SITE.IDENTIFYING_ADDRESS_FLAG(+) = 'Y'
AND PARTY.PARTY_ID = CPT.OWNER_TABLE_ID(+)
AND CPT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND CPT.CONTACT_POINT_TYPE(+) = 'PHONE'
AND PARTY.PARTY_ID = CPT2.OWNER_TABLE_ID(+)
AND CPT2.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND CPT2.CONTACT_POINT_TYPE(+) = 'EMAIL'
AND PARTY.PARTY_TYPE = 'PERSON'
AND ALK.LOOKUP_TYPE (+) = 'CODE_STATUS'
AND ALK.LOOKUP_CODE (+) = PARTY.STATUS
AND FTT.LANGUAGE(+) = USERENV('LANG')
AND FTT.SOURCE_LANG(+) = USERENV('LANG')
AND LOC.COUNTRY = FTT.TERRITORY_CODE(+)
AND ACCOUNT.PARTY_ID(+) = PARTY.PARTY_ID
AND ACCOUNT.STATUS(+) = 'A'
AND CPT.STATUS(+) = 'A'
AND CPT2.STATUS(+) = 'A'
AND PARTY.STATUS IN ('A'
, 'I')