[Home] [Help]
[Dependency Information]
VIEW: GME.GME_TRANSACTION_PAIRS#
Object Details
Object Name: | GME_TRANSACTION_PAIRS# |
Object Type: | VIEW |
Owner: | GME |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
BATCH_ID |
NUMBER |
|
Yes |
|
MATERIAL_DETAIL_ID |
NUMBER |
|
Yes |
|
TRANSACTION_ID1 |
NUMBER |
|
Yes |
|
TRANSACTION_ID2 |
NUMBER |
|
|
|
PAIR_TYPE |
NUMBER |
(1) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, MATERIAL_DETAIL_ID
, TRANSACTION_ID1
, TRANSACTION_ID2
, PAIR_TYPE
FROM GME.GME_TRANSACTION_PAIRS#;
Dependencies
[top of page]
GME.GME_TRANSACTION_PAIRS# references the following:
-
GME
-
GME_TRANSACTION_PAIRS
GME.GME_TRANSACTION_PAIRS# is referenced by following:
-
APPS
-
GME_TRANSACTION_PAIRS