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: PO.PO_RESCHEDULE_INTERFACE

Object Details

Object Name:	PO_RESCHEDULE_INTERFACE
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.PO_RESCHEDULE_INTERFACE
Subobject Name:
Status:	VALID

PO_RESCHEDULE_INTERFACE temporarily stores quantity or need-by date
changes to requisition lines suggested by Oracle Master Scheduling/MRP. You insert one
row into the PO_RESCHEDULE_INTERFACE table for each change you want to
make to a requisition. 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. You should not use
this column.
.
PO_RESCHEDULE_INTERFACE (poimp.odf)
Scope: public
Product: PO
Display Name: PO Reschedule Interface
Category: BUSINESS_ENTITY PO_PURCHASE_REQUISITION
Category: BUSINESS_ENTITY PO_INTERNAL_REQUISITION

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_RESCHEDULE_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_ID	NUMBER		Yes	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			Number of the reschedule process that processed the record
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER			Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
ORIG_QUANTITY	NUMBER			Quantity before reschedule
ORIG_NEED_BY_DATE	DATE			Need by date before reschedule
AUCTION_HEADER_ID	NUMBER			Reference to sourcing auction number
AUCTION_DISPLAY_NUMBER	VARCHAR2	(40)		Reference to sourcing auction number
SHIP_METHOD	VARCHAR2	(30)		Ship method (References WSH_CARRIER_SERVICES.ship_method_code.)
ESTIMATED_PICKUP_DATE	DATE			Estimated pickup date.

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
,      ORIG_QUANTITY
,      ORIG_NEED_BY_DATE
,      AUCTION_HEADER_ID
,      AUCTION_DISPLAY_NUMBER
,      SHIP_METHOD
,      ESTIMATED_PICKUP_DATE
FROM PO.PO_RESCHEDULE_INTERFACE;

Dependencies

[top of page]

PO.PO_RESCHEDULE_INTERFACE does not reference any database object

PO.PO_RESCHEDULE_INTERFACE is referenced by following:

APPS: PO_RESCHEDULE_INTERFACE