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: JMF.JMF_SHIKYU_REPLENISHMENTS

Object Details

Object Name:	JMF_SHIKYU_REPLENISHMENTS
Object Type:	TABLE
Owner:	JMF
FND Design Data:	JMF.JMF_SHIKYU_REPLENISHMENTS
Subobject Name:
Status:	VALID

JMF_SHIKYU_REPLENISHMENTS stores replenishment sales orders information created for the fulfilling requirements of a particular SHIKYU component item between a specific Origin Equipment Manufacturer (OEM) and Trading Partner Organization (TP) The corresponding replenishment purchase orders are also stored in this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JMF_SHIKYU_REPLENISHMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REPLENISHMENT_SO_LINE_ID
JMF_SHIKYU_REPLENISHMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPLENISHMENT_PO_SHIPMENT_ID
JMF_SHIKYU_REPLENISHMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPLENISHMENT_SO_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REPLENISHMENT_SO_LINE_ID	NUMBER		Yes	Unique identifier of the replenishment sales order line.
REPLENISHMENT_SO_HEADER_ID	NUMBER		Yes	Unique identifier of the replenishment sales order header.
SCHEDULE_SHIP_DATE	DATE			Scheduled ship date of the corresponding replenishment sales order line.
REPLENISHMENT_PO_HEADER_ID	NUMBER		Yes	Unique identifier of the associated replenishment purchase order header.
REPLENISHMENT_PO_LINE_ID	NUMBER		Yes	Unique identifier of the associated replenishment purchase order line.
REPLENISHMENT_PO_SHIPMENT_ID	NUMBER		Yes	Unique identifier of the associated replenishment purchase order shipment.
OEM_ORGANIZATION_ID	NUMBER		Yes	Organization ID of the Subcontracting Organization.
TP_ORGANIZATION_ID	NUMBER		Yes	Organization ID of the Manufacturing Partner (MP) or Trading Partner (TP)
TP_SUPPLIER_ID	NUMBER		Yes	Supplier ID corresponding to the Manufacturing Partner.
OSA_ITEM_PRICE	NUMBER			The price of the OSA Item, to be calculated by the Interlock SHIKYU concurrent program based on the sum of the components costs plus a service fee charged by the MP.
TP_SUPPLIER_SITE_ID	NUMBER		Yes	Supplier site ID corresponding to the Manufacturing Partner.
ALLOCATED_QUANTITY	NUMBER			Total quantity that has been allocated from this replenishment order line.
SHIKYU_COMPONENT_ID	NUMBER		Yes	Item ID of the SHIKYU component.
CURRENCY	VARCHAR2	(15)		Unique identifier for the currency corresponding to the price of the Outsourced Assembly.
ALLOCABLE_QUANTITY	NUMBER			Total quantity of this replenishment sales order line that can be allocated. Might be different from the ordered quantity if shipped quantity is greater than ordered quantity.
ORG_ID	NUMBER		Yes	Operating unit ID of the current replenishment order.
ORDERED_PRIMARY_UOM_QUANTITY	NUMBER			Ordered quantity in the primary UOM of the component item.
ALLOCATED_PRIMARY_UOM_QUANTITY	NUMBER			Total allocated quantity in the primary UOM of the component item.
ALLOCABLE_PRIMARY_UOM_QUANTITY	NUMBER			Total allocable quantity in the primary UOM of the component item.
ORDERED_QUANTITY	NUMBER			Ordered quantity of the current replenishment sales order line.
ADDITIONAL_SUPPLY	VARCHAR2	(1)		Flag that signifies whether this replenishment was created as an additional supply for manual allocations through the SHIKYU Workbench or for consumption adjustments. Values 'Y', 'N'.(NULL will be taken as 'N').
STATUS	VARCHAR2	(30)		Status of the replenishment sales order line. Is NULL initially, signifying that the line is still OPEN. Other statuses that are being tracked are CLOSED and CANCELLED.
UOM	VARCHAR2	(3)		UOM of this replenishment sales order line, in which the component items will be shipped in.
PRIMARY_UOM	VARCHAR2	(3)		Primary UOM code of the component to be shipped to the trading partner organization
REQUEST_ID	NUMBER			Standard Who column: the concurrent request that created or updated this record.
LAST_UPDATE_DATE	DATE			Standard Who column: date when this record was last updated
LAST_UPDATED_BY	NUMBER			Standard Who column: the user who last updated this record
CREATION_DATE	DATE			Standard Who column: date when this record was created
CREATED_BY	NUMBER			Standard Who column: the user who created this record
LAST_UPDATE_LOGIN	NUMBER			Standard Who column: identifies sign-on audit information of the user who last updated this record
PROGRAM_ID	NUMBER			Standard Who column: the concurrent program that created or updated this record
PROGRAM_UPDATE_DATE	DATE			Standard Who column: the date when this record was created or updated by a concurrent program
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column: the application that owns the concurrent program that created or updated this record

Query Text

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


SELECT REPLENISHMENT_SO_LINE_ID
,      REPLENISHMENT_SO_HEADER_ID
,      SCHEDULE_SHIP_DATE
,      REPLENISHMENT_PO_HEADER_ID
,      REPLENISHMENT_PO_LINE_ID
,      REPLENISHMENT_PO_SHIPMENT_ID
,      OEM_ORGANIZATION_ID
,      TP_ORGANIZATION_ID
,      TP_SUPPLIER_ID
,      OSA_ITEM_PRICE
,      TP_SUPPLIER_SITE_ID
,      ALLOCATED_QUANTITY
,      SHIKYU_COMPONENT_ID
,      CURRENCY
,      ALLOCABLE_QUANTITY
,      ORG_ID
,      ORDERED_PRIMARY_UOM_QUANTITY
,      ALLOCATED_PRIMARY_UOM_QUANTITY
,      ALLOCABLE_PRIMARY_UOM_QUANTITY
,      ORDERED_QUANTITY
,      ADDITIONAL_SUPPLY
,      STATUS
,      UOM
,      PRIMARY_UOM
,      REQUEST_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
FROM JMF.JMF_SHIKYU_REPLENISHMENTS;

Dependencies

[top of page]

JMF.JMF_SHIKYU_REPLENISHMENTS does not reference any database object

JMF.JMF_SHIKYU_REPLENISHMENTS is referenced by following:

APPS: JMF_SHIKYU_REPLENISHMENTS