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

VIEW: WMS.WMS_ASN_DETAILS#

Object Details
Object Name: WMS_ASN_DETAILS#
Object Type: VIEW
Owner: WMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER

SHIPMENT_NUM VARCHAR2 (30)
ORGANIZATION_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

DISCREPANCY_REPORTING_CONTEXT VARCHAR2 (25)
ITEM_ID NUMBER

QUANTITY_EXPECTED NUMBER

QUANTITY_ACTUAL NUMBER

UNIT_OF_MEASURE_EXPECTED VARCHAR2 (25)
UNIT_OF_MEASURE_ACTUAL VARCHAR2 (25)
LPN_EXPECTED VARCHAR2 (30)
LPN_ACTUAL VARCHAR2 (30)
ITEM_REVISION_EXPECTED VARCHAR2 (3)
ITEM_REVISION_ACTUAL VARCHAR2 (3)
LOT_NUMBER_EXPECTED VARCHAR2 (80)
LOT_NUMBER_ACTUAL VARCHAR2 (80)
SERIAL_NUMBER_EXPECTED VARCHAR2 (30)
SERIAL_NUMBER_ACTUAL VARCHAR2 (30)
VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

TRANSACTION_DATE DATE

DISCREPANCY_STATUS VARCHAR2 (1)
Query Text

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


SELECT GROUP_ID
,      SHIPMENT_NUM
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DISCREPANCY_REPORTING_CONTEXT
,      ITEM_ID
,      QUANTITY_EXPECTED
,      QUANTITY_ACTUAL
,      UNIT_OF_MEASURE_EXPECTED
,      UNIT_OF_MEASURE_ACTUAL
,      LPN_EXPECTED
,      LPN_ACTUAL
,      ITEM_REVISION_EXPECTED
,      ITEM_REVISION_ACTUAL
,      LOT_NUMBER_EXPECTED
,      LOT_NUMBER_ACTUAL
,      SERIAL_NUMBER_EXPECTED
,      SERIAL_NUMBER_ACTUAL
,      VENDOR_ID
,      VENDOR_SITE_ID
,      TRANSACTION_DATE
,      DISCREPANCY_STATUS
FROM WMS.WMS_ASN_DETAILS#;

Dependencies

[top of page]

WMS.WMS_ASN_DETAILS# references the following:

SchemaWMS
TableWMS_ASN_DETAILS
WMS.WMS_ASN_DETAILS# is referenced by following:

SchemaAPPS
SynonymWMS_ASN_DETAILS