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


VIEW: APPS.WSHFV_CONTAINER_CONTENTS

Object Details
Object Name: WSHFV_CONTAINER_CONTENTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSHFV_CONTAINER_CONTENTS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
DELIVERY_DETAIL_ID NUMBER
Yes Delivery Detail Id
CONTAINER_ID NUMBER

Container Id
CONTAINER_DESCRIPTION VARCHAR2 (250)
Container Description
DELIVERY_ID NUMBER

Delivery Id
SOURCE_HEADER_NUMBER VARCHAR2 (150)
Source Header Number
SOURCE_LINE_NUMBER VARCHAR2 (150)
Source Line Number
SOURCE_HEADER_ID NUMBER

Source Header Id
SOURCE_LINE_ID NUMBER
Yes Source Line Id
INVENTORY_ITEM_ID NUMBER

Inventory Item Id
_KF:INVENTORY_ITEM_ID CHAR (16)
Key Flexfield
ITEM_DESCRIPTION VARCHAR2 (250)
Item Description
PACKED_QUANTITY NUMBER
Yes Packed Quantity
UOM VARCHAR2 (3) Yes UOM
Query Text

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


SELECT DELIVERY_DETAIL_ID
,      CONTAINER_ID
,      CONTAINER_DESCRIPTION
,      DELIVERY_ID
,      SOURCE_HEADER_NUMBER
,      SOURCE_LINE_NUMBER
,      SOURCE_HEADER_ID
,      SOURCE_LINE_ID
,      INVENTORY_ITEM_ID
,      _KF:INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      PACKED_QUANTITY
,      UOM
FROM APPS.WSHFV_CONTAINER_CONTENTS;

Dependencies

[top of page]

APPS.WSHFV_CONTAINER_CONTENTS references the following:

SchemaAPPS
SynonymMTL_SYSTEM_ITEMS
SynonymWSH_DELIVERY_ASSIGNMENTS
SynonymWSH_DELIVERY_DETAILS

APPS.WSHFV_CONTAINER_CONTENTS is not referenced by any database object