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

VIEW: APPS.HXT_ERRORS_V

Object Details
Object Name: HXT_ERRORS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewHXT.HXT_ERRORS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER (15) Yes ID column from hxt_errors
ERROR_MSG VARCHAR2 (240) Yes Error Message from hxt_errors view
LOCATION VARCHAR2 (120) Yes Location column from hxt_errors view
ERR_TYPE VARCHAR2 (3)
ERR_TYPE from hxt_errors view
TIM_ID NUMBER (15)
TIM_ID from hxt_errors view
HRW_ID NUMBER (15)
HRW_ID from hxt_errors view
PTP_ID NUMBER (15) Yes PTP_ID from hxt_errors view
ORA_MESSAGE VARCHAR2 (120)
ORA_MESSAGE from hxt_errors view
PPB_ID NUMBER (15) Yes PPB_ID from hxt_errors view
PAYROLL_ID NUMBER (15) Yes PAYROLL_ID from hxt_errors view
PERSON_ID NUMBER (10) Yes PERSON_ID from hxt_errors view
EFFECTIVE_END_DATE DATE
Yes EFFECTIVE_END_DATE from hxt_errors view
EFFECTIVE_START_DATE DATE
Yes EFFECTIVE_START_DATE from hxt_errors view
CREATED_BY NUMBER (15)
CREATED_BY column from hxt_errors
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATED_BY column from hxt_errors view
LAST_UPDATE_DATE DATE

LAST_UPDATE_DATE column from hxt_errors
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_LOGIN from hxt_errors view
CREATION_DATE DATE

CREATION_DATE field from hxt_errors view
PERIOD_END DATE
Yes PERIOD_END column from hxt_errors view
PAYROLL VARCHAR2 (80) Yes PAYROLL_NAME from pay_payrolls_f
EMP_NUMBER VARCHAR2 (30)
EMPLOYEE_NUMBER from per_people_f
FULL_NAME VARCHAR2 (240)
FULL_NAME from per_people_f
Query Text

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


SELECT ID
,      ERROR_MSG
,      LOCATION
,      ERR_TYPE
,      TIM_ID
,      HRW_ID
,      PTP_ID
,      ORA_MESSAGE
,      PPB_ID
,      PAYROLL_ID
,      PERSON_ID
,      EFFECTIVE_END_DATE
,      EFFECTIVE_START_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      PERIOD_END
,      PAYROLL
,      EMP_NUMBER
,      FULL_NAME
FROM APPS.HXT_ERRORS_V;

Dependencies

[top of page]

APPS.HXT_ERRORS_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewHXT_ERRORS
ViewHXT_TIMECARDS
ViewPAY_PAYROLLS_F
ViewPER_PEOPLE_F
SynonymPER_TIME_PERIODS
APPS.HXT_ERRORS_V is referenced by following:

SchemaPUBLIC
SynonymHXT_ERRORS_V