[Home] [Help] [Dependency Information]
Object Name: | GMF_LC_ADJ_TRANSACTIONS# |
---|---|
Object Type: | VIEW |
Owner: | GMF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADJ_TRANSACTION_ID | NUMBER | Yes | ||
RCV_TRANSACTION_ID | NUMBER | Yes | ||
EVENT_TYPE | NUMBER | |||
EVENT_SOURCE | VARCHAR2 | (25) | ||
EVENT_SOURCE_ID | NUMBER | |||
LEDGER_ID | NUMBER | |||
ORG_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
LEGAL_ENTITY_ID | NUMBER | |||
PARENT_SHIP_LINE_ID | NUMBER | |||
SHIP_HEADER_ID | NUMBER | |||
SHIP_LINE_GROUP_ID | NUMBER | |||
SHIP_LINE_ID | NUMBER | |||
ADJUSTMENT_NUM | NUMBER | |||
PARENT_TABLE_NAME | VARCHAR2 | (30) | ||
PARENT_TABLE_ID | NUMBER | |||
PRIOR_LANDED_COST | NUMBER | |||
NEW_LANDED_COST | NUMBER | |||
CHARGE_LINE_TYPE_ID | NUMBER | |||
CHARGE_LINE_TYPE_CODE | VARCHAR2 | (30) | ||
COST_ACQUISITION_FLAG | VARCHAR2 | (1) | ||
COMPONENT_TYPE | VARCHAR2 | (30) | Yes | |
COMPONENT_NAME | VARCHAR2 | (30) | ||
COST_CMPNTCLS_ID | NUMBER | |||
COST_ANALYSIS_CODE | VARCHAR2 | (32) | ||
LC_ADJUSTMENT_FLAG | NUMBER | (1) | ||
TRANSACTION_DATE | DATE | |||
TRANSACTION_QUANTITY | NUMBER | |||
TRANSACTION_UOM_CODE | VARCHAR2 | (25) | ||
PRIMARY_QUANTITY | NUMBER | |||
PRIMARY_UOM_CODE | VARCHAR2 | (25) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_RATE | NUMBER | |||
CURRENCY_CONVERSION_DATE | DATE | |||
LC_SHIP_NUM | VARCHAR2 | (25) | ||
LC_SHIP_LINE_NUM | NUMBER | |||
LC_VAR_ACCOUNT_ID | NUMBER | |||
LC_ABSORPTION_ACCOUNT_ID | NUMBER | |||
ACCOUNTED_FLAG | VARCHAR2 | (1) | ||
FINAL_POSTING_DATE | DATE | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UDPATE_DATE | DATE |
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
, COST_ANALYSIS_CODE
, 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
FROM GMF.GMF_LC_ADJ_TRANSACTIONS#;
|
|
|