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

VIEW: APPS.WMS_OBJECTS_STRATEGY_V

Object Details
Object Name: WMS_OBJECTS_STRATEGY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWMS.WMS_OBJECTS_STRATEGY_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization identifier
OBJECT_TYPE_CODE NUMBER
Yes Object type code
OBJECT_TYPE_MEANING VARCHAR2 (80) Yes Object type meaning
OBJECT_TYPE_DESCRIPTION VARCHAR2 (240)
Object type description
OBJECT_NAME VARCHAR2 (80)
Object name
OBJECT_DESCRIPTION VARCHAR2 (240)
Object description
OBJECT_ID NUMBER
Yes Object identifier
PK1_VALUE VARCHAR2 (150) Yes Object primary key value 1
PK2_VALUE VARCHAR2 (150)
Object primary key value 2
PK3_VALUE VARCHAR2 (150)
Object primary key value 3
PK4_VALUE VARCHAR2 (150)
Object primary key value 4
PK5_VALUE VARCHAR2 (150)
Object primary key value 5
VALUE_NAME VARCHAR2 (4000)
Name of the instance of the object. It represents the value of the object instance decided by the primary values.
Query Text

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


SELECT ORGANIZATION_ID
,      OBJECT_TYPE_CODE
,      OBJECT_TYPE_MEANING
,      OBJECT_TYPE_DESCRIPTION
,      OBJECT_NAME
,      OBJECT_DESCRIPTION
,      OBJECT_ID
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      VALUE_NAME
FROM APPS.WMS_OBJECTS_STRATEGY_V;

Dependencies

[top of page]

APPS.WMS_OBJECTS_STRATEGY_V references the following:

SchemaAPPS
PL/SQL PackageWMS_ASSIGNMENT_PVT - show dependent code
ViewWMS_STRATEGY_ASSIGNMENTS_V

APPS.WMS_OBJECTS_STRATEGY_V is not referenced by any database object