WSH_SHIP_FROM_ORG_LOCATIONS

Details

Schema: FUSION
Object owner: WSH
Object type: VIEW

Query

SQL_Statement
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, INV_ORG_PARAMETERS_V MP, WSH_LOCATIONS_V 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'

SQL_Statement

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, INV_ORG_PARAMETERS_V MP, WSH_LOCATIONS_V 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'