Product: | PQH - Public Sector HR |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PQH_ROLE_TEMPLATES_V |
SELECT RTM.ROLE_TEMPLATE_ID
, RTM.ROLE_ID
, RTM.TEMPLATE_ID
, TEM.TEMPLATE_NAME
, RTM.TRANSACTION_CATEGORY_ID
, TCT.NAME
, RTM.ENABLE_FLAG
, RTM.LAST_UPDATED_BY
, RTM.LAST_UPDATE_DATE
, RTM.LAST_UPDATE_LOGIN
, RTM.CREATED_BY
, RTM.CREATION_DATE
, RTM.OBJECT_VERSION_NUMBER
FROM PQH_ROLE_TEMPLATES RTM
, PQH_TEMPLATES TEM
, PQH_TRANSACTION_CATEGORIES TCT
WHERE RTM.TEMPLATE_ID=TEM.TEMPLATE_ID
AND RTM.TRANSACTION_CATEGORY_ID=TCT.TRANSACTION_CATEGORY_ID