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

VIEW: INV.MTL_MATERIAL_TRANSACTIONS#

Object Details
Object Name: MTL_MATERIAL_TRANSACTIONS#
Object Type: VIEW
Owner: INV
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

INVENTORY_ITEM_ID NUMBER
Yes
REVISION VARCHAR2 (3)
ORGANIZATION_ID NUMBER
Yes
SUBINVENTORY_CODE VARCHAR2 (10)
LOCATOR_ID NUMBER

TRANSACTION_TYPE_ID NUMBER
Yes
TRANSACTION_ACTION_ID NUMBER
Yes
TRANSACTION_SOURCE_TYPE_ID NUMBER
Yes
TRANSACTION_SOURCE_ID NUMBER

TRANSACTION_SOURCE_NAME VARCHAR2 (80)
TRANSACTION_QUANTITY NUMBER
Yes
TRANSACTION_UOM VARCHAR2 (3) Yes
PRIMARY_QUANTITY NUMBER
Yes
TRANSACTION_DATE DATE
Yes
VARIANCE_AMOUNT NUMBER

ACCT_PERIOD_ID NUMBER

TRANSACTION_REFERENCE VARCHAR2 (240)
REASON_ID NUMBER

DISTRIBUTION_ACCOUNT_ID NUMBER

ENCUMBRANCE_ACCOUNT NUMBER

ENCUMBRANCE_AMOUNT NUMBER

COST_UPDATE_ID NUMBER

COSTED_FLAG VARCHAR2 (1)
TRANSACTION_GROUP_ID NUMBER

INVOICED_FLAG VARCHAR2 (1)
ACTUAL_COST NUMBER

TRANSACTION_COST NUMBER

PRIOR_COST NUMBER

NEW_COST NUMBER

CURRENCY_CODE VARCHAR2 (10)
CURRENCY_CONVERSION_RATE NUMBER

CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

USSGL_TRANSACTION_CODE VARCHAR2 (30)
QUANTITY_ADJUSTED NUMBER

EMPLOYEE_CODE VARCHAR2 (10)
DEPARTMENT_ID NUMBER

OPERATION_SEQ_NUM NUMBER

MASTER_SCHEDULE_UPDATE_CODE VARCHAR2 (10)
RECEIVING_DOCUMENT VARCHAR2 (10)
PICKING_LINE_ID NUMBER

TRX_SOURCE_LINE_ID NUMBER

TRX_SOURCE_DELIVERY_ID NUMBER

REPETITIVE_LINE_ID NUMBER

PHYSICAL_ADJUSTMENT_ID NUMBER

CYCLE_COUNT_ID NUMBER

RMA_LINE_ID NUMBER

TRANSFER_TRANSACTION_ID NUMBER

TRANSACTION_SET_ID NUMBER

RCV_TRANSACTION_ID NUMBER

MOVE_TRANSACTION_ID NUMBER

COMPLETION_TRANSACTION_ID NUMBER

SHORTAGE_PROCESS_CODE NUMBER

SOURCE_CODE VARCHAR2 (30)
SOURCE_LINE_ID NUMBER

VENDOR_LOT_NUMBER VARCHAR2 (30)
TRANSFER_ORGANIZATION_ID NUMBER

TRANSFER_SUBINVENTORY VARCHAR2 (10)
TRANSFER_LOCATOR_ID NUMBER

SHIPMENT_NUMBER VARCHAR2 (30)
TRANSFER_COST NUMBER

TRANSPORTATION_DIST_ACCOUNT NUMBER

TRANSPORTATION_COST NUMBER

TRANSFER_COST_DIST_ACCOUNT NUMBER

WAYBILL_AIRBILL VARCHAR2 (30)
FREIGHT_CODE VARCHAR2 (30)
NUMBER_OF_CONTAINERS NUMBER

VALUE_CHANGE NUMBER

PERCENTAGE_CHANGE NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
MOVEMENT_ID NUMBER

TASK_ID NUMBER (15)
TO_TASK_ID NUMBER (15)
PROJECT_ID NUMBER (15)
TO_PROJECT_ID NUMBER (15)
SOURCE_PROJECT_ID NUMBER

PA_EXPENDITURE_ORG_ID NUMBER

SOURCE_TASK_ID NUMBER

EXPENDITURE_TYPE VARCHAR2 (30)
ERROR_CODE VARCHAR2 (240)
ERROR_EXPLANATION VARCHAR2 (240)
PRIOR_COSTED_QUANTITY NUMBER

TRANSFER_PRIOR_COSTED_QUANTITY NUMBER

FINAL_COMPLETION_FLAG VARCHAR2 (1)
PM_COST_COLLECTED VARCHAR2 (1)
PM_COST_COLLECTOR_GROUP_ID NUMBER

SHIPMENT_COSTED VARCHAR2 (1)
TRANSFER_PERCENTAGE NUMBER

MATERIAL_ACCOUNT NUMBER

MATERIAL_OVERHEAD_ACCOUNT NUMBER

RESOURCE_ACCOUNT NUMBER

OUTSIDE_PROCESSING_ACCOUNT NUMBER

OVERHEAD_ACCOUNT NUMBER

COST_GROUP_ID NUMBER

TRANSFER_COST_GROUP_ID NUMBER

FLOW_SCHEDULE VARCHAR2 (1)
QA_COLLECTION_ID NUMBER

OVERCOMPLETION_TRANSACTION_QTY NUMBER

OVERCOMPLETION_PRIMARY_QTY NUMBER

OVERCOMPLETION_TRANSACTION_ID NUMBER

MVT_STAT_STATUS VARCHAR2 (240)
COMMON_BOM_SEQ_ID NUMBER

COMMON_ROUTING_SEQ_ID NUMBER

ORG_COST_GROUP_ID NUMBER

COST_TYPE_ID NUMBER

PERIODIC_PRIMARY_QUANTITY NUMBER

MOVE_ORDER_LINE_ID NUMBER

TASK_GROUP_ID NUMBER

PICK_SLIP_NUMBER NUMBER

LPN_ID NUMBER

TRANSFER_LPN_ID NUMBER

PICK_STRATEGY_ID NUMBER

PICK_RULE_ID NUMBER

PUT_AWAY_STRATEGY_ID NUMBER

PUT_AWAY_RULE_ID NUMBER

CONTENT_LPN_ID NUMBER

PICK_SLIP_DATE DATE

COST_CATEGORY_ID NUMBER

ORGANIZATION_TYPE NUMBER

TRANSFER_ORGANIZATION_TYPE NUMBER

OWNING_ORGANIZATION_ID NUMBER

OWNING_TP_TYPE NUMBER

XFR_OWNING_ORGANIZATION_ID NUMBER

TRANSFER_OWNING_TP_TYPE NUMBER

PLANNING_ORGANIZATION_ID NUMBER

PLANNING_TP_TYPE NUMBER

XFR_PLANNING_ORGANIZATION_ID NUMBER

TRANSFER_PLANNING_TP_TYPE NUMBER

SECONDARY_UOM_CODE VARCHAR2 (3)
SECONDARY_TRANSACTION_QUANTITY NUMBER

TRANSACTION_GROUP_SEQ NUMBER

SHIP_TO_LOCATION_ID NUMBER

RESERVATION_ID NUMBER

TRANSACTION_MODE NUMBER

TRANSACTION_BATCH_ID NUMBER

TRANSACTION_BATCH_SEQ NUMBER

INTRANSIT_ACCOUNT NUMBER

FOB_POINT NUMBER

PARENT_TRANSACTION_ID NUMBER

LOGICAL_TRX_TYPE_CODE NUMBER

TRX_FLOW_HEADER_ID NUMBER

LOGICAL_TRANSACTIONS_CREATED NUMBER

LOGICAL_TRANSACTION NUMBER

INTERCOMPANY_COST NUMBER

INTERCOMPANY_PRICING_OPTION NUMBER

INTERCOMPANY_CURRENCY_CODE VARCHAR2 (15)
ORIGINAL_TRANSACTION_TEMP_ID NUMBER

TRANSFER_PRICE NUMBER

EXPENSE_ACCOUNT_ID NUMBER

COGS_RECOGNITION_PERCENT NUMBER

SO_ISSUE_ACCOUNT_TYPE NUMBER

OPM_COSTED_FLAG VARCHAR2 (1)
MATERIAL_EXPENSE_ACCOUNT NUMBER

TRANSACTION_EXTRACTED VARCHAR2 (1)
XML_DOCUMENT_ID NUMBER

Query Text

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


SELECT TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      INVENTORY_ITEM_ID
,      REVISION
,      ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      TRANSACTION_TYPE_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_NAME
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      PRIMARY_QUANTITY
,      TRANSACTION_DATE
,      VARIANCE_AMOUNT
,      ACCT_PERIOD_ID
,      TRANSACTION_REFERENCE
,      REASON_ID
,      DISTRIBUTION_ACCOUNT_ID
,      ENCUMBRANCE_ACCOUNT
,      ENCUMBRANCE_AMOUNT
,      COST_UPDATE_ID
,      COSTED_FLAG
,      TRANSACTION_GROUP_ID
,      INVOICED_FLAG
,      ACTUAL_COST
,      TRANSACTION_COST
,      PRIOR_COST
,      NEW_COST
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      USSGL_TRANSACTION_CODE
,      QUANTITY_ADJUSTED
,      EMPLOYEE_CODE
,      DEPARTMENT_ID
,      OPERATION_SEQ_NUM
,      MASTER_SCHEDULE_UPDATE_CODE
,      RECEIVING_DOCUMENT
,      PICKING_LINE_ID
,      TRX_SOURCE_LINE_ID
,      TRX_SOURCE_DELIVERY_ID
,      REPETITIVE_LINE_ID
,      PHYSICAL_ADJUSTMENT_ID
,      CYCLE_COUNT_ID
,      RMA_LINE_ID
,      TRANSFER_TRANSACTION_ID
,      TRANSACTION_SET_ID
,      RCV_TRANSACTION_ID
,      MOVE_TRANSACTION_ID
,      COMPLETION_TRANSACTION_ID
,      SHORTAGE_PROCESS_CODE
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      VENDOR_LOT_NUMBER
,      TRANSFER_ORGANIZATION_ID
,      TRANSFER_SUBINVENTORY
,      TRANSFER_LOCATOR_ID
,      SHIPMENT_NUMBER
,      TRANSFER_COST
,      TRANSPORTATION_DIST_ACCOUNT
,      TRANSPORTATION_COST
,      TRANSFER_COST_DIST_ACCOUNT
,      WAYBILL_AIRBILL
,      FREIGHT_CODE
,      NUMBER_OF_CONTAINERS
,      VALUE_CHANGE
,      PERCENTAGE_CHANGE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      MOVEMENT_ID
,      TASK_ID
,      TO_TASK_ID
,      PROJECT_ID
,      TO_PROJECT_ID
,      SOURCE_PROJECT_ID
,      PA_EXPENDITURE_ORG_ID
,      SOURCE_TASK_ID
,      EXPENDITURE_TYPE
,      ERROR_CODE
,      ERROR_EXPLANATION
,      PRIOR_COSTED_QUANTITY
,      TRANSFER_PRIOR_COSTED_QUANTITY
,      FINAL_COMPLETION_FLAG
,      PM_COST_COLLECTED
,      PM_COST_COLLECTOR_GROUP_ID
,      SHIPMENT_COSTED
,      TRANSFER_PERCENTAGE
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      RESOURCE_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      OVERHEAD_ACCOUNT
,      COST_GROUP_ID
,      TRANSFER_COST_GROUP_ID
,      FLOW_SCHEDULE
,      QA_COLLECTION_ID
,      OVERCOMPLETION_TRANSACTION_QTY
,      OVERCOMPLETION_PRIMARY_QTY
,      OVERCOMPLETION_TRANSACTION_ID
,      MVT_STAT_STATUS
,      COMMON_BOM_SEQ_ID
,      COMMON_ROUTING_SEQ_ID
,      ORG_COST_GROUP_ID
,      COST_TYPE_ID
,      PERIODIC_PRIMARY_QUANTITY
,      MOVE_ORDER_LINE_ID
,      TASK_GROUP_ID
,      PICK_SLIP_NUMBER
,      LPN_ID
,      TRANSFER_LPN_ID
,      PICK_STRATEGY_ID
,      PICK_RULE_ID
,      PUT_AWAY_STRATEGY_ID
,      PUT_AWAY_RULE_ID
,      CONTENT_LPN_ID
,      PICK_SLIP_DATE
,      COST_CATEGORY_ID
,      ORGANIZATION_TYPE
,      TRANSFER_ORGANIZATION_TYPE
,      OWNING_ORGANIZATION_ID
,      OWNING_TP_TYPE
,      XFR_OWNING_ORGANIZATION_ID
,      TRANSFER_OWNING_TP_TYPE
,      PLANNING_ORGANIZATION_ID
,      PLANNING_TP_TYPE
,      XFR_PLANNING_ORGANIZATION_ID
,      TRANSFER_PLANNING_TP_TYPE
,      SECONDARY_UOM_CODE
,      SECONDARY_TRANSACTION_QUANTITY
,      TRANSACTION_GROUP_SEQ
,      SHIP_TO_LOCATION_ID
,      RESERVATION_ID
,      TRANSACTION_MODE
,      TRANSACTION_BATCH_ID
,      TRANSACTION_BATCH_SEQ
,      INTRANSIT_ACCOUNT
,      FOB_POINT
,      PARENT_TRANSACTION_ID
,      LOGICAL_TRX_TYPE_CODE
,      TRX_FLOW_HEADER_ID
,      LOGICAL_TRANSACTIONS_CREATED
,      LOGICAL_TRANSACTION
,      INTERCOMPANY_COST
,      INTERCOMPANY_PRICING_OPTION
,      INTERCOMPANY_CURRENCY_CODE
,      ORIGINAL_TRANSACTION_TEMP_ID
,      TRANSFER_PRICE
,      EXPENSE_ACCOUNT_ID
,      COGS_RECOGNITION_PERCENT
,      SO_ISSUE_ACCOUNT_TYPE
,      OPM_COSTED_FLAG
,      MATERIAL_EXPENSE_ACCOUNT
,      TRANSACTION_EXTRACTED
,      XML_DOCUMENT_ID
FROM INV.MTL_MATERIAL_TRANSACTIONS#;

Dependencies

[top of page]

INV.MTL_MATERIAL_TRANSACTIONS# references the following:

SchemaINV
TableMTL_MATERIAL_TRANSACTIONS
INV.MTL_MATERIAL_TRANSACTIONS# is referenced by following:

SchemaAPPS
TriggerJAI_INV_MMT_ARIUD_T1
TriggerJA_AU_LOCAL_ACCOUNTING
SynonymMTL_MATERIAL_TRANSACTIONS