VIEW: APPS.PQH_TRANSACTION_CATEGORIES_VL

Source

View Text - Preformatted

SELECT TCT.ROWID ROW_ID, TCT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, TCT.MASTER_TABLE_ROUTE_ID MASTER_TABLE_ROUTE_ID, TCT.CUSTOM_WORKFLOW_NAME CUSTOM_WORKFLOW_NAME, TCT.FORM_NAME FORM_NAME, TCT.FREEZE_STATUS_CD FREEZE_STATUS_CD, TCT.FUTURE_ACTION_CD FUTURE_ACTION_CD, TCT.MEMBER_CD MEMBER_CD, TCT.POST_STYLE_CD POST_STYLE_CD, TCT.POST_TXN_FUNCTION POST_TXN_FUNCTION, TCT.ROUTE_VALIDATED_TXN_FLAG ROUTE_VALIDATED_TXN_FLAG, TCT.TIMEOUT_DAYS TIMEOUT_DAYS, TCT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TCT.TRANSACTION_CATEGORY_ID TRANSACTION_CATEGORY_ID, TCT.CONSOLIDATED_TABLE_ROUTE_ID CONSOLIDATED_TABLE_ROUTE_ID, TCT.CUSTOM_WF_PROCESS_NAME CUSTOM_WF_PROCESS_NAME, TCT.LAST_UPDATE_DATE LAST_UPDATE_DATE, TCT.CREATION_DATE CREATION_DATE, TCT.CREATED_BY CREATED_BY, TCT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TCT.LAST_UPDATED_BY LAST_UPDATED_BY, CTL.NAME NAME, TCT.SHORT_NAME SHORT_NAME, TCT.SETUP_TYPE_CD SETUP_TYPE_CD, TCT.ENABLE_FLAG ENABLE_FLAG, TCT.WORKFLOW_ENABLE_FLAG WORKFLOW_ENABLE_FLAG, TCT.PREVENT_APPROVER_SKIP PREVENT_APPROVER_SKIP from PQH_TRANSACTION_CATEGORIES_TL CTL, PQH_TRANSACTION_CATEGORIES TCT WHERE TCT.TRANSACTION_CATEGORY_ID = CTL.TRANSACTION_CATEGORY_ID and CTL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT TCT.ROWID ROW_ID
, TCT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, TCT.MASTER_TABLE_ROUTE_ID MASTER_TABLE_ROUTE_ID
, TCT.CUSTOM_WORKFLOW_NAME CUSTOM_WORKFLOW_NAME
, TCT.FORM_NAME FORM_NAME
, TCT.FREEZE_STATUS_CD FREEZE_STATUS_CD
, TCT.FUTURE_ACTION_CD FUTURE_ACTION_CD
, TCT.MEMBER_CD MEMBER_CD
, TCT.POST_STYLE_CD POST_STYLE_CD
, TCT.POST_TXN_FUNCTION POST_TXN_FUNCTION
, TCT.ROUTE_VALIDATED_TXN_FLAG ROUTE_VALIDATED_TXN_FLAG
, TCT.TIMEOUT_DAYS TIMEOUT_DAYS
, TCT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TCT.TRANSACTION_CATEGORY_ID TRANSACTION_CATEGORY_ID
, TCT.CONSOLIDATED_TABLE_ROUTE_ID CONSOLIDATED_TABLE_ROUTE_ID
, TCT.CUSTOM_WF_PROCESS_NAME CUSTOM_WF_PROCESS_NAME
, TCT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TCT.CREATION_DATE CREATION_DATE
, TCT.CREATED_BY CREATED_BY
, TCT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TCT.LAST_UPDATED_BY LAST_UPDATED_BY
, CTL.NAME NAME
, TCT.SHORT_NAME SHORT_NAME
, TCT.SETUP_TYPE_CD SETUP_TYPE_CD
, TCT.ENABLE_FLAG ENABLE_FLAG
, TCT.WORKFLOW_ENABLE_FLAG WORKFLOW_ENABLE_FLAG
, TCT.PREVENT_APPROVER_SKIP PREVENT_APPROVER_SKIP
FROM PQH_TRANSACTION_CATEGORIES_TL CTL
, PQH_TRANSACTION_CATEGORIES TCT
WHERE TCT.TRANSACTION_CATEGORY_ID = CTL.TRANSACTION_CATEGORY_ID
AND CTL.LANGUAGE = USERENV('LANG')