[Home] [Help]
[Dependency Information]
VIEW: APPS.AMS_LOOKUP_SALES_V
Object Details
Object Name: | AMS_LOOKUP_SALES_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_LOOKUP_SALES_V
|
---|
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
CATEGORY |
VARCHAR2 |
(4) |
|
|
LOOKUP_TYPE |
VARCHAR2 |
(60) |
|
|
CODE |
VARCHAR2 |
(150) |
|
|
DESCRIPTION |
VARCHAR2 |
(240) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT CATEGORY
, LOOKUP_TYPE
, CODE
, DESCRIPTION
FROM APPS.AMS_LOOKUP_SALES_V;
Dependencies
[top of page]
APPS.AMS_LOOKUP_SALES_V references the following:
-
APPS
-
AMS_USER_ORG_V
-
AR_LOOKUPS
-
AS_FORECAST_PROB_ALL_VL
-
AS_LOOKUPS
-
AS_SALES_STAGES_ALL_VL
-
FND_DATE
- show dependent code
-
FND_FLEX_VALUES
-
FND_FLEX_VALUE_SETS
-
FND_GLOBAL
- show dependent code
-
FND_TERRITORIES_VL
-
SO_LOOKUPS
APPS.AMS_LOOKUP_SALES_V is not referenced by any database object