[Home] [Help] [Dependency Information]
Object Name: | HXT_ERRORS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | HXT.HXT_ERRORS_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.HXT_ERRORS_V is not referenced by any database object
|
|
|