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


TABLE: GMF.GMF_LC_LOT_COST_ADJS

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


This table used to store Actual Landed cost adjustments which are processed by Lot cost process


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMF_LC_LOT_COST_ADJS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADJ_TRANSACTION_ID
GMF_LC_LOT_COST_ADJS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCOUNTED_FLAG
Columns
Name Datatype Length Mandatory Comments
LC_ADJUSTMENT_ID NUMBER
Yes Lot Cost LC Adjustment Identifier
ADJ_TRANSACTION_ID NUMBER
Yes Adjustment Transaction Identifier
ADJUSTMENT_QUANTITY NUMBER

Adjustment Quantity
COSTED_QUANTITY NUMBER

Costed Quantity used in cost calculations
TOTAL_QUANTITY NUMBER

Total Quantity
QUANTITY_UOM_CODE VARCHAR2 (25)
Quantity UOM Code
UNIT_BASE_PRICE NUMBER

Unit Price in base currency
BASE_AMOUNT NUMBER

Actual LC Amount in base currency
TRANS_AMOUNT NUMBER

Actual LC Amount in Transactional currency
BASE_ADJ_AMOUNT NUMBER

Prorated Actual LC Adjustment in base currency
TRANS_ADJ_AMOUNT NUMBER

Prorated Actual LC Adjustment in transactional currency
COST_TYPE_ID NUMBER

Cost Type Identifier
LOT_NUMBER VARCHAR2 (80) Yes Lot Number
LOT_COSTED_FLAG NUMBER

Lot Costed Flag. 0 - Uncosted, 1 - Costed in Final Mode
ONHAND_QUANTITY NUMBER

On hand Quantity
OLD_COST_HEADER_ID NUMBER

Old cost Header Identifier Surrogate to Lot Costs - gmf_lot_costs.header_id - for a quick access join
NEW_COST_HEADER_ID NUMBER

New cost Header Identifier Surrogate to Lot Costs - gmf_lot_costs.header_id - for a quick access join
ACCOUNTED_FLAG VARCHAR2 (1)
Flag indicates Accounting pre processor status. N = not accounted, D = draft accounted, Null = Final Accounted
FINAL_POSTING_DATE DATE

Date on which create accounting ran in Final mode
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
REQUEST_ID NUMBER

Standard Concurrent Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Concurrent Who Column
PROGRAM_ID NUMBER

Standard Concurrent Who Column
PROGRAM_UDPATE_DATE DATE

Standard Concurrent Who Column
Query Text

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


SELECT LC_ADJUSTMENT_ID
,      ADJ_TRANSACTION_ID
,      ADJUSTMENT_QUANTITY
,      COSTED_QUANTITY
,      TOTAL_QUANTITY
,      QUANTITY_UOM_CODE
,      UNIT_BASE_PRICE
,      BASE_AMOUNT
,      TRANS_AMOUNT
,      BASE_ADJ_AMOUNT
,      TRANS_ADJ_AMOUNT
,      COST_TYPE_ID
,      LOT_NUMBER
,      LOT_COSTED_FLAG
,      ONHAND_QUANTITY
,      OLD_COST_HEADER_ID
,      NEW_COST_HEADER_ID
,      ACCOUNTED_FLAG
,      FINAL_POSTING_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UDPATE_DATE
FROM GMF.GMF_LC_LOT_COST_ADJS;

Dependencies

[top of page]

GMF.GMF_LC_LOT_COST_ADJS does not reference any database object

GMF.GMF_LC_LOT_COST_ADJS is referenced by following:

SchemaGMF
ViewGMF_LC_LOT_COST_ADJS#