eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: HR.GHR_PA_INTERFACE_ERR_DTLS#

Object Details

Object Name:	GHR_PA_INTERFACE_ERR_DTLS#
Object Type:	VIEW
Owner:	HR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PA_INTERFACE_ERR_DTL_ID	NUMBER	(15)	Yes
EXT_REQUEST_ID	NUMBER	(15)
RESULT_ID	NUMBER	(15)
RESULT_DTL_ID	NUMBER	(15)
RECORD_ID	NUMBER	(15)
BUSINESS_GROUP_ID	NUMBER	(15)
PERSON_ID	NUMBER	(15)
ASSIGNMENT_ID	NUMBER	(15)
PA_REQUEST_ID	NUMBER	(15)
ALT_PA_REQUEST_ID	NUMBER	(15)
ERR_SSN_NO	VARCHAR2	(30)
ERR_AGENCY	VARCHAR2	(30)
ERR_EMP_OFF	VARCHAR2	(30)
ERR_DEPT_CODE	VARCHAR2	(30)
ERR_DOC_TYPE	VARCHAR2	(30)
ERR_PAY_PERIOD	VARCHAR2	(30)
ERR_AUTH_DT	VARCHAR2	(16)
NAT_ACT_1ST_3_POS	VARCHAR2	(3)
NAT_ACT_2ND_3_POS	VARCHAR2	(3)
ERR_EFF_DT	VARCHAR2	(16)
ERR_BATCH_NO	VARCHAR2	(20)
ERR_OPER_CODE	VARCHAR2	(30)
ERROR_CODE	VARCHAR2	(20)
ERROR_MSG	VARCHAR2	(50)
ERROR_ELEMENT_NAME	VARCHAR2	(30)
ERROR_ELEM_CONTENT	VARCHAR2	(30)
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes

Query Text

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


SELECT PA_INTERFACE_ERR_DTL_ID
,      EXT_REQUEST_ID
,      RESULT_ID
,      RESULT_DTL_ID
,      RECORD_ID
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      PA_REQUEST_ID
,      ALT_PA_REQUEST_ID
,      ERR_SSN_NO
,      ERR_AGENCY
,      ERR_EMP_OFF
,      ERR_DEPT_CODE
,      ERR_DOC_TYPE
,      ERR_PAY_PERIOD
,      ERR_AUTH_DT
,      NAT_ACT_1ST_3_POS
,      NAT_ACT_2ND_3_POS
,      ERR_EFF_DT
,      ERR_BATCH_NO
,      ERR_OPER_CODE
,      ERROR_CODE
,      ERROR_MSG
,      ERROR_ELEMENT_NAME
,      ERROR_ELEM_CONTENT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM HR.GHR_PA_INTERFACE_ERR_DTLS#;

Dependencies

[top of page]

HR.GHR_PA_INTERFACE_ERR_DTLS# references the following:

HR: GHR_PA_INTERFACE_ERR_DTLS

HR.GHR_PA_INTERFACE_ERR_DTLS# is referenced by following:

APPS: GHR_PA_INTERFACE_ERR_DTLS; GHR_PA_INTERFACE_ERR_DTLS_WHO