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]

TABLE: AZ.AZ_PRODUCT_FLOWS

Object Details

Object Name:	AZ_PRODUCT_FLOWS
Object Type:	TABLE
Owner:	AZ
FND Design Data:	AZ.AZ_PRODUCT_FLOWS
Subobject Name:
Status:	VALID

AZ_PRODUCT_FLOWS stores information about the runnable workflow
processes for each application. Each record contains the unique
identifier of the application, the item type, process name, and context
type, as well as the parent process group that it is associated with
and its display order in the hierarchy tree.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AZ_PRODUCT_FLOWS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	APPLICATION_ID ITEM_TYPE PROCESS_NAME
AZ_PRODUCT_FLOWS_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	PARENT_ID PROCESS_TYPE
AZ_PRODUCT_FLOWS_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ITEM_TYPE PROCESS_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
PROCESS_TYPE	VARCHAR2	(30)	Yes	Implementation type for process, Fresh or Upgrade
APPLICATION_ID	NUMBER	(15)	Yes	Application identifier
ITEM_TYPE	VARCHAR2	(30)	Yes	Item type
PROCESS_NAME	VARCHAR2	(30)	Yes	Internal name of the process activity
DISPLAY_ORDER	NUMBER	(15)	Yes	Display order of the process in the hierarchy tree
CONTEXT_TYPE	VARCHAR2	(30)	Yes	Context type of the process (BG for business group, IO for inventory organization, OU for operating unit, SOB for set of books)
PARENT_ID	VARCHAR2	(240)	Yes	Parent process group that the process is associated with

Query Text

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


SELECT PROCESS_TYPE
,      APPLICATION_ID
,      ITEM_TYPE
,      PROCESS_NAME
,      DISPLAY_ORDER
,      CONTEXT_TYPE
,      PARENT_ID
FROM AZ.AZ_PRODUCT_FLOWS;

Dependencies

[top of page]

AZ.AZ_PRODUCT_FLOWS does not reference any database object

AZ.AZ_PRODUCT_FLOWS is referenced by following:

AZ: AZ_PRODUCT_FLOWS#