[Home] [Help]
[Dependency Information]
VIEW: GMF.GL_SUBR_TST_EFC#
Object Details
Object Name: | GL_SUBR_TST_EFC# |
Object Type: | VIEW |
Owner: | GMF |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
SUBLEDGER_ID |
NUMBER |
|
Yes |
|
CURRENCY_BASE |
VARCHAR2 |
(4) |
Yes |
|
EXCHANGE_RATE |
NUMBER |
|
|
|
AMOUNT_BASE |
NUMBER |
|
Yes |
|
SET_OF_BOOKS_ID |
NUMBER |
|
Yes |
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT SUBLEDGER_ID
, CURRENCY_BASE
, EXCHANGE_RATE
, AMOUNT_BASE
, SET_OF_BOOKS_ID
FROM GMF.GL_SUBR_TST_EFC#;
Dependencies
[top of page]
GMF.GL_SUBR_TST_EFC# references the following:
-
GMF
-
GL_SUBR_TST_EFC
GMF.GL_SUBR_TST_EFC# is referenced by following:
-
APPS
-
GL_SUBR_TST_EFC