VIEW: APPS.CSP_RS_SHIP_TO_ADDRESSES_ALL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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