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


VIEW: APPS.WMS_OP_PLANS_V

Object Details
Object Name: WMS_OP_PLANS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWMS.WMS_OP_PLANS_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
ROW_ID ROWID (10)
Record row ID
OPERATION_PLAN_ID NUMBER
Yes Operation plan identifier
ACTIVITY_TYPE_ID NUMBER

Warehouse activity types, such as inbound, outbound, etc.
COMMON_TO_ALL_ORG VARCHAR2 (1)
Whether the plan is common to all organizations.
PLAN_TYPE_ID NUMBER

Operation plan type according to activity type.
OPERATION_PLAN_NAME VARCHAR2 (255) Yes Operation plan name
SYSTEM_TASK_TYPE NUMBER

Task Type Column - Not used after patchset J
ORGANIZATION_ID NUMBER

Organization Id
EFFECTIVE_DATE_FROM DATE

Effective Start Date of operation plan
EFFECTIVE_DATE_TO DATE

Effective End Date of operation plan
USER_DEFINED VARCHAR2 (1)
Flag to indicate wether plan is system defined (seeded) or user defined (custom)
ENABLED_FLAG VARCHAR2 (1)
Flag to indicate whether operation plan is enabled or not
TEMPLATE_FLAG VARCHAR2 (1)
Flag to indicate whether the current plan can be used as a template.
DEFAULT_FLAG VARCHAR2 (1)
Flag to indicate if this is a default operation plan.
CREATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment
DESCRIPTION VARCHAR2 (4000)
Description
ACTIVITY_TYPE VARCHAR2 (80) Yes Name for warehouse activity types, such as inbound, outbound, etc.
PLAN_TYPE VARCHAR2 (80) Yes Name for operation plan type according to activity type.
CROSSDOCK_TO_WIP_FLAG VARCHAR2 (1)
Flag to indicate whether this operation plan is applicable to tasks that crossdocks material to WIP work orders.
Query Text

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


SELECT ROW_ID
,      OPERATION_PLAN_ID
,      ACTIVITY_TYPE_ID
,      COMMON_TO_ALL_ORG
,      PLAN_TYPE_ID
,      OPERATION_PLAN_NAME
,      SYSTEM_TASK_TYPE
,      ORGANIZATION_ID
,      EFFECTIVE_DATE_FROM
,      EFFECTIVE_DATE_TO
,      USER_DEFINED
,      ENABLED_FLAG
,      TEMPLATE_FLAG
,      DEFAULT_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DESCRIPTION
,      ACTIVITY_TYPE
,      PLAN_TYPE
,      CROSSDOCK_TO_WIP_FLAG
FROM APPS.WMS_OP_PLANS_V;

Dependencies

[top of page]

APPS.WMS_OP_PLANS_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymWMS_OP_PLANS_B
SynonymWMS_OP_PLANS_TL

APPS.WMS_OP_PLANS_V is not referenced by any database object