DBA Data[Home] [Help] [Dependency Information]

TABLE: GMF.GMF_LOT_COST_ADJUSTMENTS

Object Details
Object Name: GMF_LOT_COST_ADJUSTMENTS
Object Type: TABLE
Owner: GMF
FND Design Data: TableGMF.GMF_LOT_COST_ADJUSTMENTS
Subobject Name:
Status: VALID


OPM Lot Cost Adjustments header table


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMF_LOT_COST_ADJS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnADJUSTMENT_ID
GMF_LOT_COST_ADJS_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEGAL_ENTITY_ID
ColumnCOST_TYPE_ID
ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
ColumnLOT_NUMBER
ColumnADJUSTMENT_DATE
GMF_LOT_COST_ADJUSTMENTS_N1 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCASE "GL_POSTED_IND" WHEN 0 THEN 0 ELSE NULL END
Columns
Name Datatype Length Mandatory Comments
ADJUSTMENT_ID NUMBER (15) Yes Surrogate ID for Lot Cost Adjustment
CO_CODE VARCHAR2 (4)
Company for which adjustment is specified
COST_MTHD_CODE VARCHAR2 (4)
Lot Cost Method for which adjustment is specified
ITEM_ID NUMBER (15)
Surrogate for Item for which adjustment is specified
WHSE_CODE VARCHAR2 (4)
Warehouse for which adjustment is specified
LOT_ID NUMBER (15)
Surrogate for Lot/Sublot for which adjustment is specified
ADJUSTMENT_DATE DATE
Yes Date on which adjustment is applicable
REASON_CODE VARCHAR2 (4) Yes Reason for the Adjustment
APPLIED_IND VARCHAR2 (1)
Indicates if Adjustment is applied or not
GL_POSTED_IND NUMBER (5)
GL posted indicator. 0=Not posted to GL, 1=Posted to GL
OLD_COST_HEADER_ID NUMBER (15)
Surrogate to Lot Costs - gmf_lot_costs.header_id - for a quick access join
NEW_COST_HEADER_ID NUMBER (15)
Surrogate to Lot Costs - gmf_lot_costs.header_id - for a quick access join
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
REQUEST_ID NUMBER (15)
Concurrent who column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent who column
PROGRAM_ID NUMBER (15)
Concurrent who column
PROGRAM_UPDATE_DATE DATE

Concurrent who column
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE21 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE22 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE23 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE24 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE25 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE26 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE27 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE28 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE29 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE30 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ONHAND_QTY NUMBER

Onhand Quantity at the time of Lot Cost Adjustment
COST_TYPE_ID NUMBER (15)
Cost type identifier
INVENTORY_ITEM_ID NUMBER (15)
Item identifier
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity identifier
LOT_NUMBER VARCHAR2 (80)
Lot Number
ORGANIZATION_ID NUMBER (15)
Inventory Organization identifier
Query Text

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


SELECT ADJUSTMENT_ID
,      CO_CODE
,      COST_MTHD_CODE
,      ITEM_ID
,      WHSE_CODE
,      LOT_ID
,      ADJUSTMENT_DATE
,      REASON_CODE
,      APPLIED_IND
,      GL_POSTED_IND
,      OLD_COST_HEADER_ID
,      NEW_COST_HEADER_ID
,      DELETE_MARK
,      TEXT_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      ONHAND_QTY
,      COST_TYPE_ID
,      INVENTORY_ITEM_ID
,      LEGAL_ENTITY_ID
,      LOT_NUMBER
,      ORGANIZATION_ID
FROM GMF.GMF_LOT_COST_ADJUSTMENTS;

Dependencies

[top of page]

GMF.GMF_LOT_COST_ADJUSTMENTS does not reference any database object

GMF.GMF_LOT_COST_ADJUSTMENTS is referenced by following:

SchemaAPPS
SynonymGMF_LOT_COST_ADJUSTMENTS