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

TABLE: MSC.MSC_ST_SERIAL_NUMBERS

Object Details
Object Name: MSC_ST_SERIAL_NUMBERS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_ST_SERIAL_NUMBERS
Subobject Name:
Status: VALID


The staging table used by the collection program to validate and process data for table MSC_SERIAL_NUMBERS.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SYNC_INDICATOR VARCHAR2 (1)
Flag to indicate whether the row is being deleted or inserted/updated - D:delete, R:insert/update.
PUBLISHER_ID NUMBER

Identifier of the publisher of onhand.
PUBLISHER_SITE_ID NUMBER

Identifier of site of the publisher of onhand.
INVENTORY_ITEM_ID NUMBER

Inventory item identifier.
PUBLISHER_COMPANY VARCHAR2 (255)
Name of the publisher of onhand.
PUBLISHER_SITE VARCHAR2 (30)
Name of site of the publisher of onhand.
ORDER_TYPE VARCHAR2 (240)
Order type of the transaction. The only allowed value is "Unallocated Onhand"
MASTER_ITEM_NAME VARCHAR2 (240)
Master item name.
PUBLISHER_ITEM_NAME VARCHAR2 (250)
Publisher's item name.
SERIAL_TXN_ID NUMBER

Transaction identifier for the onhand.
SERIAL_NUMBER VARCHAR2 (255)
Serial number of the unit.
ATTACHMENT_URL VARCHAR2 (255)
URL pointing to attachment.
USER_DEFINED1 VARCHAR2 (255)
Generic user defined field.
USER_DEFINED2 VARCHAR2 (255)
Generic user defined field.
USER_DEFINED3 VARCHAR2 (255)
Generic user defined field.
USER_DEFINED4 VARCHAR2 (255)
Generic user defined field.
USER_DEFINED5 VARCHAR2 (255)
Generic user defined field.
USER_DEFINED6 VARCHAR2 (255)
Generic user defined field.
USER_DEFINED7 VARCHAR2 (255)
Generic user defined field.
USER_DEFINED8 VARCHAR2 (255)
Generic user defined field.
USER_DEFINED9 VARCHAR2 (255)
Generic user defined field.
USER_DEFINED10 VARCHAR2 (255)
Generic user defined field.
LINE_ID NUMBER

Contains the line identifier.
PARENT_HEADER_ID NUMBER

Contains the header id to which the line is associated - generated through sequence MSC_SUPDEM_HEAD_S.
REQUEST_ID NUMBER

Concurrent Who column.
ROW_STATUS NUMBER

Contains the status after the load API has validated the record.
ERR_MSG VARCHAR2 (1000)
Contains the error message string if the record fails validation.
CREATION_DATE DATE

Contains the error message string if the record fails validation.
CREATED_BY NUMBER

Standard Who column.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER

Standard Who column.
LAST_UPDATE_LOGIN NUMBER

Standard Who column.
CONTEXT VARCHAR2 (30)
Descriptive flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment.
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment.
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment.
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment.
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment.
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment.
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment.
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment.
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment.
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment.
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment.
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment.
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment.
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment.
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment.
Query Text

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


SELECT SYNC_INDICATOR
,      PUBLISHER_ID
,      PUBLISHER_SITE_ID
,      INVENTORY_ITEM_ID
,      PUBLISHER_COMPANY
,      PUBLISHER_SITE
,      ORDER_TYPE
,      MASTER_ITEM_NAME
,      PUBLISHER_ITEM_NAME
,      SERIAL_TXN_ID
,      SERIAL_NUMBER
,      ATTACHMENT_URL
,      USER_DEFINED1
,      USER_DEFINED2
,      USER_DEFINED3
,      USER_DEFINED4
,      USER_DEFINED5
,      USER_DEFINED6
,      USER_DEFINED7
,      USER_DEFINED8
,      USER_DEFINED9
,      USER_DEFINED10
,      LINE_ID
,      PARENT_HEADER_ID
,      REQUEST_ID
,      ROW_STATUS
,      ERR_MSG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM MSC.MSC_ST_SERIAL_NUMBERS;

Dependencies

[top of page]

MSC.MSC_ST_SERIAL_NUMBERS does not reference any database object

MSC.MSC_ST_SERIAL_NUMBERS is referenced by following:

SchemaMSC
ViewMSC_ST_SERIAL_NUMBERS#