[Home] [Help]
[Dependency Information]
VIEW: APPS.AMS_TERR_V
Object Details
Object Name: | AMS_TERR_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_TERR_V
|
---|
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
HIERARCHY_ID |
NUMBER |
|
|
|
HIERARCHY_LEVEL |
VARCHAR2 |
(60) |
Yes |
|
HIERARCHY_LEVEL_ID |
NUMBER |
|
Yes |
|
LEVEL_DEPTH |
NUMBER |
|
Yes |
|
PARENT_ID |
NUMBER |
|
|
|
NODE_ID |
NUMBER |
|
|
|
NODE_VALUE |
VARCHAR2 |
(2000) |
Yes |
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT HIERARCHY_ID
, HIERARCHY_LEVEL
, HIERARCHY_LEVEL_ID
, LEVEL_DEPTH
, PARENT_ID
, NODE_ID
, NODE_VALUE
FROM APPS.AMS_TERR_V;
Dependencies
[top of page]
APPS.AMS_TERR_V references the following:
-
APPS
-
AMS_TERR_LEVELS_ALL
-
JTF_TERR_ALL
-
JTF_TERR_TYPES_ALL
APPS.AMS_TERR_V is referenced by following:
-
APPS
-
AMS_ACTMETRICFACT_PVT
- show dependent code
-
AMS_ACT_MKT_SEGMENTS_VL
-
AMS_P_OFFER_MKT_SEGMENTS_V
-
OZF_FUND_ALLOCTREE_V