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

VIEW: APPS.OKX_PACKING_V

Object Details
Object Name: OKX_PACKING_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_PACKING_V
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


Displays information about containers during shipping confirm.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ID1 NUMBER
Yes Container identifier
ID2 CHAR (1)
DELIVERY_ID NUMBER

Delivery identifier
CONTAINER_INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier for the container
QUANTITY NUMBER
Yes Number of containers
ORGANIZATION_ID NUMBER

Organization identifier
NAME VARCHAR2 (40)
DESCRIPTION VARCHAR2 (347)
STATUS CHAR (1)
Status
START_DATE_ACTIVE DATE

END_DATE_ACTIVE VARCHAR2 (0)
Query Text

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


SELECT ID1
,      ID2
,      DELIVERY_ID
,      CONTAINER_INVENTORY_ITEM_ID
,      QUANTITY
,      ORGANIZATION_ID
,      NAME
,      DESCRIPTION
,      STATUS
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
FROM APPS.OKX_PACKING_V;

Dependencies

[top of page]

APPS.OKX_PACKING_V references the following:

SchemaAPPS
SynonymMTL_SYSTEM_ITEMS_B
SynonymMTL_SYSTEM_ITEMS_TL
SynonymWSH_PACKED_CONTAINERS

APPS.OKX_PACKING_V is not referenced by any database object