HR_BU_LOCATIONS

Details

Schema: FUSION
Object owner: PER
Object type: VIEW

Columns

Name
LOCATION_DETAILS_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE OBJECT_VERSION_NUMBER BUSINESS_GROUP_ID ACTIVE_STATUS LOCATION_ID MAIN_ADDRESS_ID TELEPHONE_NUMBER_1 MAINPHONE_COUNTRY_CODE1 MAINPHONE_AREA_CODE1 MAINPHONE_SUBSCRIBER_NUM1 MAINPHONE_EXTENSION1 TELEPHONE_NUMBER_2 FAX_COUNTRY_CODE2 FAX_AREA_CODE2 FAX_SUBSCRIBER_NUM2 FAX_EXTENSION2 TELEPHONE_NUMBER_3 OTHERPHONE_COUNTRY_CODE3 OTHERPHONE_AREA_CODE3 OTHERPHONE_SUBSCRIBER_NUM3 OTHERPHONE_EXTENSION3 OFFICIAL_LANGUAGE_CODE EMAIL_ADDRESS SHIP_TO_SITE_FLAG SHIP_TO_LOCATION_ID RECEIVING_SITE_FLAG BILL_TO_SITE_FLAG OFFICE_SITE_FLAG INVENTORY_ORGANIZATION_ID DESIGNATED_RECEIVER_ID GEO_HIERARCHY_NODE_ID GEO_HIERARCHY_NODE_VALUE ACTION_OCCURRENCE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 BUSINESS_UNIT SET_ID LOCATION_IMAGE_URL INTERNAL_LOCATION_CODE LOCATION_CODE LOCATION_NAME DESCRIPTION AC_LOCATION_CODE STYLE ADDRESS_LINE_1 ADDRESS_LINE_2 ADDRESS_LINE_3 ADDRESS_LINE_4 BUILDING FLOOR_NUMBER COUNTRY POSTAL_CODE LONG_POSTAL_CODE REGION_1 REGION_2 REGION_3 TOWN_OR_CITY DERIVED_LOCALE GEOMETRY LOC_INFORMATION13 LOC_INFORMATION14 LOC_INFORMATION15 LOC_INFORMATION16 LOC_INFORMATION17 LOC_INFORMATION18 LOC_INFORMATION19 LOC_INFORMATION20 LOC_INFORMATION21 LOC_INFORMATION22 ADD_INFORMATION11 ADD_INFORMATION12 ADD_INFORMATION13 ADD_INFORMATION14 ADD_INFORMATION15 ADD_INFORMATION16 ADD_INFORMATION17 ADD_INFORMATION18 ADD_INFORMATION19 ADD_INFORMATION20 TIMEZONE_CODE

Name

LOCATION_DETAILS_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

OBJECT_VERSION_NUMBER

BUSINESS_GROUP_ID

ACTIVE_STATUS

LOCATION_ID

MAIN_ADDRESS_ID

TELEPHONE_NUMBER_1

MAINPHONE_COUNTRY_CODE1

MAINPHONE_AREA_CODE1

MAINPHONE_SUBSCRIBER_NUM1

MAINPHONE_EXTENSION1

TELEPHONE_NUMBER_2

FAX_COUNTRY_CODE2

FAX_AREA_CODE2

FAX_SUBSCRIBER_NUM2

FAX_EXTENSION2

TELEPHONE_NUMBER_3

OTHERPHONE_COUNTRY_CODE3

OTHERPHONE_AREA_CODE3

OTHERPHONE_SUBSCRIBER_NUM3

OTHERPHONE_EXTENSION3

OFFICIAL_LANGUAGE_CODE

EMAIL_ADDRESS

SHIP_TO_SITE_FLAG

SHIP_TO_LOCATION_ID

RECEIVING_SITE_FLAG

BILL_TO_SITE_FLAG

OFFICE_SITE_FLAG

INVENTORY_ORGANIZATION_ID

DESIGNATED_RECEIVER_ID

GEO_HIERARCHY_NODE_ID

GEO_HIERARCHY_NODE_VALUE

ACTION_OCCURRENCE_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

BUSINESS_UNIT

SET_ID

LOCATION_IMAGE_URL

INTERNAL_LOCATION_CODE

LOCATION_CODE

LOCATION_NAME

DESCRIPTION

AC_LOCATION_CODE

STYLE

ADDRESS_LINE_1

ADDRESS_LINE_2

ADDRESS_LINE_3

ADDRESS_LINE_4

BUILDING

FLOOR_NUMBER

COUNTRY

POSTAL_CODE

LONG_POSTAL_CODE

REGION_1

REGION_2

REGION_3

TOWN_OR_CITY

DERIVED_LOCALE

GEOMETRY

LOC_INFORMATION13

LOC_INFORMATION14

LOC_INFORMATION15

LOC_INFORMATION16

LOC_INFORMATION17

LOC_INFORMATION18

LOC_INFORMATION19

LOC_INFORMATION20

LOC_INFORMATION21

LOC_INFORMATION22

ADD_INFORMATION11

ADD_INFORMATION12

ADD_INFORMATION13

ADD_INFORMATION14

ADD_INFORMATION15

ADD_INFORMATION16

ADD_INFORMATION17

ADD_INFORMATION18

ADD_INFORMATION19

ADD_INFORMATION20

TIMEZONE_CODE

Query

SQL_Statement
( SELECT loc."LOCATION_DETAILS_ID",loc."EFFECTIVE_START_DATE",loc."EFFECTIVE_END_DATE",loc."OBJECT_VERSION_NUMBER",loc."BUSINESS_GROUP_ID",loc."ACTIVE_STATUS",loc."LOCATION_ID",loc."MAIN_ADDRESS_ID",loc."TELEPHONE_NUMBER_1",loc."MAINPHONE_COUNTRY_CODE1",loc."MAINPHONE_AREA_CODE1",loc."MAINPHONE_SUBSCRIBER_NUM1",loc."MAINPHONE_EXTENSION1",loc."TELEPHONE_NUMBER_2",loc."FAX_COUNTRY_CODE2",loc."FAX_AREA_CODE2",loc."FAX_SUBSCRIBER_NUM2",loc."FAX_EXTENSION2",loc."TELEPHONE_NUMBER_3",loc."OTHERPHONE_COUNTRY_CODE3",loc."OTHERPHONE_AREA_CODE3",loc."OTHERPHONE_SUBSCRIBER_NUM3",loc."OTHERPHONE_EXTENSION3",loc."OFFICIAL_LANGUAGE_CODE",loc."EMAIL_ADDRESS",loc."SHIP_TO_SITE_FLAG",loc."SHIP_TO_LOCATION_ID",loc."RECEIVING_SITE_FLAG",loc."BILL_TO_SITE_FLAG",loc."OFFICE_SITE_FLAG",loc."INVENTORY_ORGANIZATION_ID",loc."DESIGNATED_RECEIVER_ID",loc."GEO_HIERARCHY_NODE_ID",loc."GEO_HIERARCHY_NODE_VALUE",loc."ACTION_OCCURRENCE_ID",loc."CREATED_BY",loc."CREATION_DATE",loc."LAST_UPDATED_BY",loc."LAST_UPDATE_DATE",loc."LAST_UPDATE_LOGIN",loc."ATTRIBUTE_CATEGORY",loc."ATTRIBUTE1",loc."ATTRIBUTE2",loc."ATTRIBUTE3",loc."ATTRIBUTE4",loc."ATTRIBUTE5",loc."ATTRIBUTE6",loc."ATTRIBUTE7",loc."ATTRIBUTE8",loc."ATTRIBUTE9",loc."ATTRIBUTE10",loc."ATTRIBUTE11",loc."ATTRIBUTE12",loc."ATTRIBUTE13",loc."ATTRIBUTE14",loc."ATTRIBUTE15",loc."ATTRIBUTE16",loc."ATTRIBUTE17",loc."ATTRIBUTE18",loc."ATTRIBUTE19",loc."ATTRIBUTE20",loc."ATTRIBUTE21",loc."ATTRIBUTE22",loc."ATTRIBUTE23",loc."ATTRIBUTE24",loc."ATTRIBUTE25",loc."ATTRIBUTE26",loc."ATTRIBUTE27",loc."ATTRIBUTE28",loc."ATTRIBUTE29",loc."ATTRIBUTE30", asm.determinant_value business_unit, loa.set_id, loa.location_image_url, loa.internal_location_code, lot.location_code, lot.location_name, lot.description, lot.ac_location_code, addr.country style, addr.address_line_1, addr.address_line_2, addr.address_line_3, addr.address_line_4, addr.building, addr.floor_number, addr.country, addr.postal_code, addr.long_postal_code, addr.region_1, addr.region_2, addr.region_3, addr.town_or_city, addr.derived_locale, addr.geometry, addr.addl_address_attribute1 loc_information13, addr.addl_address_attribute2 loc_information14, addr.addl_address_attribute3 loc_information15, addr.addl_address_attribute4 loc_information16, addr.addl_address_attribute5 loc_information17, null loc_information18, null loc_information19, null loc_information20, null loc_information21, null loc_information22, null add_information11, null add_information12, null add_information13, null add_information14, null add_information15, null add_information16, null add_information17, null add_information18, null add_information19, null add_information20, addr.timezone_code FROM per_location_details_f loc , per_location_details_f_tl lot,per_locations loa, fnd_setid_assignments asm ,per_addresses_f addr WHERE asm.determinant_type(+) = 'BU' AND asm.reference_group_name(+) ='PER_LOCATIONS' AND loa.set_id = asm.set_id(+) AND loc.location_id=loa.location_id AND loc.location_details_id = lot.location_details_id AND loc.effective_start_date = lot.effective_start_date AND loc.effective_end_date = lot.effective_end_date AND lot.language = userenv('LANG') and loc.main_address_id= addr.address_id AND loc.effective_start_date = addr.effective_start_date AND loc.effective_end_date = addr.effective_end_date AND trunc(sysdate) BETWEEN loc.effective_start_date and loc.effective_end_date)

SQL_Statement

(

SELECT loc."LOCATION_DETAILS_ID",loc."EFFECTIVE_START_DATE",loc."EFFECTIVE_END_DATE",loc."OBJECT_VERSION_NUMBER",loc."BUSINESS_GROUP_ID",loc."ACTIVE_STATUS",loc."LOCATION_ID",loc."MAIN_ADDRESS_ID",loc."TELEPHONE_NUMBER_1",loc."MAINPHONE_COUNTRY_CODE1",loc."MAINPHONE_AREA_CODE1",loc."MAINPHONE_SUBSCRIBER_NUM1",loc."MAINPHONE_EXTENSION1",loc."TELEPHONE_NUMBER_2",loc."FAX_COUNTRY_CODE2",loc."FAX_AREA_CODE2",loc."FAX_SUBSCRIBER_NUM2",loc."FAX_EXTENSION2",loc."TELEPHONE_NUMBER_3",loc."OTHERPHONE_COUNTRY_CODE3",loc."OTHERPHONE_AREA_CODE3",loc."OTHERPHONE_SUBSCRIBER_NUM3",loc."OTHERPHONE_EXTENSION3",loc."OFFICIAL_LANGUAGE_CODE",loc."EMAIL_ADDRESS",loc."SHIP_TO_SITE_FLAG",loc."SHIP_TO_LOCATION_ID",loc."RECEIVING_SITE_FLAG",loc."BILL_TO_SITE_FLAG",loc."OFFICE_SITE_FLAG",loc."INVENTORY_ORGANIZATION_ID",loc."DESIGNATED_RECEIVER_ID",loc."GEO_HIERARCHY_NODE_ID",loc."GEO_HIERARCHY_NODE_VALUE",loc."ACTION_OCCURRENCE_ID",loc."CREATED_BY",loc."CREATION_DATE",loc."LAST_UPDATED_BY",loc."LAST_UPDATE_DATE",loc."LAST_UPDATE_LOGIN",loc."ATTRIBUTE_CATEGORY",loc."ATTRIBUTE1",loc."ATTRIBUTE2",loc."ATTRIBUTE3",loc."ATTRIBUTE4",loc."ATTRIBUTE5",loc."ATTRIBUTE6",loc."ATTRIBUTE7",loc."ATTRIBUTE8",loc."ATTRIBUTE9",loc."ATTRIBUTE10",loc."ATTRIBUTE11",loc."ATTRIBUTE12",loc."ATTRIBUTE13",loc."ATTRIBUTE14",loc."ATTRIBUTE15",loc."ATTRIBUTE16",loc."ATTRIBUTE17",loc."ATTRIBUTE18",loc."ATTRIBUTE19",loc."ATTRIBUTE20",loc."ATTRIBUTE21",loc."ATTRIBUTE22",loc."ATTRIBUTE23",loc."ATTRIBUTE24",loc."ATTRIBUTE25",loc."ATTRIBUTE26",loc."ATTRIBUTE27",loc."ATTRIBUTE28",loc."ATTRIBUTE29",loc."ATTRIBUTE30",

asm.determinant_value business_unit,

loa.set_id,

loa.location_image_url,

loa.internal_location_code,

lot.location_code,

lot.location_name,

lot.description,

lot.ac_location_code,

addr.country style,

addr.address_line_1,

addr.address_line_2,

addr.address_line_3,

addr.address_line_4,

addr.building,

addr.floor_number,

addr.country,

addr.postal_code,

addr.long_postal_code,

addr.region_1,

addr.region_2,

addr.region_3,

addr.town_or_city,

addr.derived_locale,

addr.geometry,

addr.addl_address_attribute1 loc_information13,

addr.addl_address_attribute2 loc_information14,

addr.addl_address_attribute3 loc_information15,

addr.addl_address_attribute4 loc_information16,

addr.addl_address_attribute5 loc_information17,

null loc_information18,

null loc_information19,

null loc_information20,

null loc_information21,

null loc_information22,

null add_information11,

null add_information12,

null add_information13,

null add_information14,

null add_information15,

null add_information16,

null add_information17,

null add_information18,

null add_information19,

null add_information20,

addr.timezone_code

FROM per_location_details_f loc , per_location_details_f_tl lot,per_locations loa, fnd_setid_assignments asm ,per_addresses_f addr

WHERE asm.determinant_type(+) = 'BU'

AND asm.reference_group_name(+) ='PER_LOCATIONS'

AND loa.set_id = asm.set_id(+)

AND loc.location_id=loa.location_id

AND loc.location_details_id = lot.location_details_id

AND loc.effective_start_date = lot.effective_start_date

AND loc.effective_end_date = lot.effective_end_date

AND lot.language = userenv('LANG')

and loc.main_address_id= addr.address_id

AND loc.effective_start_date = addr.effective_start_date

AND loc.effective_end_date = addr.effective_end_date

AND trunc(sysdate) BETWEEN loc.effective_start_date and loc.effective_end_date)