Product: | WSH - Shipping Execution |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WSH_SHIP_FROM_ORG_LOCATIONS_V |
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
, 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.LOCATION_ID=WHRL.SOURCE_LOCATION_ID (+)
AND WHRL.LOCATION_SOURCE_CODE (+) ='HR'