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

VIEW: APPS.WMS_PACKING_MATERIAL_V

Object Details
Object Name: WMS_PACKING_MATERIAL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWMS.WMS_PACKING_MATERIAL_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
MOVE_ORDER_HEADER_ID NUMBER

Move Order Header ID
MOVE_ORDER_LINE_ID NUMBER

Move Order Line ID
REFERENCE VARCHAR2 (240)
Reference
REFERENCE_ID NUMBER

Reference ID
TXN_SOURCE_ID NUMBER

Transaction Source ID
DELIVERY_DETAIL_ID NUMBER

Delivery Detail ID
ORGANIZATION_ID NUMBER

Organization ID
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code
SUBINVENTORY VARCHAR2 (10)
Subinventory
LOCATOR_ID NUMBER

Locator ID
LOCATOR VARCHAR2 (204)
Locator
PROJECT_ID NUMBER

Project ID
PROJECT VARCHAR2 (30)
Project
TASK_ID NUMBER

Task ID
TASK_NUMBER VARCHAR2 (25)
Task Number
TASK_NAME VARCHAR2 (20)
Task Name
INVENTORY_ITEM_ID NUMBER

Item ID
ITEM VARCHAR2 (40)
Item
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
LPN_ID NUMBER

LPN ID
LPN VARCHAR2 (30)
LPN
PARENT_LPN_ID NUMBER

Parent LPN ID
PARENT_LPN VARCHAR2 (30)
Parent LPN
OUTERMOST_LPN_ID NUMBER

Outermost LPN ID
OUTERMOST_LPN VARCHAR2 (30)
Outermost LPN ID
REVISION VARCHAR2 (3)
Revision
UOM VARCHAR2 (3)
UOM
LOT_NUMBER VARCHAR2 (80)
Lot Number
QUANTITY NUMBER

Quantity
DELIVERY_ID NUMBER

Delivery ID
DELIVERY VARCHAR2 (30)
Delivery
DELIVERY_COMPLETED VARCHAR2 (1)
Whether Delivery is completed
TRIP_ID NUMBER

Trip ID
TRIP VARCHAR2 (30)
Trip
CARRIER_ID NUMBER

Carrier ID
CARRIER VARCHAR2 (360)
Carrier
ORDER_HEADER_ID NUMBER

Order Header ID
ORDER_NUMBER VARCHAR2 (150)
Order Number
ORDER_LINE_ID NUMBER

Order line ID
ORDER_LINE_NUM VARCHAR2 (150)
Order Line Number
PACKING_INSTRUCTION VARCHAR2 (2000)
Packing Instruction
CUSTOMER_ID NUMBER

Customer ID
CUSTOMER_NUMBER VARCHAR2 (30)
Customer Number
CUSTOMER_NAME VARCHAR2 (360)
Customer Name
SHIP_TO_LOCATION_ID NUMBER

Ship to location ID
SHIP_TO_LOCATION VARCHAR2 (60)
Ship to location
RECEIPT_NUM VARCHAR2 (30)
Receipt Number
DOCUMENT_TYPE VARCHAR2 (20)
Document Type
DOCUMENT_ID NUMBER

Document ID
DOCUMENT_NUMBER VARCHAR2 (50)
Document Number
DOCUMENT_LINE_ID NUMBER

Document Line ID
DOCUMENT_LINE_NUM NUMBER

Document line number
VENDOR_ID NUMBER

Vendor ID
SOURCE_ORG_ID NUMBER

Source organization ID
TRADING_PARTNER VARCHAR2 (240)
Trading Partner
RECEIVING_LOCATION_ID NUMBER

Inbound receiving location ID
RECEIVING_LOCATION VARCHAR2 (60)
Inbound receiving location
PTO_FLAG VARCHAR2 (1)
Flag indicating whether this is a PTO item
SELECTED_FLAG VARCHAR2 (1)
Flag to show whether this record is selected
SHIP_SET_ID NUMBER

Ship set identifier
SHIP_SET VARCHAR2 (30)
Ship Set
SECONDARY_QUANTITY NUMBER

Secondary Quantity
SECONDARY_UOM_CODE VARCHAR2 (3)
Secondary uom code
GRADE_CODE VARCHAR2 (150)
Grade
Query Text

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


SELECT MOVE_ORDER_HEADER_ID
,      MOVE_ORDER_LINE_ID
,      REFERENCE
,      REFERENCE_ID
,      TXN_SOURCE_ID
,      DELIVERY_DETAIL_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      SUBINVENTORY
,      LOCATOR_ID
,      LOCATOR
,      PROJECT_ID
,      PROJECT
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      INVENTORY_ITEM_ID
,      ITEM
,      ITEM_DESCRIPTION
,      LPN_ID
,      LPN
,      PARENT_LPN_ID
,      PARENT_LPN
,      OUTERMOST_LPN_ID
,      OUTERMOST_LPN
,      REVISION
,      UOM
,      LOT_NUMBER
,      QUANTITY
,      DELIVERY_ID
,      DELIVERY
,      DELIVERY_COMPLETED
,      TRIP_ID
,      TRIP
,      CARRIER_ID
,      CARRIER
,      ORDER_HEADER_ID
,      ORDER_NUMBER
,      ORDER_LINE_ID
,      ORDER_LINE_NUM
,      PACKING_INSTRUCTION
,      CUSTOMER_ID
,      CUSTOMER_NUMBER
,      CUSTOMER_NAME
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      RECEIPT_NUM
,      DOCUMENT_TYPE
,      DOCUMENT_ID
,      DOCUMENT_NUMBER
,      DOCUMENT_LINE_ID
,      DOCUMENT_LINE_NUM
,      VENDOR_ID
,      SOURCE_ORG_ID
,      TRADING_PARTNER
,      RECEIVING_LOCATION_ID
,      RECEIVING_LOCATION
,      PTO_FLAG
,      SELECTED_FLAG
,      SHIP_SET_ID
,      SHIP_SET
,      SECONDARY_QUANTITY
,      SECONDARY_UOM_CODE
,      GRADE_CODE
FROM APPS.WMS_PACKING_MATERIAL_V;

Dependencies

[top of page]

APPS.WMS_PACKING_MATERIAL_V references the following:

SchemaAPPS
SynonymWMS_PACKING_MATERIAL_GTEMP

APPS.WMS_PACKING_MATERIAL_V is not referenced by any database object