[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:
-
APPS
-
IES_TRANSACTIONS
-
IES_TRANS_SEGMENTS
APPS.IES_TRANS_SEGMENTS_COUNT_V is referenced by following:
-
APPS
-
IES_SUSPENDED_TRANS_V