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

TABLE: MSC.MSC_SUPDEM_LINES_INTERFACE

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


This is a staging table for all information directly loaded into Oracle Collaborative planning.
All transaction data e.g purchase orders, sales orders, order forecasts
loaded into Collaborative planning using flat file/XML loads is first loaded into this table. Appropriate validations are done on the data belonging to this table before they are
moved into the main transaction table MSC_SUP_DEM_ENTRIES.
Data defined using the manual order entry page in Oracle Collaborative planning is also
held in this table before it is moved to MSC_SUP_DEM_ENTRIES.
This table does not contain data collected from Oracle ERP or brought over to Collaborative
planning by the Publish programs in Oracle ASCP/DP.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_SUPDEM_LINES_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPARENT_HEADER_ID
ColumnLINE_ID
Columns
Name Datatype Length Mandatory Comments
PARENT_HEADER_ID NUMBER

Contains the header id to which the line is associated
LINE_ID NUMBER

Contains the line identifier generated by the sequence MSC_SUPDEM_LINES_S
QUANTITY NUMBER

Contains the quantity information
UOM VARCHAR2 (30)
Contains the UOM code
START_DATE VARCHAR2 (40)
Contains the start date of the uploaded data
END_DATE VARCHAR2 (40)
Contains the end date of uploaded data
ITEM_NAME VARCHAR2 (240)
Contains the publisher's item name
PUBLISHER_SITE_ID VARCHAR2 (20)
Contains the publisher's party identifier on the exchange
SUBSCRIBERS_XREF_NAME VARCHAR2 (240)
Contains the subscriber's cross reference name
BUCKET_TYPE VARCHAR2 (20)
Contains the bucket type information
ORDER_IDENTIFIER VARCHAR2 (240)
Stores the order number of the incoming record
PEGGING_ORDER_IDENTIFIER VARCHAR2 (240)
Stores the pegged order number
LINE_NUMBER VARCHAR2 (25)
Contains the line number of the record in the uploaded document
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
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ORDER_TYPE VARCHAR2 (240)
Contains the order type of the posted data
COMMENTS VARCHAR2 (1000)
Contains the comments string
NEW_DOCK_DATE VARCHAR2 (40)
Contains the date on which the order was received
NEW_SHIP_DATE VARCHAR2 (40)
Contains the date the item was shipped
NEW_ORDER_PLACEMENT_DATE VARCHAR2 (40)
Contains the date the order was created on the exchange
RELEASE_NUMBER VARCHAR2 (25)
Contains the release number of the order identifier
REF_LINE_NUMBER VARCHAR2 (25)
Contains the order line number of the pegged order
REF_RELEASE_NUMBER VARCHAR2 (25)
Contains the release number of the pegged order
PUBLISHER_ADDRESS VARCHAR2 (240)
Contains the publisher's address
SUBSCRIBER_ADDRESS VARCHAR2 (240)
Contains the subscriber's address
SHIP_TO_PARTY_NAME VARCHAR2 (255)
Contains the party's name to whom the shipment is billed
SHIP_TO_PARTY_ADDRESS VARCHAR2 (240)
Contains the address of the ship to party
SHIP_TO_ADDRESS VARCHAR2 (240)
Contains the address where the shipment is sent out
SHIP_FROM_PARTY_NAME VARCHAR2 (255)
Contains the name of the party that sends out the shipment
SHIP_FROM_PARTY_ADDRESS VARCHAR2 (240)
Contains the sending party's address
CARRIER_CODE VARCHAR2 (30)
Contains the carrier code
BILL_OF_LADING_NUMBER VARCHAR2 (30)
Contains the bill of lading number
TRACKING_NUMBER VARCHAR2 (240)
Contains the order tracking number
VEHICLE_NUMBER VARCHAR2 (30)
Contains the vehicle number
CONTAINER_TYPE VARCHAR2 (20)
Contains the container type
CONTAINER_QTY NUMBER

Holds the container quantity
END_ORDER_PUBLISHER_NAME VARCHAR2 (255)
Contains the end customer's name
END_ORDER_TYPE VARCHAR2 (240)
Contains the order type of the pegged order
REF_HEADER_ID NUMBER

Reference Header identifier
REF_LINE_ID NUMBER

Reference Line identifier
NEW_SCHEDULE_DATE VARCHAR2 (40)
New schedule date
NEW_SCHEDULE_END_DATE VARCHAR2 (40)
New schedule end date
PUBLISHER_COMPANY VARCHAR2 (255)
Publisher company
PUBLISHER_SITE VARCHAR2 (40)
Publisher site
CUSTOMER_COMPANY VARCHAR2 (255)
Customer company
CUSTOMER_SITE VARCHAR2 (40)
Customer site
SUPPLIER_COMPANY VARCHAR2 (255)
Supplier company
SUPPLIER_SITE VARCHAR2 (40)
Supplier site
CUSTOMER_ADDRESS VARCHAR2 (255)
Customer address
SUPPLIER_ADDRESS VARCHAR2 (255)
Supplier address
SHIP_TO_PARTY_SITE VARCHAR2 (40)
Ship to party site
SHIP_FROM_PARTY_SITE VARCHAR2 (40)
Ship from party site
SHIP_DATE VARCHAR2 (255)
Ship date
RECEIPT_DATE VARCHAR2 (255)
Receipt date
REQUEST_ID NUMBER

Concurrent Who column
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory code
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
ATTACHMENT_URL VARCHAR2 (240)
Attachment URL
SERIAL_NUMBER VARCHAR2 (255)
Serial number
SYNC_INDICATOR VARCHAR2 (1)
Sync indicator
POSTING_PARTY_NAME VARCHAR2 (255)
Posting party name
END_ORDER_PUBLISHER_SITE VARCHAR2 (40)
End order publisher site
KEY_DATE VARCHAR2 (40)
Key date
REQUEST_DATE VARCHAR2 (240)
Request date
KEY_END_DATE VARCHAR2 (40)
Key end date
ORIGINAL_PROMISED_DATE VARCHAR2 (40)
Original promised date
CUSTOMER_ITEM_NAME VARCHAR2 (250)
Customer item name
SUPPLIER_ITEM_NAME VARCHAR2 (250)
Supplier item name
OWNER_ITEM_NAME VARCHAR2 (250)
Owner item name
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
VERSION VARCHAR2 (240)
Version
DESIGNATOR VARCHAR2 (100)
Designator
CONTEXT VARCHAR2 (30)
Context
WIP_START_DATE VARCHAR2 (40)
Wip Start Date
WIP_END_DATE VARCHAR2 (40)
Wip End Date
DOCUMENT_NUMBER VARCHAR2 (240)
Document Number
RESPONSE_NUMBER VARCHAR2 (240)
Response Number
VMI_FLAG VARCHAR2 (1)
Vmi Flag
SHIPPING_CONTROL NUMBER

Shipping Control
DEMAND_CLASS VARCHAR2 (30)
Demand Class
Query Text

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


SELECT PARENT_HEADER_ID
,      LINE_ID
,      QUANTITY
,      UOM
,      START_DATE
,      END_DATE
,      ITEM_NAME
,      PUBLISHER_SITE_ID
,      SUBSCRIBERS_XREF_NAME
,      BUCKET_TYPE
,      ORDER_IDENTIFIER
,      PEGGING_ORDER_IDENTIFIER
,      LINE_NUMBER
,      ROW_STATUS
,      ERR_MSG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ORDER_TYPE
,      COMMENTS
,      NEW_DOCK_DATE
,      NEW_SHIP_DATE
,      NEW_ORDER_PLACEMENT_DATE
,      RELEASE_NUMBER
,      REF_LINE_NUMBER
,      REF_RELEASE_NUMBER
,      PUBLISHER_ADDRESS
,      SUBSCRIBER_ADDRESS
,      SHIP_TO_PARTY_NAME
,      SHIP_TO_PARTY_ADDRESS
,      SHIP_TO_ADDRESS
,      SHIP_FROM_PARTY_NAME
,      SHIP_FROM_PARTY_ADDRESS
,      CARRIER_CODE
,      BILL_OF_LADING_NUMBER
,      TRACKING_NUMBER
,      VEHICLE_NUMBER
,      CONTAINER_TYPE
,      CONTAINER_QTY
,      END_ORDER_PUBLISHER_NAME
,      END_ORDER_TYPE
,      REF_HEADER_ID
,      REF_LINE_ID
,      NEW_SCHEDULE_DATE
,      NEW_SCHEDULE_END_DATE
,      PUBLISHER_COMPANY
,      PUBLISHER_SITE
,      CUSTOMER_COMPANY
,      CUSTOMER_SITE
,      SUPPLIER_COMPANY
,      SUPPLIER_SITE
,      CUSTOMER_ADDRESS
,      SUPPLIER_ADDRESS
,      SHIP_TO_PARTY_SITE
,      SHIP_FROM_PARTY_SITE
,      SHIP_DATE
,      RECEIPT_DATE
,      REQUEST_ID
,      SUBINVENTORY_CODE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      ATTACHMENT_URL
,      SERIAL_NUMBER
,      SYNC_INDICATOR
,      POSTING_PARTY_NAME
,      END_ORDER_PUBLISHER_SITE
,      KEY_DATE
,      REQUEST_DATE
,      KEY_END_DATE
,      ORIGINAL_PROMISED_DATE
,      CUSTOMER_ITEM_NAME
,      SUPPLIER_ITEM_NAME
,      OWNER_ITEM_NAME
,      INVENTORY_ITEM_ID
,      VERSION
,      DESIGNATOR
,      CONTEXT
,      WIP_START_DATE
,      WIP_END_DATE
,      DOCUMENT_NUMBER
,      RESPONSE_NUMBER
,      VMI_FLAG
,      SHIPPING_CONTROL
,      DEMAND_CLASS
FROM MSC.MSC_SUPDEM_LINES_INTERFACE;

Dependencies

[top of page]

MSC.MSC_SUPDEM_LINES_INTERFACE does not reference any database object

MSC.MSC_SUPDEM_LINES_INTERFACE is referenced by following:

SchemaAPPS
SynonymMSC_SUPDEM_LINES_INTERFACE