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]

VIEW: CLN.M4R_WSM_DWIP_HDR_STAGING#

Object Details

Object Name:	M4R_WSM_DWIP_HDR_STAGING#
Object Type:	VIEW
Owner:	CLN
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
MSG_ID	NUMBER		Yes
HDR_ID	NUMBER		Yes
GROUP_ID	NUMBER
TRANSACTION_DATE	DATE
TRANSACTION_TYPE	VARCHAR2	(30)	Yes
MANUFACTURED_LOC_CODE	VARCHAR2	(30)
ADDITIONAL_TEXT	VARCHAR2	(255)
FIRST_UNIT_START_DATE	DATE
PREV_OPERATION_SEQ_NUM	VARCHAR2	(30)
OPERATION_SEQ_NUM	VARCHAR2	(30)
STATUS_CHANGE_CODE	VARCHAR2	(255)
REASON_CODE	VARCHAR2	(255)
LOT_NUMBER	VARCHAR2	(255)
SCHEDULED_COMPLETION_DATE	DATE
SCHEDULED_START_DATE	DATE
PREV_LOT_NUMBER	VARCHAR2	(255)
PREV_LOT_CLASSIFICATION_CODE	VARCHAR2	(255)
PREV_LOT_UOM	VARCHAR2	(30)
PREV_LOT_QTY	NUMBER
PRIMARY_ITEM_CODE	VARCHAR2	(255)
PRIMARY_ITEM_REVISION	VARCHAR2	(3)
STARTING_LOT_ITEM_CODE	VARCHAR2	(255)
TRANSFER_TO_LOC_CODE	VARCHAR2	(30)
ALT_ROUTING_DESIGNATOR	VARCHAR2	(30)
FROM_SUB_INVENTORY	VARCHAR2	(30)
TO_SUB_INVENTORY	VARCHAR2	(30)
LOT_CODE	VARCHAR2	(30)
TRANSFER_FROM_ORG	VARCHAR2	(3)
TRANSFER_TO_ORG	VARCHAR2	(3)
STATUS_FLAG	VARCHAR2	(2)
ERROR_MESSAGE	VARCHAR2	(255)
CUSTOM_VALID_STATUS	VARCHAR2	(10)
STARTING_LOT_ITEM_REVISION	VARCHAR2	(3)
START_LOT_ALT_ROUT_DESIGNATOR	VARCHAR2	(30)
ROUTING_PATH	NUMBER	(1)

Query Text

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


SELECT MSG_ID
,      HDR_ID
,      GROUP_ID
,      TRANSACTION_DATE
,      TRANSACTION_TYPE
,      MANUFACTURED_LOC_CODE
,      ADDITIONAL_TEXT
,      FIRST_UNIT_START_DATE
,      PREV_OPERATION_SEQ_NUM
,      OPERATION_SEQ_NUM
,      STATUS_CHANGE_CODE
,      REASON_CODE
,      LOT_NUMBER
,      SCHEDULED_COMPLETION_DATE
,      SCHEDULED_START_DATE
,      PREV_LOT_NUMBER
,      PREV_LOT_CLASSIFICATION_CODE
,      PREV_LOT_UOM
,      PREV_LOT_QTY
,      PRIMARY_ITEM_CODE
,      PRIMARY_ITEM_REVISION
,      STARTING_LOT_ITEM_CODE
,      TRANSFER_TO_LOC_CODE
,      ALT_ROUTING_DESIGNATOR
,      FROM_SUB_INVENTORY
,      TO_SUB_INVENTORY
,      LOT_CODE
,      TRANSFER_FROM_ORG
,      TRANSFER_TO_ORG
,      STATUS_FLAG
,      ERROR_MESSAGE
,      CUSTOM_VALID_STATUS
,      STARTING_LOT_ITEM_REVISION
,      START_LOT_ALT_ROUT_DESIGNATOR
,      ROUTING_PATH
FROM CLN.M4R_WSM_DWIP_HDR_STAGING#;

Dependencies

[top of page]

CLN.M4R_WSM_DWIP_HDR_STAGING# references the following:

CLN: M4R_WSM_DWIP_HDR_STAGING

CLN.M4R_WSM_DWIP_HDR_STAGING# is referenced by following:

APPS: M4R_WSM_DWIP_HDR_STAGING