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

TABLE: GMF.GMF_LC_ADJ_TRANSACTIONS

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


This table used to store Estimated and Actual Landed Cost adjustments. This table will be populated in Landed cost adjustment import process for each LC adjustment


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMF_LC_ADJ_TRANSACTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCOUNTED_FLAG
GMF_LC_ADJ_TRANSACTIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_DATE
GMF_LC_ADJ_TRANSACTIONS_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIP_HEADER_ID
ColumnSHIP_LINE_ID
ColumnADJUSTMENT_NUM
ColumnRCV_TRANSACTION_ID
ColumnCOMPONENT_TYPE
ColumnCOMPONENT_NAME
Columns
Name Datatype Length Mandatory Comments
ADJ_TRANSACTION_ID NUMBER
Yes Adjustment Transaction Identifier
RCV_TRANSACTION_ID NUMBER
Yes RCV Transaction Identifier
EVENT_TYPE NUMBER

Event Type
EVENT_SOURCE VARCHAR2 (25)
Receiving Event Source
EVENT_SOURCE_ID NUMBER

Event Source Identifier
LEDGER_ID NUMBER

Ledger Identifier
ORG_ID NUMBER

Operating Unit Identifier
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
ORGANIZATION_ID NUMBER

Inv Organization Identifier
LEGAL_ENTITY_ID NUMBER

Legal Entity Identifier
PARENT_SHIP_LINE_ID NUMBER

Parent Shipment Line Identifier
SHIP_HEADER_ID NUMBER

LCM Shipment Header Identifier
SHIP_LINE_GROUP_ID NUMBER

LCM Shipment Line Group Identifier
SHIP_LINE_ID NUMBER

LCM Shipment Line Identifier
ADJUSTMENT_NUM NUMBER

Adjustment Number, Indicates ELC or ALC, 0 - ELC and >0 ALC
PARENT_TABLE_NAME VARCHAR2 (30)
Parent Table Name
PARENT_TABLE_ID NUMBER

Parent Table Identifier
PRIOR_LANDED_COST NUMBER

Prior Landed Cost
NEW_LANDED_COST NUMBER

New Landed Cost
CHARGE_LINE_TYPE_ID NUMBER

Charge Line Type Identifier, same as Cost factor ID
CHARGE_LINE_TYPE_CODE VARCHAR2 (30)
Charge Line Type Code, same as Price element code
COST_ACQUISITION_FLAG VARCHAR2 (1)
Cost Acquisition Flag, I - Inventory E - Expense
COMPONENT_TYPE VARCHAR2 (30) Yes Component Type, Indicates CHARGE - Charge line TAX - Tax line ITEM PRICE - Item charge
COMPONENT_NAME VARCHAR2 (30)
Component Type name
COST_CMPNTCLS_ID NUMBER

Cost component class Identifier
LC_ADJUSTMENT_FLAG NUMBER (1)
Landed Cost adjustment Flag, 0 indicates ELC, 1 indicates ALC
TRANSACTION_DATE DATE

Transaction Date
TRANSACTION_QUANTITY NUMBER

Transaction Quantity
TRANSACTION_UOM_CODE VARCHAR2 (25)
Transaction UOM Code
PRIMARY_QUANTITY NUMBER

Primary Quantity
PRIMARY_UOM_CODE VARCHAR2 (25)
Primary UOM Code
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
LC_SHIP_NUM VARCHAR2 (25)
LCM Shipment number
LC_SHIP_LINE_NUM NUMBER

LCM Shipment Line Number
LC_VAR_ACCOUNT_ID NUMBER

LC Variance Account ID
LC_ABSORPTION_ACCOUNT_ID NUMBER

LC Absorption Account ID
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
COST_ANALYSIS_CODE#1 VARCHAR2 (32)
COST ANALYSIS CODE #1
Query Text

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


SELECT ADJ_TRANSACTION_ID
,      RCV_TRANSACTION_ID
,      EVENT_TYPE
,      EVENT_SOURCE
,      EVENT_SOURCE_ID
,      LEDGER_ID
,      ORG_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      LEGAL_ENTITY_ID
,      PARENT_SHIP_LINE_ID
,      SHIP_HEADER_ID
,      SHIP_LINE_GROUP_ID
,      SHIP_LINE_ID
,      ADJUSTMENT_NUM
,      PARENT_TABLE_NAME
,      PARENT_TABLE_ID
,      PRIOR_LANDED_COST
,      NEW_LANDED_COST
,      CHARGE_LINE_TYPE_ID
,      CHARGE_LINE_TYPE_CODE
,      COST_ACQUISITION_FLAG
,      COMPONENT_TYPE
,      COMPONENT_NAME
,      COST_CMPNTCLS_ID
,      LC_ADJUSTMENT_FLAG
,      TRANSACTION_DATE
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM_CODE
,      PRIMARY_QUANTITY
,      PRIMARY_UOM_CODE
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      LC_SHIP_NUM
,      LC_SHIP_LINE_NUM
,      LC_VAR_ACCOUNT_ID
,      LC_ABSORPTION_ACCOUNT_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
,      COST_ANALYSIS_CODE#1
FROM GMF.GMF_LC_ADJ_TRANSACTIONS;

Dependencies

[top of page]

GMF.GMF_LC_ADJ_TRANSACTIONS does not reference any database object

GMF.GMF_LC_ADJ_TRANSACTIONS is referenced by following:

SchemaGMF
ViewGMF_LC_ADJ_TRANSACTIONS#