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

VIEW: APPS.WMS_OP_PLAN_DETAILS_V

Object Details
Object Name: WMS_OP_PLAN_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWMS.WMS_OP_PLAN_DETAILS_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
OPERATION_PLAN_ID NUMBER
Yes Operation Plan Identifier
OPERATION_PLAN_DETAIL_ID NUMBER
Yes Operation Plan Detail identifier
OPERATION_TYPE NUMBER
Yes Operation Type
OPERATION_SEQUENCE NUMBER
Yes Operation Sequence
BULK_PICK_TYPE NUMBER

For future use
DROP_LPN_OPTION NUMBER

Drop LPN display flag
WAIT_FOR_GROUP_COMPLETION VARCHAR2 (1)
For future use
SYSTEM_DISPATCHED VARCHAR2 (1)
For future use
OP_SEGMENT_COMPLETED VARCHAR2 (1)
For future use
ZONE_SELECTION_CRITERIA NUMBER

Zone Selection Criterion
PRE_SPECIFIED_ZONE_ID NUMBER

Destination Zone Identifier
ZONE_SELECTION_API_ID NUMBER

Identifier of API to be used to select destination Zone
SUB_SELECTION_CRITERIA NUMBER

Subinventory Selection Criterion
PRE_SPECIFIED_SUB_CODE VARCHAR2 (30)
Destination Subinventory Identifier
SUB_SELECTION_API_ID NUMBER

Identifier of API to be used to select destination subinventory
LOC_SELECTION_CRITERIA NUMBER

Locator Selection Criterion
PRE_SPECIFIED_LOC_ID NUMBER

Destination Locator Identifier
LOC_SELECTION_API_ID NUMBER

Identifier of API to be used to select destination locator
ACTIVITY_SEGMENT NUMBER

Not used
CREATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Date Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Date 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
LPN_SELECTION_CRITERIA NUMBER

To LPN Selection Criterion
LPN_SELECTION_API_ID NUMBER

API identifier, if To LPN is determined by API
LOC_MTRL_GRP_RULE_ID NUMBER

Locator material movement grouping rule identifier for this operation
LPN_MTRL_GRP_RULE_ID NUMBER

LPN material movement grouping rule identifier for this operation
IS_IN_INVENTORY VARCHAR2 (1)
Flag to indicate if the destination of this operation is in inventory or not
DEST_ZONE_SUG_METHOD VARCHAR2 (80)
Zone Selection Criterion description
DEST_SUB_SUG_METHOD VARCHAR2 (80)
Subinventory Selection Criterion description
DEST_LOC_SUG_METHOD VARCHAR2 (80)
Locator Selection Criterion description
DEST_LPN_SUG_METHOD VARCHAR2 (80)
To LPN Selection Criterion description
DROP_LPN_OPTION_NAME VARCHAR2 (80)
Drop LPN display flag description
LOC_MTRL_GRP_RULE VARCHAR2 (80)
Description of Locator material movement grouping rule for this operation
LPN_MTRL_GRP_RULE VARCHAR2 (80)
Description of LPN material movement grouping rule for this operation
OPERATION_NAME VARCHAR2 (80) Yes Operation Type description
LOC_DEST_SUG_API VARCHAR2 (240)
Description of API to be used to select destination locator
LPN_DEST_SUG_API VARCHAR2 (240)
Description of API, if To LPN is determined by API
ZONE_NAME VARCHAR2 (30)
Destination Zone name
LOC_CONCATENATED_SEGMENTS VARCHAR2 (1)
Destination Locator
SUBSEQUENT_OP_PLAN_NAME VARCHAR2 (255)
The outbound operation plan that follows this operation. Only applicable to crossdock operation.
SUBSEQUENT_OP_PLAN_ID NUMBER

ID for the outbound operation plan that follows this operation. Only applicable to crossdock operation.
CONSOL_METHOD_NAME VARCHAR2 (80)
Dictates whether material consolidation will be across delivery or not. Only applicable to outbound drop operations.
CONSOLIDATION_METHOD_ID NUMBER

ID for method that dictates whether material consolidation will be across delivery or not. Only applicable to outbound drop operations.
Query Text

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


SELECT OPERATION_PLAN_ID
,      OPERATION_PLAN_DETAIL_ID
,      OPERATION_TYPE
,      OPERATION_SEQUENCE
,      BULK_PICK_TYPE
,      DROP_LPN_OPTION
,      WAIT_FOR_GROUP_COMPLETION
,      SYSTEM_DISPATCHED
,      OP_SEGMENT_COMPLETED
,      ZONE_SELECTION_CRITERIA
,      PRE_SPECIFIED_ZONE_ID
,      ZONE_SELECTION_API_ID
,      SUB_SELECTION_CRITERIA
,      PRE_SPECIFIED_SUB_CODE
,      SUB_SELECTION_API_ID
,      LOC_SELECTION_CRITERIA
,      PRE_SPECIFIED_LOC_ID
,      LOC_SELECTION_API_ID
,      ACTIVITY_SEGMENT
,      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
,      LPN_SELECTION_CRITERIA
,      LPN_SELECTION_API_ID
,      LOC_MTRL_GRP_RULE_ID
,      LPN_MTRL_GRP_RULE_ID
,      IS_IN_INVENTORY
,      DEST_ZONE_SUG_METHOD
,      DEST_SUB_SUG_METHOD
,      DEST_LOC_SUG_METHOD
,      DEST_LPN_SUG_METHOD
,      DROP_LPN_OPTION_NAME
,      LOC_MTRL_GRP_RULE
,      LPN_MTRL_GRP_RULE
,      OPERATION_NAME
,      LOC_DEST_SUG_API
,      LPN_DEST_SUG_API
,      ZONE_NAME
,      LOC_CONCATENATED_SEGMENTS
,      SUBSEQUENT_OP_PLAN_NAME
,      SUBSEQUENT_OP_PLAN_ID
,      CONSOL_METHOD_NAME
,      CONSOLIDATION_METHOD_ID
FROM APPS.WMS_OP_PLAN_DETAILS_V;

Dependencies

[top of page]

APPS.WMS_OP_PLAN_DETAILS_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
ViewMTL_ITEM_LOCATIONS_KFV
SynonymWMS_API_HOOK_CALLS
SynonymWMS_OP_PLANS_B
ViewWMS_OP_PLANS_VL
SynonymWMS_OP_PLAN_DETAILS
SynonymWMS_ZONES_TL

APPS.WMS_OP_PLAN_DETAILS_V is not referenced by any database object