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: MSC.MSC_SUPDEM_LINES_INTERFACE

Object Details

Object Name:	MSC_SUPDEM_LINES_INTERFACE
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.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:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_SUPDEM_LINES_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PARENT_HEADER_ID LINE_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:

APPS: MSC_SUPDEM_LINES_INTERFACE