View: HXC_TK_GROUP_QUERY_CRITERIA_V

Product:	HXC - Time and Labor Engine
Description:	Timekeeper Group Query Criteria
Implementation/DBA Data:	APPS.HXC_TK_GROUP_QUERY_CRITERIA_V

View Text

SELECT TKGQC.ROWID ROW_ID
, TKGQC.TK_GROUP_QUERY_CRITERIA_ID
, TKGQC.TK_GROUP_QUERY_ID
, TKGQC.CRITERIA_TYPE
, TKGQC.CRITERIA_ID
, TKGQ.GROUP_QUERY_NAME
, TKGQ.TK_GROUP_ID
, TKGQ.INCLUDE_EXCLUDE
, TKGQ.SYSTEM_USER
, P.FULL_NAME CRITERIA_DISPLAY1
, NVL(P.EMPLOYEE_NUMBER
, P.NPW_NUMBER ) CRITERIA_DISPLAY2
, HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(P.EFFECTIVE_START_DATE
, P.PERSON_ID) CRITERIA_DISPLAY_TYPE
, HXC_TK_GRP_QUERY_CRITERIA_API.GET_TC_PERIOD ( TKGQC.CRITERIA_ID ) TC_PERIOD_NAME
, HXC_TK_GRP_QUERY_CRITERIA_API.CHECK_AUDIT_ENABLED ( TKGQC.CRITERIA_ID ) AUDIT_ENABLED
, TKGQC.OBJECT_VERSION_NUMBER
, P.BUSINESS_GROUP_ID
, TKGQC.CREATED_BY
, TKGQC.CREATION_DATE
, TKGQC.LAST_UPDATED_BY
, TKGQC.LAST_UPDATE_DATE
, TKGQC.LAST_UPDATE_LOGIN
FROM HXC_TK_GROUP_QUERIES TKGQ
, HXC_TK_GROUP_QUERY_CRITERIA TKGQC
, PER_PEOPLE P
, PER_PERSON_TYPES PPT
, PER_PERSON_TYPE_USAGES PTU
, PER_ASSIGNMENTS ASG
WHERE TKGQ.TK_GROUP_QUERY_ID = TKGQC.TK_GROUP_QUERY_ID
AND TKGQC.CRITERIA_TYPE = 'PERSON'
AND TO_NUMBER(TKGQC.CRITERIA_ID) = P.PERSON_ID
AND PTU.PERSON_TYPE_ID = PPT.PERSON_TYPE_ID
AND PPT.SYSTEM_PERSON_TYPE IN ('EMP'
, 'EMP_APL'
, 'CWK'
, 'EX_EMP')
AND P.PERSON_ID = PTU.PERSON_ID
AND ASG.PERSON_ID = P.PERSON_ID
AND ASG.PRIMARY_FLAG = 'Y'
AND ASG.ASSIGNMENT_TYPE IN ( 'E'
, 'C')

Columns