VIEW: APPS.WSH_SHIP_FROM_LOCATIONS_V

Source

View Text - Preformatted

SELECT WHRL.wsh_location_id wsh_location_id, WHRL.ui_location_code ui_location_code, WHRL.location_code || ':' || nvl(whrl.city,substrb(whrl.address1,1,60)) ui_short_location_code, whrl.address1 Address1, whrl.address2 Address2, whrl.address3 Address3, whrl.address4 Address4, whrl.city City, whrl.postal_code Postal_Code, whrl.country Country, whrl.state State, whrl.province Province, whrl.county County, WHRL.source_location_id source_location_id, whrl.inactive_date, HOU.ORGANIZATION_ID ORGANIZATION_ID, HOU.BUSINESS_GROUP_ID, HOU.DATE_FROM USER_DEFINITION_ENABLE_DATE, HOU.DATE_TO DISABLE_DATE, MP.ORGANIZATION_CODE ORGANIZATION_CODE, HOU.NAME ORGANIZATION_NAME, HOU.location_id, HOI2.org_information1 set_of_books_id FROM HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI1, HR_ORGANIZATION_INFORMATION HOI2, MTL_PARAMETERS MP, hr_locations_all hrl, WSH_LOCATIONS whrl WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID (+) AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID (+) AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID (+) AND HOI1.ORG_INFORMATION1 (+) = 'INV' AND HOI1.ORG_INFORMATION2 (+) = 'Y' AND HOI1.ORG_INFORMATION_CONTEXT (+) = 'CLASS' and HOI2.ORG_INFORMATION_CONTEXT (+) = 'Accounting Information' and Hou.organization_id(+) =hrl.inventory_organization_id and hrl.location_id=whrl.source_location_id and Whrl.location_source_code ='HR'

View Text - HTML Formatted

SELECT WHRL.WSH_LOCATION_ID WSH_LOCATION_ID
, WHRL.UI_LOCATION_CODE UI_LOCATION_CODE
, WHRL.LOCATION_CODE || ':' || NVL(WHRL.CITY
, SUBSTRB(WHRL.ADDRESS1
, 1
, 60)) UI_SHORT_LOCATION_CODE
, WHRL.ADDRESS1 ADDRESS1
, WHRL.ADDRESS2 ADDRESS2
, WHRL.ADDRESS3 ADDRESS3
, WHRL.ADDRESS4 ADDRESS4
, WHRL.CITY CITY
, WHRL.POSTAL_CODE POSTAL_CODE
, WHRL.COUNTRY COUNTRY
, WHRL.STATE STATE
, WHRL.PROVINCE PROVINCE
, WHRL.COUNTY COUNTY
, WHRL.SOURCE_LOCATION_ID SOURCE_LOCATION_ID
, WHRL.INACTIVE_DATE
, HOU.ORGANIZATION_ID ORGANIZATION_ID
, HOU.BUSINESS_GROUP_ID
, HOU.DATE_FROM USER_DEFINITION_ENABLE_DATE
, HOU.DATE_TO DISABLE_DATE
, MP.ORGANIZATION_CODE ORGANIZATION_CODE
, HOU.NAME ORGANIZATION_NAME
, HOU.LOCATION_ID
, HOI2.ORG_INFORMATION1 SET_OF_BOOKS_ID
FROM HR_ORGANIZATION_UNITS HOU
, HR_ORGANIZATION_INFORMATION HOI1
, HR_ORGANIZATION_INFORMATION HOI2
, MTL_PARAMETERS MP
, HR_LOCATIONS_ALL HRL
, WSH_LOCATIONS WHRL
WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID (+)
AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID (+)
AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID (+)
AND HOI1.ORG_INFORMATION1 (+) = 'INV'
AND HOI1.ORG_INFORMATION2 (+) = 'Y'
AND HOI1.ORG_INFORMATION_CONTEXT (+) = 'CLASS'
AND HOI2.ORG_INFORMATION_CONTEXT (+) = 'ACCOUNTING INFORMATION'
AND HOU.ORGANIZATION_ID(+) =HRL.INVENTORY_ORGANIZATION_ID
AND HRL.LOCATION_ID=WHRL.SOURCE_LOCATION_ID
AND WHRL.LOCATION_SOURCE_CODE ='HR'