View: CSP_RS_SHIP_TO_ADDRESSES_V

Product:	CSP - Spares Management
Description:	Resource ship to addresses view
Implementation/DBA Data:	APPS.CSP_RS_SHIP_TO_ADDRESSES_V

View Text

SELECT RCR.RESOURCE_TYPE
, RCR.RESOURCE_ID
, RCR.CUSTOMER_ID
, CAS.CUST_ACCT_SITE_ID
, CAS.PARTY_SITE_ID
, CSU.SITE_USE_ID
, CSU.SITE_USE_CODE
, CSU.PRIMARY_FLAG
, CSU.STATUS
, PLA.LOCATION_ID INV_LOC_ID
, HRL.ENTERED_BY
, HRL.ROW_ID
, HRL.LOCATION_CODE
, HRL.DESCRIPTION
, HRL.STYLE
, HRL.ADDRESS_STYLE
, HRL.ADDRESS_LINE_1
, HRL.ADDRESS_LINE_2
, HRL.ADDRESS_LINE_3
, HRL.TOWN_OR_CITY
, HRL.COUNTRY
, HRL.POSTAL_CODE
, HRL.REGION_1
, HRL.REGION_2
, HRL.REGION_3
, HRL.BILL_TO_SITE_FLAG
, HRL.DESIGNATED_RECEIVER_ID
, HRL.IN_ORGANIZATION_FLAG
, HRL.INACTIVE_DATE
, HRL.INVENTORY_ORGANIZATION_ID
, HRL.OFFICE_SITE_FLAG
, HRL.RECEIVING_SITE_FLAG
, HRL.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, HRL.SHIP_TO_LOCATION SHIP_TO_LOCATION
, HRL.SHIP_TO_SITE_FLAG
, HRL.TAX_NAME
, HRL.TELEPHONE_NUMBER_1
, HRL.TELEPHONE_NUMBER_2
, HRL.TELEPHONE_NUMBER_3
, HRL.LOC_INFORMATION13
, HRL.LOC_INFORMATION14
, HRL.LOC_INFORMATION15
, HRL.LOC_INFORMATION16
, HRL.LOC_INFORMATION17
, HRL.LOC_INFORMATION18
, HRL.LOC_INFORMATION19
, HRL.LOC_INFORMATION20
, HRL.LAST_UPDATE_DATE
, HRL.LAST_UPDATED_BY
, HRL.LAST_UPDATE_LOGIN
, HRL.CREATED_BY
, HRL.CREATION_DATE
, HRL.OBJECT_VERSION_NUMBER
, HRL.TP_HEADER_ID
, HRL.ECE_TP_LOCATION_CODE
, PS.LOCATION_ID SITE_LOC_ID
, HZL.TIME_ZONE
, HTV.NAME
, REPLACE(HTV.GLOBAL_TIMEZONE_NAME
, '%S'
, 'S')
, HRL.ATTRIBUTE1
, HRL.ATTRIBUTE2
, HRL.ATTRIBUTE3
, HRL.ATTRIBUTE4
, HRL.ATTRIBUTE5
, HRL.ATTRIBUTE6
, HRL.ATTRIBUTE7
, HRL.ATTRIBUTE8
, HRL.ATTRIBUTE9
, HRL.ATTRIBUTE10
, HRL.ATTRIBUTE11
, HRL.ATTRIBUTE12
, HRL.ATTRIBUTE13
, HRL.ATTRIBUTE14
, HRL.ATTRIBUTE15
, HRL.ATTRIBUTE16
, HRL.ATTRIBUTE17
, HRL.ATTRIBUTE18
, HRL.ATTRIBUTE19
, HRL.ATTRIBUTE20
, HRL.ATTRIBUTE_CATEGORY
FROM CSP_RS_CUST_RELATIONS RCR
, HZ_CUST_ACCT_SITES_ALL CAS
, HZ_CUST_SITE_USES_ALL CSU
, PO_LOCATION_ASSOCIATIONS_ALL PLA
, HR_LOCATIONS_V HRL
, HZ_PARTY_SITES PS
, HZ_LOCATIONS HZL
, HZ_TIMEZONES_VL HTV
WHERE RCR.CUSTOMER_ID = CAS.CUST_ACCOUNT_ID
AND CAS.CUST_ACCT_SITE_ID = CSU.CUST_ACCT_SITE_ID (+)
AND CSU.SITE_USE_CODE = 'SHIP_TO'
AND CSU.SITE_USE_ID = PLA.SITE_USE_ID
AND PLA.LOCATION_ID = HRL.LOCATION_ID
AND CAS.PARTY_SITE_ID = PS.PARTY_SITE_ID
AND PS.LOCATION_ID = HZL.LOCATION_ID
AND HZL.TIME_ZONE = HTV.TIMEZONE_ID (+) ORDER BY RCR.RESOURCE_TYPE
, RCR.RESOURCE_ID
, CAS.PARTY_SITE_ID

Columns