[Home] [Help]
[Dependency Information]
Object Name: | GMF_LC_LOT_COST_ADJS |
---|---|
Object Type: | TABLE |
Owner: | GMF |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
This table used to store Actual Landed cost adjustments which are processed by Lot cost process
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMF_LC_LOT_COST_ADJS_N1 | NORMAL | NONUNIQUE |
![]() |
![]() |
GMF_LC_LOT_COST_ADJS_N2 | NORMAL | NONUNIQUE |
![]() |
![]() |
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 |
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;
GMF.GMF_LC_LOT_COST_ADJS does not reference any database object
GMF.GMF_LC_LOT_COST_ADJS is referenced by following:
|
|
|