[Home] [Help]
[Dependency Information]
VIEW: APPS.AMW_LOOKUPS
Object Details
Object Name: | AMW_LOOKUPS |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMW.AMW_LOOKUPS
|
---|
Subobject Name: | |
Status: | VALID |
View Type
A public view which may be useful for custom reporting or other data
requirements.
selection of lookups from fnd_lookup_values for ICM product
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
LOOKUP_TYPE |
VARCHAR2 |
(30) |
Yes |
Lookup Type for lookups belonging to ICM product |
LOOKUP_CODE |
VARCHAR2 |
(30) |
Yes |
Lookup Code for lookups belonging to ICM product |
MEANING |
VARCHAR2 |
(80) |
Yes |
Lookup meaning for lookups belonging to ICM product |
DESCRIPTION |
VARCHAR2 |
(240) |
|
Lookup description for lookups belonging to ICM product |
ENABLED_FLAG |
VARCHAR2 |
(1) |
Yes |
Indicates if the lookup is enabled or not |
START_DATE_ACTIVE |
DATE |
|
|
Starting effectivity date for the lookup. |
END_DATE_ACTIVE |
DATE |
|
|
Ending effectivity date for the lookup. |
TAG |
VARCHAR2 |
(150) |
|
Tag |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
, DESCRIPTION
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, TAG
FROM APPS.AMW_LOOKUPS;
Dependencies
[top of page]
APPS.AMW_LOOKUPS references the following:
-
APPS
-
FND_LOOKUP_VALUES
APPS.AMW_LOOKUPS is referenced by following:
-
APPS
-
AMW_AUDIT_PROJECTS_V
-
AMW_BASIC_RCM_V
-
AMW_CONTROLS_PAGE_PKG
- show dependent code
-
AMW_DELETE_OBJECT_VL
-
AMW_EXPORT_AP_V
-
AMW_EXPORT_AUDIT_PROCEDURE_V
-
AMW_EXPORT_CTRL_V
-
AMW_EXPORT_PROCESS_V
-
AMW_FIN_COSO_VIEWS_PVT
- show dependent code
-
AMW_LOAD_CTRL_DATA
- show dependent code
-
AMW_LOAD_RCM_ORG_DATA
- show dependent code
-
AMW_LOAD_RC_DATA
- show dependent code
-
AMW_LOAD_SOD_DATA
- show dependent code
-
AMW_PROJECT_LISTS_V
-
AMW_SCOPE_PVT
- show dependent code
-
AMW_UTILITY_PVT
- show dependent code
-
AMW_VIOLATIONS_V
-
AMW_WF_ORG_HIERARCHY_MAIN_V
-
RCI_BP_CERT_RESULT_V
-
RCI_BP_ORG_CERT_RESULT_V
-
RCI_FS_ACCT_EVAL_V
-
RCI_FS_CERT_STATUS_V
-
RCI_FS_CERT_TYPE_V
-
RCI_IMPACT_V
-
RCI_LIKELIHOOD_V