Product: | PQH - Public Sector HR |
---|---|
Description: | Transaction Categories View |
Implementation/DBA Data: | APPS.PQH_TRANSACTION_CATEGORIES_VL |
SELECT TCT.ROWID ROW_ID
, TCT.BUSINESS_GROUP_ID
, TCT.MASTER_TABLE_ROUTE_ID
, TCT.CUSTOM_WORKFLOW_NAME
, TCT.FORM_NAME
, TCT.FREEZE_STATUS_CD
, TCT.FUTURE_ACTION_CD
, TCT.MEMBER_CD
, TCT.POST_STYLE_CD
, TCT.POST_TXN_FUNCTION
, TCT.ROUTE_VALIDATED_TXN_FLAG
, TCT.TIMEOUT_DAYS
, TCT.OBJECT_VERSION_NUMBER
, TCT.TRANSACTION_CATEGORY_ID
, TCT.CONSOLIDATED_TABLE_ROUTE_ID
, TCT.CUSTOM_WF_PROCESS_NAME
, TCT.LAST_UPDATE_DATE
, TCT.CREATION_DATE
, TCT.CREATED_BY
, TCT.LAST_UPDATE_LOGIN
, TCT.LAST_UPDATED_BY
, CTL.NAME
, TCT.SHORT_NAME
, TCT.SETUP_TYPE_CD
, TCT.ENABLE_FLAG
, TCT.WORKFLOW_ENABLE_FLAG
FROM PQH_TRANSACTION_CATEGORIES_TL CTL
, PQH_TRANSACTION_CATEGORIES TCT
WHERE TCT.TRANSACTION_CATEGORY_ID = CTL.TRANSACTION_CATEGORY_ID
AND CTL.LANGUAGE = USERENV('LANG')