View: HXC_APPROVAL_COMPS_V

Product:	HXC - Time and Labor Engine
Description:
Implementation/DBA Data:	APPS.HXC_APPROVAL_COMPS_V

View Text

SELECT HAC.ROWID ROW_ID
, HAC.APPROVAL_COMP_ID
, HAC.APPROVAL_STYLE_ID
, HAS.NAME
, HAC.TIME_RECIPIENT_ID
, HTR.NAME
, HAC.APPROVAL_MECHANISM
, HRL.MEANING
, HAC.APPROVAL_MECHANISM_ID
, TO_CHAR (NULL)
, HAC.APPROVAL_ORDER
, HAC.START_DATE
, DECODE (HAC.END_DATE
, HR_GENERAL.END_OF_TIME
, TO_DATE (NULL)
, HAC.END_DATE)
, HAC.WF_ITEM_TYPE
, HAC.WF_NAME
, HAC.OBJECT_VERSION_NUMBER
, HAC.CREATED_BY
, HAC.CREATION_DATE
, HAC.LAST_UPDATED_BY
, HAC.LAST_UPDATE_DATE
, HAC.LAST_UPDATE_LOGIN
, HTC.TIME_CATEGORY_NAME
, HAC.TIME_CATEGORY_ID
, HAC.PARENT_COMP_ID
, HAC.PARENT_COMP_OVN
, HAC.RUN_RECIPIENT_EXTENSIONS
FROM HXC_TIME_RECIPIENTS HTR
, HXC_APPROVAL_STYLES HAS
, HR_STANDARD_LOOKUPS HRL
, HXC_APPROVAL_COMPS HAC
, HXC_TIME_CATEGORIES HTC
WHERE HAC.APPROVAL_STYLE_ID = HAS.APPROVAL_STYLE_ID
AND HAC.TIME_RECIPIENT_ID = HTR.TIME_RECIPIENT_ID(+)
AND HRL.LOOKUP_TYPE(+) = 'HXC_APPROVAL_MECHANISM'
AND HRL.LOOKUP_CODE(+) = HAC.APPROVAL_MECHANISM
AND HRL.APPLICATION_ID(+) = 809
AND HAC.APPROVAL_MECHANISM IN ('HR_SUPERVISOR'
, 'AUTO_APPROVE'
, 'ORG_TIMEKEEPER'
, 'ENTRY_LEVEL_APPROVAL'
, 'PROJECT_MANAGER')
AND HAC.APPROVAL_MECHANISM_ID IS NULL
AND (HTC.TIME_CATEGORY_ID(+) = HAC.TIME_CATEGORY_ID) UNION SELECT HAC.ROWID ROW_ID
, HAC.APPROVAL_COMP_ID
, HAC.APPROVAL_STYLE_ID
, HAS.NAME
, HAC.TIME_RECIPIENT_ID
, HTR.NAME
, HAC.APPROVAL_MECHANISM
, HRL.MEANING
, HAC.APPROVAL_MECHANISM_ID
, PPX.FULL_NAME
, HAC.APPROVAL_ORDER
, HAC.START_DATE
, DECODE (HAC.END_DATE
, HR_GENERAL.END_OF_TIME
, TO_DATE (NULL)
, HAC.END_DATE)
, HAC.WF_ITEM_TYPE
, HAC.WF_NAME
, HAC.OBJECT_VERSION_NUMBER
, HAC.CREATED_BY
, HAC.CREATION_DATE
, HAC.LAST_UPDATED_BY
, HAC.LAST_UPDATE_DATE
, HAC.LAST_UPDATE_LOGIN
, HTC.TIME_CATEGORY_NAME
, HAC.TIME_CATEGORY_ID
, HAC.PARENT_COMP_ID
, HAC.PARENT_COMP_OVN
, HAC.RUN_RECIPIENT_EXTENSIONS
FROM HXC_TIME_RECIPIENTS HTR
, HXC_APPROVAL_STYLES HAS
, HR_STANDARD_LOOKUPS HRL
, PER_PEOPLE_X PPX
, HXC_APPROVAL_COMPS HAC
, HXC_TIME_CATEGORIES HTC
WHERE HAC.APPROVAL_STYLE_ID = HAS.APPROVAL_STYLE_ID
AND HAC.TIME_RECIPIENT_ID = HTR.TIME_RECIPIENT_ID(+)
AND HRL.LOOKUP_TYPE(+) = 'HXC_APPROVAL_MECHANISM'
AND HRL.LOOKUP_CODE(+) = HAC.APPROVAL_MECHANISM
AND HRL.APPLICATION_ID(+) = 809
AND HAC.APPROVAL_MECHANISM = 'PERSON'
AND HAC.APPROVAL_MECHANISM_ID = PPX.PERSON_ID
AND (HTC.TIME_CATEGORY_ID(+) = HAC.TIME_CATEGORY_ID) UNION SELECT HAC.ROWID ROW_ID
, HAC.APPROVAL_COMP_ID
, HAC.APPROVAL_STYLE_ID
, HAS.NAME
, HAC.TIME_RECIPIENT_ID
, HTR.NAME
, HAC.APPROVAL_MECHANISM
, HRL.MEANING
, HAC.APPROVAL_MECHANISM_ID
, WFA.DISPLAY_NAME
, HAC.APPROVAL_ORDER
, HAC.START_DATE
, DECODE (HAC.END_DATE
, HR_GENERAL.END_OF_TIME
, TO_DATE (NULL)
, HAC.END_DATE)
, HAC.WF_ITEM_TYPE
, HAC.WF_NAME
, HAC.OBJECT_VERSION_NUMBER
, HAC.CREATED_BY
, HAC.CREATION_DATE
, HAC.LAST_UPDATED_BY
, HAC.LAST_UPDATE_DATE
, HAC.LAST_UPDATE_LOGIN
, HTC.TIME_CATEGORY_NAME
, HAC.TIME_CATEGORY_ID
, HAC.PARENT_COMP_ID
, HAC.PARENT_COMP_OVN
, HAC.RUN_RECIPIENT_EXTENSIONS
FROM HXC_TIME_RECIPIENTS HTR
, HXC_APPROVAL_STYLES HAS
, HR_STANDARD_LOOKUPS HRL
, WF_ACTIVITIES_VL WFA
, HXC_APPROVAL_COMPS HAC
, HXC_TIME_CATEGORIES HTC
WHERE HAC.APPROVAL_STYLE_ID = HAS.APPROVAL_STYLE_ID
AND HAC.TIME_RECIPIENT_ID = HTR.TIME_RECIPIENT_ID(+)
AND HRL.LOOKUP_TYPE(+) = 'HXC_APPROVAL_MECHANISM'
AND HRL.LOOKUP_CODE(+) = HAC.APPROVAL_MECHANISM
AND HRL.APPLICATION_ID(+) = 809
AND HAC.APPROVAL_MECHANISM = 'WORKFLOW'
AND WFA.NAME LIKE 'OTC_APPROVAL%'
AND WFA.TYPE = 'PROCESS'
AND WFA.VERSION = (SELECT MAX (VERSION)
FROM WF_ACTIVITIES_VL WF
WHERE WF.ITEM_TYPE = WFA.ITEM_TYPE
AND WF.NAME = WFA.NAME)
AND HAC.WF_ITEM_TYPE = WFA.ITEM_TYPE
AND HAC.WF_NAME = WFA.NAME
AND (HTC.TIME_CATEGORY_ID(+) = HAC.TIME_CATEGORY_ID) UNION SELECT HAC.ROWID ROW_ID
, HAC.APPROVAL_COMP_ID
, HAC.APPROVAL_STYLE_ID
, HAS.NAME
, HAC.TIME_RECIPIENT_ID
, HTR.NAME
, HAC.APPROVAL_MECHANISM
, HRL.MEANING
, HAC.APPROVAL_MECHANISM_ID
, FF.DESCRIPTION
, HAC.APPROVAL_ORDER
, HAC.START_DATE
, DECODE (HAC.END_DATE
, HR_GENERAL.END_OF_TIME
, TO_DATE (NULL)
, HAC.END_DATE)
, HAC.WF_ITEM_TYPE
, HAC.WF_NAME
, HAC.OBJECT_VERSION_NUMBER
, HAC.CREATED_BY
, HAC.CREATION_DATE
, HAC.LAST_UPDATED_BY
, HAC.LAST_UPDATE_DATE
, HAC.LAST_UPDATE_LOGIN
, HTC.TIME_CATEGORY_NAME
, HAC.TIME_CATEGORY_ID
, HAC.PARENT_COMP_ID
, HAC.PARENT_COMP_OVN
, HAC.RUN_RECIPIENT_EXTENSIONS
FROM HXC_TIME_RECIPIENTS HTR
, HXC_APPROVAL_STYLES HAS
, HR_STANDARD_LOOKUPS HRL
, FF_FORMULAS_F FF
, FF_FORMULA_TYPES FFT
, HXC_APPROVAL_COMPS HAC
, HXC_TIME_CATEGORIES HTC
WHERE HAC.APPROVAL_STYLE_ID = HAS.APPROVAL_STYLE_ID
AND HAC.TIME_RECIPIENT_ID = HTR.TIME_RECIPIENT_ID(+)
AND HRL.LOOKUP_TYPE(+) = 'HXC_APPROVAL_MECHANISM'
AND HRL.LOOKUP_CODE(+) = HAC.APPROVAL_MECHANISM
AND HRL.APPLICATION_ID(+) = 809
AND HAC.APPROVAL_MECHANISM IN ('FORMULA_MECHANISM'
, 'FORMULA_WORKFLOW')
AND FF.FORMULA_TYPE_ID = FFT.FORMULA_TYPE_ID
AND LOWER (FFT.FORMULA_TYPE_NAME) LIKE 'OTL%'
AND HAC.APPROVAL_MECHANISM_ID = FF.FORMULA_ID
AND (HTC.TIME_CATEGORY_ID(+) = HAC.TIME_CATEGORY_ID)

Columns