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

VIEW: AR.HZ_LOCATION_PROFILES#

Object Details
Object Name: HZ_LOCATION_PROFILES#
Object Type: VIEW
Owner: AR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOCATION_PROFILE_ID NUMBER (15) Yes
LOCATION_ID NUMBER (15) Yes
ACTUAL_CONTENT_SOURCE VARCHAR2 (30) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE

VALIDATION_SST_FLAG VARCHAR2 (1) Yes
VALIDATION_STATUS_CODE VARCHAR2 (30)
DATE_VALIDATED DATE

ADDRESS1 VARCHAR2 (240) Yes
ADDRESS2 VARCHAR2 (240)
ADDRESS3 VARCHAR2 (240)
ADDRESS4 VARCHAR2 (240)
CITY VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
PROV_STATE_ADMIN_CODE VARCHAR2 (60)
COUNTY VARCHAR2 (60)
COUNTRY VARCHAR2 (2) Yes
OBJECT_VERSION_NUMBER NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

Query Text

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


SELECT LOCATION_PROFILE_ID
,      LOCATION_ID
,      ACTUAL_CONTENT_SOURCE
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      VALIDATION_SST_FLAG
,      VALIDATION_STATUS_CODE
,      DATE_VALIDATED
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      PROV_STATE_ADMIN_CODE
,      COUNTY
,      COUNTRY
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM AR.HZ_LOCATION_PROFILES#;

Dependencies

[top of page]

AR.HZ_LOCATION_PROFILES# references the following:

SchemaAR
TableHZ_LOCATION_PROFILES
AR.HZ_LOCATION_PROFILES# is referenced by following:

SchemaAPPS
SynonymHZ_LOCATION_PROFILES