Skip to content

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

VIEW: HR.HR_DM_LOADER_PHASE_ITEMS#

Object Details
Object Name: HR_DM_LOADER_PHASE_ITEMS#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOADER_PHASE_ITEM_ID NUMBER (15) Yes
DA_PHASE_ITEM_ID NUMBER (15) Yes
UA_PHASE_ITEM_ID NUMBER (15) Yes
LOADER_NAME VARCHAR2 (30) Yes
LOADER_CONC_PROGRAM VARCHAR2 (30) Yes
LOADER_CONFIG_FILE VARCHAR2 (30) Yes
LOADER_APPLICATION VARCHAR2 (50) Yes
APPLICATION_ID NUMBER (15) Yes
FILENAME VARCHAR2 (30)
PARAMETER_1 VARCHAR2 (100)
PARAMETER_2 VARCHAR2 (100)
PARAMETER_3 VARCHAR2 (100)
PARAMETER_4 VARCHAR2 (100)
PARAMETER_5 VARCHAR2 (100)
PARAMETER_6 VARCHAR2 (100)
PARAMETER_7 VARCHAR2 (100)
PARAMETER_8 VARCHAR2 (100)
PARAMETER_9 VARCHAR2 (100)
PARAMETER_10 VARCHAR2 (100)
CUSTOM_CODE_SPECIFIED VARCHAR2 (1) Yes
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

SECURITY_GROUP_ID NUMBER (15)
Query Text

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


SELECT LOADER_PHASE_ITEM_ID
,      DA_PHASE_ITEM_ID
,      UA_PHASE_ITEM_ID
,      LOADER_NAME
,      LOADER_CONC_PROGRAM
,      LOADER_CONFIG_FILE
,      LOADER_APPLICATION
,      APPLICATION_ID
,      FILENAME
,      PARAMETER_1
,      PARAMETER_2
,      PARAMETER_3
,      PARAMETER_4
,      PARAMETER_5
,      PARAMETER_6
,      PARAMETER_7
,      PARAMETER_8
,      PARAMETER_9
,      PARAMETER_10
,      CUSTOM_CODE_SPECIFIED
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SECURITY_GROUP_ID
FROM HR.HR_DM_LOADER_PHASE_ITEMS#;

Dependencies

[top of page]

HR.HR_DM_LOADER_PHASE_ITEMS# references the following:

SchemaHR
TableHR_DM_LOADER_PHASE_ITEMS
HR.HR_DM_LOADER_PHASE_ITEMS# is referenced by following:

SchemaAPPS
SynonymHR_DM_LOADER_PHASE_ITEMS
TriggerHR_DM_LOADER_PHASE_ITEMS_WHO