View: HRFV_US_LOCATIONS

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_US_LOCATIONS

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, LOCT.DESCRIPTION LOCATION_DESCRIPTION
, LOC.ADDRESS_LINE_1 ADDRESS_LINE_1
, LOC.ADDRESS_LINE_2 ADDRESS_LINE_2
, LOC.ADDRESS_LINE_3 ADDRESS_LINE_3
, LOC.TOWN_OR_CITY CITY
, LOC.REGION_1 COUNTY
, HR_BIS.BIS_DECODE_LOOKUP('US_STATE'
, LOC.REGION_2) STATE_NAME
, LOC.REGION_2 STATE_CODE
, LOC.COUNTRY COUNTRY
, LOC.POSTAL_CODE ZIP_CODE
, LOC.TELEPHONE_NUMBER_1 TELEPHONE_NUMBER_1
, LOC.TELEPHONE_NUMBER_2 TELEPHONE_NUMBER_2
, LOC.TELEPHONE_NUMBER_3 TELEPHONE_NUMBER_3
, LOC.INACTIVE_DATE INACTIVE_DATE
, LOC.STYLE ADDRESS_STYLE
, LOC.TAX_NAME DEFAULT_TAX_CODE
, LOC2T.LOCATION_CODE SHIP_TO_LOCATION
, PEO.FULL_NAME DESIGNATED_RECEIVER
, ORGT.NAME INVENTORY_ORGANIZATION
, '_LA:LOC.BILL_TO_SITE_FLAG:HR_LOOKUPS:YES_NO:MEANING' BILL_TO_SITE_FLAG
, '_LA:LOC.IN_ORGANIZATION_FLAG:HR_LOOKUPS:YES_NO:MEANING' INTERNAL_SITE_FLAG
, '_LA:LOC.RECEIVING_SITE_FLAG:HR_LOOKUPS:YES_NO:MEANING' RECEIVING_SITE_FLAG
, '_LA:LOC.OFFICE_SITE_FLAG:HR_LOOKUPS:YES_NO:MEANING' OFFICE_SITE_FLAG
, '_LA:LOC.SHIP_TO_SITE_FLAG:HR_LOOKUPS:YES_NO:MEANING' SHIP_TO_LOCATION_FLAG
, '_DF:PER:HR_LOCATIONS:LOC'
, LOC.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LOC.DESIGNATED_RECEIVER_ID DESIGNATED_RECEIVER_ID
, LOC.INVENTORY_ORGANIZATION_ID INVENTORY_ORGANIZATION_ID
, LOC.LOCATION_ID LOCATION_ID
, LOC.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
FROM HR_ALL_ORGANIZATION_UNITS BGR
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, PER_PEOPLE_X PEO
, HR_LOCATIONS_ALL_TL LOC2T
, HR_LOCATIONS_ALL_TL LOCT
, HR_LOCATIONS_ALL LOC
WHERE LOC.LOCATION_ID = LOCT.LOCATION_ID
AND LOCT.LANGUAGE = USERENV('LANG')
AND LOC.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID (+)
AND BGR.ORGANIZATION_ID = BGRT.ORGANIZATION_ID (+)
AND DECODE(BGRT.ORGANIZATION_ID
, NULL
, 'X'
, BGRT.LANGUAGE) = DECODE(BGRT.ORGANIZATION_ID
, NULL
, 'X'
, USERENV('LANG'))
AND LOC.SHIP_TO_LOCATION_ID = LOC2T.LOCATION_ID (+)
AND LOC2T.LANGUAGE (+) = USERENV('LANG')
AND LOC.DESIGNATED_RECEIVER_ID = PEO.PERSON_ID (+)
AND LOC.INVENTORY_ORGANIZATION_ID = ORGT.ORGANIZATION_ID (+)
AND ORGT.LANGUAGE (+) = USERENV('LANG')
AND LOC.STYLE = 'US'
AND (LOC.BUSINESS_GROUP_ID IS NULL OR HR_BIS.GET_SEC_PROFILE_BG_ID IS NULL OR LOC.BUSINESS_GROUP_ID = HR_BIS.GET_SEC_PROFILE_BG_ID) WITH READ ONLY

Columns