Product: | AR - Receivables |
---|---|
Description: | Customer address information |
Implementation/DBA Data: | Not implemented in this database |
SELECT ACCT_SITE.ROWID
, PARTY_SITE.PARTY_SITE_ID
, PARTY_SITE.PARTY_ID
, LOC.LOCATION_ID
, ACCT_SITE.KEY_ACCOUNT_FLAG
, ACCT_SITE.PROGRAM_UPDATE_DATE
, ACCT_SITE.TERRITORY_ID
, LOC.ADDRESS_KEY
, ACCT_SITE.BILL_TO_FLAG
, ACCT_SITE.MARKET_FLAG
, ACCT_SITE.SHIP_TO_FLAG
, LOC.ATTRIBUTE11
, LOC.ATTRIBUTE12
, LOC.ATTRIBUTE13
, LOC.ATTRIBUTE14
, LOC.ATTRIBUTE15
, LOC_ASSIGN.LOC_ID /* LOCATION_ID */
, ACCT_SITE.SERVICE_TERRITORY_ID
, ACCT_SITE.PRIMARY_SPECIALIST_ID
, ACCT_SITE.SECONDARY_SPECIALIST_ID
, ACCT_SITE.CUSTOMER_CATEGORY_CODE
, NULL /* CUSTOMER_GROUP_CODE */
, NULL /* CUSTOMER_SUBGROUP_CODE */
, NULL /* REFERENCE_USE_FLAG */
, NULL /* ANALYSIS_FY */
, NULL /* FISCAL_YEAREND_MONTH */
, TO_NUMBER(NULL) /* NET_WORTH */
, TO_NUMBER(NULL) /* NUM_OF_EMPLOYEES */
, TO_NUMBER(NULL) /* POTENTIAL_REVENUE_CURR_FY */
, TO_NUMBER(NULL) /* POTENTIAL_REVENUE_NEXT_FY */
, NULL /* RANK */
, NULL /* COMPETITOR_FLAG */
, NULL /* THIRD_PARTY_FLAG */
, TO_NUMBER(NULL) /* YEAR_ESTABLISHED */
, NULL /* DO_NOT_MAIL_FLAG */
, LOC.ADDRESS_STYLE
, LOC.LANGUAGE
, ACCT_SITE.CUST_ACCT_SITE_ID /* ADDRESS_ID */
, ACCT_SITE.LAST_UPDATE_DATE
, ACCT_SITE.LAST_UPDATED_BY
, ACCT_SITE.CREATION_DATE
, ACCT_SITE.CREATED_BY
, ACCT_SITE.CUST_ACCOUNT_ID /* CUSTOMER_ID */
, ACCT_SITE.STATUS
, ACCT_SITE.ORIG_SYSTEM_REFERENCE
, ACCT_SITE.ORG_ID
, LOC.COUNTRY
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.POSTAL_CODE
, LOC.STATE
, LOC.PROVINCE
, LOC.COUNTY
, ACCT_SITE.LAST_UPDATE_LOGIN
, ACCT_SITE.ATTRIBUTE_CATEGORY
, ACCT_SITE.ATTRIBUTE1
, ACCT_SITE.ATTRIBUTE2
, ACCT_SITE.ATTRIBUTE3
, ACCT_SITE.ATTRIBUTE4
, ACCT_SITE.ATTRIBUTE5
, ACCT_SITE.ATTRIBUTE6
, ACCT_SITE.ATTRIBUTE7
, ACCT_SITE.ATTRIBUTE8
, ACCT_SITE.ATTRIBUTE9
, ACCT_SITE.ATTRIBUTE10
, ACCT_SITE.REQUEST_ID
, ACCT_SITE.PROGRAM_APPLICATION_ID
, ACCT_SITE.PROGRAM_ID
, LOC.ADDRESS_LINES_PHONETIC
, ACCT_SITE.GLOBAL_ATTRIBUTE1
, ACCT_SITE.GLOBAL_ATTRIBUTE2
, ACCT_SITE.GLOBAL_ATTRIBUTE3
, ACCT_SITE.GLOBAL_ATTRIBUTE4
, ACCT_SITE.GLOBAL_ATTRIBUTE5
, ACCT_SITE.GLOBAL_ATTRIBUTE6
, ACCT_SITE.GLOBAL_ATTRIBUTE7
, ACCT_SITE.GLOBAL_ATTRIBUTE8
, ACCT_SITE.GLOBAL_ATTRIBUTE9
, ACCT_SITE.GLOBAL_ATTRIBUTE10
, ACCT_SITE.GLOBAL_ATTRIBUTE11
, ACCT_SITE.GLOBAL_ATTRIBUTE12
, ACCT_SITE.GLOBAL_ATTRIBUTE13
, ACCT_SITE.GLOBAL_ATTRIBUTE14
, ACCT_SITE.GLOBAL_ATTRIBUTE15
, ACCT_SITE.GLOBAL_ATTRIBUTE16
, ACCT_SITE.GLOBAL_ATTRIBUTE17
, ACCT_SITE.GLOBAL_ATTRIBUTE18
, ACCT_SITE.GLOBAL_ATTRIBUTE19
, ACCT_SITE.GLOBAL_ATTRIBUTE_CATEGORY
, ACCT_SITE.TP_HEADER_ID /* TP_HEADER_ID */
, ACCT_SITE.WH_UPDATE_DATE
, ACCT_SITE.GLOBAL_ATTRIBUTE20
, ACCT_SITE.ECE_TP_LOCATION_CODE
, LOC.SALES_TAX_GEOCODE
, LOC.SALES_TAX_INSIDE_CITY_LIMITS
, ACCT_SITE.TERRITORY /* TERRITORY */
, ACCT_SITE.TRANSLATED_CUSTOMER_NAME /* TRANSLATED_CUSTOMER_NAME */
, ACCT_SITE.ADDRESS_TEXT
, PARTY_SITE.PARTY_SITE_NUMBER
, PARTY_SITE.IDENTIFYING_ADDRESS_FLAG
, ACCT_SITE.ATTRIBUTE16
, ACCT_SITE.ATTRIBUTE17
, ACCT_SITE.ATTRIBUTE18
, ACCT_SITE.ATTRIBUTE19
, ACCT_SITE.ATTRIBUTE20
, PARTY_SITE.LAST_UPDATE_DATE
, LOC.LAST_UPDATE_DATE
, PARTY_SITE.ADDRESSEE
FROM HZ_PARTY_SITES PARTY_SITE
, HZ_LOC_ASSIGNMENTS LOC_ASSIGN
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
AND NVL(ACCT_SITE.ORG_ID
, -99) = NVL(LOC_ASSIGN.ORG_ID
, -99)