DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HR_LOCATIONS_ALL_LOV_V

Object Details
Object Name: HR_LOCATIONS_ALL_LOV_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_LOCATIONS_ALL_LOV_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


HR_LOCATIONS_LOV_V is a view used by the Web Offers offer page. It
selects locations that the hiring manger can choose for a candidate. It does not include TCA locations.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LOCATION_ID NUMBER (15) Yes location identifier
LOCATION_CODE VARCHAR2 (60) Yes location code
LOCATION_USE CHAR (2)
location usage
BUSINESS_GROUP_ID NUMBER (15)
business group
DESCRIPTION VARCHAR2 (240)
description of organization
INACTIVE_DATE DATE

inactive date
SHIP_TO_LOCATION_ID NUMBER (15)
ship-to location
SHIP_TO_SITE_FLAG VARCHAR2 (30)
ship-to-site flag
STYLE VARCHAR2 (7)
address style
ADDRESS VARCHAR2 (1208)
address
TELEPHONE_NUMBER_1 VARCHAR2 (60)
telephone number
TELEPHONE_NUMBER_2 VARCHAR2 (60)
telephone number
TELEPHONE_NUMBER_3 VARCHAR2 (60)
telephone number
OBJECT_VERSION_NUMBER NUMBER (9)
internal used by datetrack
TIMEZONE_CODE VARCHAR2 (50)
Time Zone Code
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOCATION_ID
,      LOCATION_CODE
,      LOCATION_USE
,      BUSINESS_GROUP_ID
,      DESCRIPTION
,      INACTIVE_DATE
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_SITE_FLAG
,      STYLE
,      ADDRESS
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      TELEPHONE_NUMBER_3
,      OBJECT_VERSION_NUMBER
,      TIMEZONE_CODE
FROM APPS.HR_LOCATIONS_ALL_LOV_V;

Dependencies

[top of page]

APPS.HR_LOCATIONS_ALL_LOV_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL
SynonymHR_LOCATIONS_ALL_TL

APPS.HR_LOCATIONS_ALL_LOV_V is not referenced by any database object