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_ADJUSTMENTS

Object Details

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

JMF_SHIKYU_ADJUSTMENTS stores adjustment data to be processed by the consumption adjustment concurrent program.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JMF_SHIKYU_ADJUSTMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ADJUSTMENT_ID
JMF_SHIKYU_ADJUSTMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUBCONTRACT_PO_SHIPMENT_ID SHIKYU_COMPONENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ADJUSTMENT_ID	NUMBER		Yes	Sequence generated unique identifier of the component consumption adjustment
SUBCONTRACT_PO_SHIPMENT_ID	NUMBER		Yes	Unique identifier of the subcontracting order shipment for which the replenishment was created
SHIKYU_COMPONENT_ID	NUMBER		Yes	Item ID of the Subcontracting component
ADJUSTMENT	NUMBER			Consumption adjustment amount
UOM	VARCHAR2	(3)		Unit of Measure (UOM) of the Subcontracting component
REASON	VARCHAR2	(200)		Reason for the adjustment
REQUEST_ID	NUMBER			The request ID of the concurrent request running the adjustment concurrent program.
BATCH_ID	NUMBER			ID to group records to be processed in batches
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 (References FND_USERS.user_id)
CREATION_DATE	DATE			Standard Who column - date when this record was created
CREATED_BY	NUMBER			Standard Who column - the user who created this record. (References FND_USERS.user_id)
LAST_UPDATE_LOGIN	NUMBER			Standard Who column - identifies sign-on audit information of the user who last updated this record. (References FND_LOGINS.login_id)
PROGRAM_ID	NUMBER			Standard Who column - the concurrent program that created or updated this record (References FND_CONCURRENT_PROGRAMS.concurrent_program_id)
PROGRAM_UPDATE_DATE	DATE			Standard Who column - the date when this record was created or updated
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 ADJUSTMENT_ID
,      SUBCONTRACT_PO_SHIPMENT_ID
,      SHIKYU_COMPONENT_ID
,      ADJUSTMENT
,      UOM
,      REASON
,      REQUEST_ID
,      BATCH_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_ADJUSTMENTS;

Dependencies

[top of page]

JMF.JMF_SHIKYU_ADJUSTMENTS does not reference any database object

JMF.JMF_SHIKYU_ADJUSTMENTS is referenced by following:

JMF: JMF_SHIKYU_ADJUSTMENTS#