Product: | PQH - Public Sector HR |
---|---|
Description: | Transaction Categories View |
Implementation/DBA Data: | APPS.PQH_TRANSACTION_CATEGORIES_V |
SELECT CTL.ROW_ID
, CTL.BUSINESS_GROUP_ID
, CTL.MASTER_TABLE_ROUTE_ID
, CTL.CUSTOM_WORKFLOW_NAME
, CTL.FORM_NAME
, CTL.FREEZE_STATUS_CD
, B.MEANING FREEZE_STATUS_MEANING
, CTL.MEMBER_CD
, C.MEANING MEMBER_MEANING
, CTL.POST_STYLE_CD
, D.MEANING POST_STYLE_MEANING
, CTL.FUTURE_ACTION_CD
, E.MEANING FUTURE_ACTION_MEANING
, CTL.POST_TXN_FUNCTION
, CTL.ROUTE_VALIDATED_TXN_FLAG
, CTL.TIMEOUT_DAYS
, CTL.OBJECT_VERSION_NUMBER
, CTL.TRANSACTION_CATEGORY_ID
, CTL.CONSOLIDATED_TABLE_ROUTE_ID
, TRT.FROM_CLAUSE
, CTL.CUSTOM_WF_PROCESS_NAME
, CTL.LAST_UPDATE_DATE
, CTL.CREATION_DATE
, CTL.CREATED_BY
, CTL.LAST_UPDATE_LOGIN
, CTL.LAST_UPDATED_BY
, CTL.NAME
, CTL.SHORT_NAME
, CTL.SETUP_TYPE_CD
, F.MEANING SETUP_TYPE
, CTL.ENABLE_FLAG
, CTL.WORKFLOW_ENABLE_FLAG
FROM PQH_TRANSACTION_CATEGORIES_VL CTL
, PQH_TABLE_ROUTE TRT
, HR_LOOKUPS B
, HR_LOOKUPS C
, HR_LOOKUPS D
, HR_LOOKUPS E
, HR_LOOKUPS F
WHERE CTL.CONSOLIDATED_TABLE_ROUTE_ID = TRT.TABLE_ROUTE_ID
AND CTL.FREEZE_STATUS_CD = B.LOOKUP_CODE(+)
AND B.LOOKUP_TYPE(+) = 'PQH_CATEGORY_FREEZE_STATUS'
AND CTL.MEMBER_CD = C.LOOKUP_CODE(+)
AND C.LOOKUP_TYPE(+) = 'PQH_MEMBER_CD'
AND CTL.POST_STYLE_CD = D.LOOKUP_CODE(+)
AND D.LOOKUP_TYPE(+) = 'PQH_POST_STYLE'
AND CTL.FUTURE_ACTION_CD = E.LOOKUP_CODE(+)
AND E.LOOKUP_TYPE(+) = 'PQH_FUTURE_ACTION'
AND CTL.SETUP_TYPE_CD = F.LOOKUP_CODE(+)
AND F.LOOKUP_TYPE(+) = 'PQH_TXN_CAT_SETUP_TYPE'