eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PQH_TRANSACTION_CATEGORIES_VL

Object Details

Object Name:	PQH_TRANSACTION_CATEGORIES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PQH.PQH_TRANSACTION_CATEGORIES_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

Transaction Categories View

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Id
BUSINESS_GROUP_ID	NUMBER	(15)		Business Group Identifier
MASTER_TABLE_ROUTE_ID	NUMBER	(15)		Master Table route Identifier
CUSTOM_WORKFLOW_NAME	VARCHAR2	(30)		Workflow Name
FORM_NAME	VARCHAR2	(30)	Yes	Associated Form Name
FREEZE_STATUS_CD	VARCHAR2	(30)		Frozen yes or No
FUTURE_ACTION_CD	VARCHAR2	(30)	Yes	Future Action Code
MEMBER_CD	VARCHAR2	(30)	Yes	Member Code
POST_STYLE_CD	VARCHAR2	(30)	Yes	Posting style (Immediate/deffered)
POST_TXN_FUNCTION	VARCHAR2	(61)	Yes	Function to post
ROUTE_VALIDATED_TXN_FLAG	VARCHAR2	(10)	Yes	flag to identify wheather to Validate Transaction being routed
TIMEOUT_DAYS	NUMBER	(5)		Time out days on routing
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number
TRANSACTION_CATEGORY_ID	NUMBER	(15)	Yes	Primary Key
CONSOLIDATED_TABLE_ROUTE_ID	NUMBER	(15)	Yes	Consolidated Table Route Identifier
CUSTOM_WF_PROCESS_NAME	VARCHAR2	(30)		Wrokflow process Name
LAST_UPDATE_DATE	DATE			Standard Who Columns
CREATION_DATE	DATE		Yes	Standard Who Columns
CREATED_BY	NUMBER	(15)	Yes	Standard Who Columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Columns
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Columns
NAME	VARCHAR2	(100)	Yes	transaction name
SHORT_NAME	VARCHAR2	(30)	Yes	short name - developer key
SETUP_TYPE_CD	VARCHAR2	(30)		Set up Type code
ENABLE_FLAG	VARCHAR2	(10)		Enable flag
WORKFLOW_ENABLE_FLAG	VARCHAR2	(10)		workflow enabled flag
PREVENT_APPROVER_SKIP	VARCHAR2	(10)		Prevent approver getting skipped on routing

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      BUSINESS_GROUP_ID
,      MASTER_TABLE_ROUTE_ID
,      CUSTOM_WORKFLOW_NAME
,      FORM_NAME
,      FREEZE_STATUS_CD
,      FUTURE_ACTION_CD
,      MEMBER_CD
,      POST_STYLE_CD
,      POST_TXN_FUNCTION
,      ROUTE_VALIDATED_TXN_FLAG
,      TIMEOUT_DAYS
,      OBJECT_VERSION_NUMBER
,      TRANSACTION_CATEGORY_ID
,      CONSOLIDATED_TABLE_ROUTE_ID
,      CUSTOM_WF_PROCESS_NAME
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      NAME
,      SHORT_NAME
,      SETUP_TYPE_CD
,      ENABLE_FLAG
,      WORKFLOW_ENABLE_FLAG
,      PREVENT_APPROVER_SKIP
FROM APPS.PQH_TRANSACTION_CATEGORIES_VL;

Dependencies

[top of page]

APPS.PQH_TRANSACTION_CATEGORIES_VL references the following:

APPS: PQH_TRANSACTION_CATEGORIES; PQH_TRANSACTION_CATEGORIES_TL

APPS.PQH_TRANSACTION_CATEGORIES_VL is referenced by following:

APPS: PQH_COPY_ENTITY_CONTEXTS_V; PQH_CTL_UPD - show dependent code; PQH_GENERIC - show dependent code; PQH_GEN_FORM - show dependent code; PQH_RLM_BUS - show dependent code; PQH_RLT_BUS - show dependent code; PQH_TCT_SHD - show dependent code; PQH_TCT_WIZARD_PKG - show dependent code; PQH_TEMPLATES_V; PQH_TEM_BUS - show dependent code; PQH_TRANSACTION_CATEGORIES_V