DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.CSI_LOOKUPS

Object Details
Object Name: CSI_LOOKUPS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSI.CSI_LOOKUPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Installed Base Lookups


[View Source]

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Yes Check the Base table for the column description.
LOOKUP_CODE VARCHAR2 (30) Yes Check the Base table for the column description.
LAST_UPDATE_DATE DATE
Yes Check the Base table for the column description.
LAST_UPDATED_BY NUMBER (15) Yes Check the Base table for the column description.
LAST_UPDATE_LOGIN NUMBER (15)
Check the Base table for the column description.
CREATION_DATE DATE
Yes Check the Base table for the column description.
CREATED_BY NUMBER (15) Yes Check the Base table for the column description.
MEANING VARCHAR2 (80) Yes Check the Base table for the column description.
ENABLED_FLAG VARCHAR2 (1) Yes Check the Base table for the column description.
START_DATE_ACTIVE DATE

Check the Base table for the column description.
END_DATE_ACTIVE DATE

Check the Base table for the column description.
DESCRIPTION VARCHAR2 (240)
Check the Base table for the column description.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Check the Base table for the column description.
ATTRIBUTE1 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE2 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE3 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE4 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE5 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE6 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE7 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE8 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE9 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE10 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE11 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE12 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE13 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE14 VARCHAR2 (150)
Check the Base table for the column description.
ATTRIBUTE15 VARCHAR2 (150)
Check the Base table for the column description.
TAG VARCHAR2 (150)
Check the Base table for the column description.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOOKUP_TYPE
,      LOOKUP_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      MEANING
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DESCRIPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TAG
FROM APPS.CSI_LOOKUPS;

Dependencies

[top of page]

APPS.CSI_LOOKUPS references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
APPS.CSI_LOOKUPS is referenced by following:

SchemaAPPS
Package BodyAHL_PRD_PARTS_CHANGE_PVT - show dependent code
Package BodyAHL_UC_UTILIZATION_PVT - show dependent code
ViewAHL_UNIT_ALTERNATES_V
ViewAHL_UNIT_INSTALLED_DETAILS_V
Package BodyAHL_UTIL_UC_PKG - show dependent code
ViewAMS_DS_INSTALL_BASE_V
Package BodyCSE_UTIL_PKG - show dependent code
ViewCSI_ASSET_INTEGRATION_R12_V
Package BodyCSI_ASSET_VLD_PVT - show dependent code
ViewCSI_CONTACTS_V
ViewCSI_COUNTER_READINGS_BCV_V
Package BodyCSI_COUNTER_READINGS_PVT - show dependent code
Package BodyCSI_COUNTER_TEMPLATE_PVT - show dependent code
ViewCSI_CP_FORM_GRID_V
ViewCSI_CP_SYSTEMS_RG_V
ViewCSI_CUST_PROD_MAINT_V
Package BodyCSI_DIAGNOSTICS_PKG - show dependent code
Package BodyCSI_GENERIC_GRP - show dependent code
ViewCSI_INSTALLED_BASE_V
ViewCSI_INSTANCE_DETAILS_V
Package BodyCSI_INSTANCE_PARTIES_VLD_PVT - show dependent code
ViewCSI_INSTANCE_SEARCH_V
ViewCSI_INST_PARTY_DETAILS_V
Package BodyCSI_INV_TRXS_PKG - show dependent code
ViewCSI_IPH_DETAILS_V
Package BodyCSI_ITEM_INSTANCE_PVT - show dependent code
Package BodyCSI_ITEM_INSTANCE_VLD_PVT - show dependent code
Package BodyCSI_MASS_EDIT_PUB - show dependent code
Package BodyCSI_MASS_EDIT_PVT - show dependent code
Package BodyCSI_ORGANIZATION_UNIT_PVT - show dependent code
Package BodyCSI_ORG_UNIT_VLD_PVT - show dependent code
ViewCSI_PARTY_CONTACT_DETAILS_V
Package BodyCSI_PARTY_RELATIONSHIPS_PUB - show dependent code
Package BodyCSI_SYSTEMS_PVT - show dependent code
ViewCSI_SYSTEMS_V
Package BodyCSI_TRANSACTIONS_PVT - show dependent code
ViewCSI_TXN_SUB_TYPES
ViewCSI_T_PARTY_CONTACTS_V
ViewCSI_T_PARTY_DETAILS_V
ViewEAM_CFR_COUNTER_READINGS_V
Package BodyOKS_ENTITLEMENTS_WEB - show dependent code
ViewXDP_FA_PARAMETERS_DISP_V
ViewXDP_PARAMETER_POOL_VL
Package BodyXDP_PROCEDURE_BUILDER_UTIL - show dependent code
Package BodyXDP_PROC_CTL - show dependent code
ViewXDP_WI_PARAMETERS_DISP_V
Package BodyXNP_MSG_SCHEMA - show dependent code