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_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[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/ No
FREEZE_STATUS_MEANING	VARCHAR2	(80)		Frozen Code Meaning
MEMBER_CD	VARCHAR2	(30)	Yes	Member Code
MEMBER_MEANING	VARCHAR2	(80)		Member Code Meaning
POST_STYLE_CD	VARCHAR2	(30)	Yes	Post style Code
POST_STYLE_MEANING	VARCHAR2	(80)		Post Style Code Meaning
FUTURE_ACTION_CD	VARCHAR2	(30)	Yes	Future Action Code
FUTURE_ACTION_MEANING	VARCHAR2	(80)		Future action code meaning
POST_TXN_FUNCTION	VARCHAR2	(61)	Yes	Posting function
ROUTE_VALIDATED_TXN_FLAG	VARCHAR2	(10)	Yes	Validate transaction to be routed flag
TIMEOUT_DAYS	NUMBER	(5)		Routing timeout days
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number
TRANSACTION_CATEGORY_ID	NUMBER	(15)	Yes	Primary Key
CONSOLIDATED_TABLE_ROUTE_ID	NUMBER	(15)	Yes
FROM_CLAUSE	VARCHAR2	(4000)	Yes	From Clause
CUSTOM_WF_PROCESS_NAME	VARCHAR2	(30)		Workflow process name
LAST_UPDATE_DATE	DATE			Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
NAME	VARCHAR2	(100)	Yes	Transaction Type Name
SHORT_NAME	VARCHAR2	(30)	Yes	Short Name - Developer Key
SETUP_TYPE_CD	VARCHAR2	(30)		Setup type Code
SETUP_TYPE	VARCHAR2	(80)		Setup Type Code meaning
ENABLE_FLAG	VARCHAR2	(10)		Enable Flag Yes/No
WORKFLOW_ENABLE_FLAG	VARCHAR2	(10)		Workflow enable flag
PREVENT_APPROVER_SKIP	VARCHAR2	(10)		Prevent Skipping of Approvers when transaction being routed flag

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
,      FREEZE_STATUS_MEANING
,      MEMBER_CD
,      MEMBER_MEANING
,      POST_STYLE_CD
,      POST_STYLE_MEANING
,      FUTURE_ACTION_CD
,      FUTURE_ACTION_MEANING
,      POST_TXN_FUNCTION
,      ROUTE_VALIDATED_TXN_FLAG
,      TIMEOUT_DAYS
,      OBJECT_VERSION_NUMBER
,      TRANSACTION_CATEGORY_ID
,      CONSOLIDATED_TABLE_ROUTE_ID
,      FROM_CLAUSE
,      CUSTOM_WF_PROCESS_NAME
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      NAME
,      SHORT_NAME
,      SETUP_TYPE_CD
,      SETUP_TYPE
,      ENABLE_FLAG
,      WORKFLOW_ENABLE_FLAG
,      PREVENT_APPROVER_SKIP
FROM APPS.PQH_TRANSACTION_CATEGORIES_V;

Dependencies

[top of page]

APPS.PQH_TRANSACTION_CATEGORIES_V references the following:

APPS: HR_API - show dependent code; HR_LOOKUPS; PQH_TABLE_ROUTE; PQH_TRANSACTION_CATEGORIES_VL

APPS.PQH_TRANSACTION_CATEGORIES_V is not referenced by any database object