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

TABLE: CLN.M4R_WSM_DWIP_HDR_STAGING

Object Details
Object Name: M4R_WSM_DWIP_HDR_STAGING
Object Type: TABLE
Owner: CLN
FND Design Data: TableCLN.M4R_WSM_DWIP_HDR_STAGING
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
M4R_WSM_DWIP_HDR_STAGING_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnHDR_ID
M4R_WSM_DWIP_HDR_STAGING_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMSG_ID
Columns
Name Datatype Length Mandatory Comments
MSG_ID NUMBER
Yes Internal Control Number of the message, which is unique to the message
HDR_ID NUMBER
Yes Running Sequence Number
GROUP_ID NUMBER

Group ID of the data in the WSM interface tables
TRANSACTION_DATE DATE

Transaction Date
TRANSACTION_TYPE VARCHAR2 (30) Yes
MANUFACTURED_LOC_CODE VARCHAR2 (30)
Location Code of Manufacturer
ADDITIONAL_TEXT VARCHAR2 (255)
Contains Account Number and Starting Lot Revision Number
FIRST_UNIT_START_DATE DATE

Starting Date of Work
PREV_OPERATION_SEQ_NUM VARCHAR2 (30)
Previous Operation Sequence Number
OPERATION_SEQ_NUM VARCHAR2 (30)
Operation Sequence Number
STATUS_CHANGE_CODE VARCHAR2 (255)
Status Change Code
REASON_CODE VARCHAR2 (255)
Reason Code
LOT_NUMBER VARCHAR2 (255)
Lot Number
SCHEDULED_COMPLETION_DATE DATE

Scheduled Completion date
SCHEDULED_START_DATE DATE

Scheduled Start date
PREV_LOT_NUMBER VARCHAR2 (255)
Previous Lot Number
PREV_LOT_CLASSIFICATION_CODE VARCHAR2 (255)
Previous Lot classification Code
PREV_LOT_UOM VARCHAR2 (30)
Previous Lot UOM
PREV_LOT_QTY NUMBER

Previous Lot Quantity
PRIMARY_ITEM_CODE VARCHAR2 (255)
Inventory Item of the Previous Lot
PRIMARY_ITEM_REVISION VARCHAR2 (3)
Inventory Items Revision
STARTING_LOT_ITEM_CODE VARCHAR2 (255)
Inventory Item of the present Lot
TRANSFER_TO_LOC_CODE VARCHAR2 (30)
Transfer to Location Code
ALT_ROUTING_DESIGNATOR VARCHAR2 (30)
Alternate Routing Designator for the Job
FROM_SUB_INVENTORY VARCHAR2 (30)
Sub Inventory in which the lot is present
TO_SUB_INVENTORY VARCHAR2 (30)
Sub Inventory to which teh item has to be moved
LOT_CODE VARCHAR2 (30)
Representative flag. Y if the Job is the representative Job
TRANSFER_FROM_ORG VARCHAR2 (3)
Transfer from Organisation
TRANSFER_TO_ORG VARCHAR2 (3)
Transfer to Organization
STATUS_FLAG VARCHAR2 (2)
Status of the transaction
ERROR_MESSAGE VARCHAR2 (255)
Error Messages got after transaction proecssing
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 does not reference any database object

CLN.M4R_WSM_DWIP_HDR_STAGING is referenced by following:

SchemaAPPS
SynonymM4R_WSM_DWIP_HDR_STAGING