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: TableJMF.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JMF_SHIKYU_ADJUSTMENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnADJUSTMENT_ID
JMF_SHIKYU_ADJUSTMENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUBCONTRACT_PO_SHIPMENT_ID
ColumnSHIKYU_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:

SchemaAPPS
SynonymJMF_SHIKYU_ADJUSTMENTS