Product: | PQH - Public Sector HR |
---|---|
Description: | Templates View |
Implementation/DBA Data: | APPS.PQH_TEMPLATES_V |
SELECT TEM.ROW_ID
, TEM.TEMPLATE_NAME
, TEM.SHORT_NAME
, TEM.TEMPLATE_ID
, TEM.ATTRIBUTE_ONLY_FLAG
, TEM.ENABLE_FLAG
, TEM.CREATE_FLAG
, LKP.MEANING TEMPLATE_TASK_TYPE
, TEM.TRANSACTION_CATEGORY_ID
, TCT.NAME TRANSACTION_CATEGORY_NAME
, TEM.UNDER_REVIEW_FLAG
, TEM.FREEZE_STATUS_CD
, C.MEANING FREEZE_STATUS
, TEM.TEMPLATE_TYPE_CD
, L.MEANING TEMPLATE_TYPE
, LEG.TERRITORY_CODE
, LEG.TERRITORY_SHORT_NAME
, TEM.OBJECT_VERSION_NUMBER
, TEM.LAST_UPDATE_DATE
, TEM.LAST_UPDATED_BY
, TEM.LAST_UPDATE_LOGIN
, TEM.CREATED_BY
, TEM.CREATION_DATE
FROM PQH_TEMPLATES_VL TEM
, PQH_TRANSACTION_CATEGORIES_VL TCT
, FND_TERRITORIES_VL LEG
, HR_LOOKUPS C
, HR_LOOKUPS L
, HR_LOOKUPS LKP
WHERE TEM.TRANSACTION_CATEGORY_ID = TCT.TRANSACTION_CATEGORY_ID
AND TEM.LEGISLATION_CODE = LEG.TERRITORY_CODE (+)
AND TEM.FREEZE_STATUS_CD = C.LOOKUP_CODE(+)
AND C.LOOKUP_TYPE(+) = 'PQH_TEMPLATE_FREEZE_STATUS'
AND TEM.TEMPLATE_TYPE_CD = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'PQH_TEMPLATE_TYPE'
AND TEM.CREATE_FLAG = LKP.LOOKUP_CODE(+)
AND LKP.LOOKUP_TYPE(+) = 'PQH_TEMPLATE_TASK_TYPE'