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_PO_RESCHEDULE_INTERFACE

Object Details

Object Name:	MSC_PO_RESCHEDULE_INTERFACE
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_PO_RESCHEDULE_INTERFACE
Subobject Name:
Status:	VALID

MSC_PO_RESCHEDULE_INTERFACE temporarily stores quantity or need-by date
changes to requisition lines suggested by Oracle MSC. Each row includes the requisition line identifier, the new quantity, and the new need-by date for the
requisition line.
You run the Requisition Reschedule program to implement the changes.
Oracle Purchasing uses PROCESS_ID to designate all rows updated by a
single run of the Requisition Reschedule process.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_ID	NUMBER			Unique identifier for the requisition line
QUANTITY	NUMBER			New quantity for the requisition line
NEED_BY_DATE	DATE			New need-by date for the requisition line
PROCESS_ID	NUMBER			Process identifier
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER			Standard Who Column
CREATION_DATE	DATE			Standard Who Column
CREATED_BY	NUMBER			Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
REQUEST_ID	NUMBER			Concurrent Who Column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who Column
PROGRAM_ID	NUMBER			Concurrent Who Column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who Column
SR_INSTANCE_ID	NUMBER		Yes	Source application instance identifier
PURCHASE_ORDER_ID	VARCHAR2	(62)		Purchase Order Id
PO_NUMBER	VARCHAR2	(240)		Purchase Order Number
SOURCE_LINE_ID	NUMBER			Source Line Id
UOM	VARCHAR2	(3)		Unit of Measure
PLAN_ID	NUMBER			Plan Identifier
BATCH_ID	NUMBER			batch id

Query Text

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


SELECT LINE_ID
,      QUANTITY
,      NEED_BY_DATE
,      PROCESS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SR_INSTANCE_ID
,      PURCHASE_ORDER_ID
,      PO_NUMBER
,      SOURCE_LINE_ID
,      UOM
,      PLAN_ID
,      BATCH_ID
FROM MSC.MSC_PO_RESCHEDULE_INTERFACE;

Dependencies

[top of page]

MSC.MSC_PO_RESCHEDULE_INTERFACE does not reference any database object

MSC.MSC_PO_RESCHEDULE_INTERFACE is referenced by following:

MSC: MSC_PO_RESCHEDULE_INTERFACE#