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

VIEW: APPS.IES_TRANS_SEGMENTS_COUNT_V

Object Details
Object Name: IES_TRANS_SEGMENTS_COUNT_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View to get count of segments for each suspended transaction.


[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes Foreign key from ies_transactions.transaction id
SEGMENT_COUNT NUMBER

Segment count for a transaction
Query Text

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


SELECT TRANSACTION_ID
,      SEGMENT_COUNT
FROM APPS.IES_TRANS_SEGMENTS_COUNT_V;

Dependencies

[top of page]

APPS.IES_TRANS_SEGMENTS_COUNT_V references the following:

SchemaAPPS
SynonymIES_TRANSACTIONS
SynonymIES_TRANS_SEGMENTS
APPS.IES_TRANS_SEGMENTS_COUNT_V is referenced by following:

SchemaAPPS
ViewIES_SUSPENDED_TRANS_V