eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: WMS.WMS_ASN_DETAILS

Object Details

Object Name:	WMS_ASN_DETAILS
Object Type:	TABLE
Owner:	WMS
FND Design Data:	WMS.WMS_ASN_DETAILS
Subobject Name:
Status:	VALID

Stored the WMS related information about the ASN shipped

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WMS_ASN_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID SHIPMENT_NUM ITEM_ID DISCREPANCY_REPORTING_CONTEXT DISCREPANCY_STATUS
WMS_ASN_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID TRANSACTION_DATE
WMS_ASN_DETAILS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID VENDOR_ID VENDOR_SITE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_ID	NUMBER			Stores the group id same as that on the receiving interface for processing the records for the group related to the ASN being processed
SHIPMENT_NUM	VARCHAR2	(30)		Shipment Number on the ASN
ORGANIZATION_ID	NUMBER			Organization Id on the ASN
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
DISCREPANCY_REPORTING_CONTEXT	VARCHAR2	(25)		Discrepancy Reporting Context.I- for Item, L - For LPN, O- For Lot, S- Serial
ITEM_ID	NUMBER			Item Id for ASN
QUANTITY_EXPECTED	NUMBER			Quantity Expected for ASN/item
QUANTITY_ACTUAL	NUMBER			Quantity Received for ASN/item
UNIT_OF_MEASURE_EXPECTED	VARCHAR2	(25)		Unit of Measure Expected for ASN/item
UNIT_OF_MEASURE_ACTUAL	VARCHAR2	(25)		Unit of Measure Actual for ASN/item
LPN_EXPECTED	VARCHAR2	(30)		License Plate Number Expected for ASN
LPN_ACTUAL	VARCHAR2	(30)		License Plate Number Received for ASN
ITEM_REVISION_EXPECTED	VARCHAR2	(3)		Item Revision Expected for ASN
ITEM_REVISION_ACTUAL	VARCHAR2	(3)		Item Revision received for ASN
LOT_NUMBER_EXPECTED	VARCHAR2	(80)		Lot Number Expected for ASN
LOT_NUMBER_ACTUAL	VARCHAR2	(80)		Lot Number Received for ASN
SERIAL_NUMBER_EXPECTED	VARCHAR2	(30)		Serial Number Expected for ASN
SERIAL_NUMBER_ACTUAL	VARCHAR2	(30)		Serial Number received for ASN
VENDOR_ID	NUMBER			Vendor Id for ASN
VENDOR_SITE_ID	NUMBER			Vendor Site Id for ASN
TRANSACTION_DATE	DATE			Date when ASN is received/transacted
DISCREPANCY_STATUS	VARCHAR2	(1)		Discrepnacy reporting Status for ASNE- Entered, F-Failure, S-Success

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 does not reference any database object

WMS.WMS_ASN_DETAILS is referenced by following:

APPS: WMS_ASN_DETAILS