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

VIEW: INV.MTL_MATERIAL_TRANSACTIONS_TEM#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_HEADER_ID NUMBER

TRANSACTION_TEMP_ID NUMBER

SOURCE_CODE VARCHAR2 (30)
SOURCE_LINE_ID NUMBER

TRANSACTION_MODE NUMBER

LOCK_FLAG VARCHAR2 (1)
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_QUANTITY NUMBER
Yes
PRIMARY_QUANTITY NUMBER
Yes
TRANSACTION_UOM VARCHAR2 (3) Yes
TRANSACTION_COST 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_DATE DATE
Yes
ACCT_PERIOD_ID NUMBER
Yes
DISTRIBUTION_ACCOUNT_ID NUMBER

TRANSACTION_REFERENCE VARCHAR2 (240)
REQUISITION_LINE_ID NUMBER

REQUISITION_DISTRIBUTION_ID NUMBER

REASON_ID NUMBER

LOT_NUMBER VARCHAR2 (80)
LOT_EXPIRATION_DATE DATE

SERIAL_NUMBER VARCHAR2 (30)
RECEIVING_DOCUMENT VARCHAR2 (10)
DEMAND_ID NUMBER

RCV_TRANSACTION_ID NUMBER

MOVE_TRANSACTION_ID NUMBER

COMPLETION_TRANSACTION_ID NUMBER

WIP_ENTITY_TYPE NUMBER

SCHEDULE_ID NUMBER

REPETITIVE_LINE_ID NUMBER

EMPLOYEE_CODE VARCHAR2 (10)
PRIMARY_SWITCH NUMBER

SCHEDULE_UPDATE_CODE NUMBER

SETUP_TEARDOWN_CODE NUMBER

ITEM_ORDERING NUMBER

NEGATIVE_REQ_FLAG NUMBER

OPERATION_SEQ_NUM NUMBER

PICKING_LINE_ID NUMBER

TRX_SOURCE_LINE_ID NUMBER

TRX_SOURCE_DELIVERY_ID NUMBER

PHYSICAL_ADJUSTMENT_ID NUMBER

CYCLE_COUNT_ID NUMBER

RMA_LINE_ID NUMBER

CUSTOMER_SHIP_ID NUMBER

CURRENCY_CODE VARCHAR2 (10)
CURRENCY_CONVERSION_RATE NUMBER

CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

USSGL_TRANSACTION_CODE VARCHAR2 (30)
VENDOR_LOT_NUMBER VARCHAR2 (30)
ENCUMBRANCE_ACCOUNT NUMBER

ENCUMBRANCE_AMOUNT NUMBER

SHIP_TO_LOCATION NUMBER

SHIPMENT_NUMBER VARCHAR2 (30)
TRANSFER_COST NUMBER

TRANSPORTATION_COST NUMBER

TRANSPORTATION_ACCOUNT NUMBER

FREIGHT_CODE VARCHAR2 (30)
CONTAINERS NUMBER

WAYBILL_AIRBILL VARCHAR2 (30)
EXPECTED_ARRIVAL_DATE DATE

TRANSFER_SUBINVENTORY VARCHAR2 (10)
TRANSFER_ORGANIZATION NUMBER

TRANSFER_TO_LOCATION NUMBER

NEW_AVERAGE_COST NUMBER

VALUE_CHANGE NUMBER

PERCENTAGE_CHANGE NUMBER

MATERIAL_ALLOCATION_TEMP_ID NUMBER

DEMAND_SOURCE_HEADER_ID NUMBER

DEMAND_SOURCE_LINE VARCHAR2 (30)
DEMAND_SOURCE_DELIVERY VARCHAR2 (30)
ITEM_SEGMENTS VARCHAR2 (240)
ITEM_DESCRIPTION VARCHAR2 (240)
ITEM_TRX_ENABLED_FLAG VARCHAR2 (1)
ITEM_LOCATION_CONTROL_CODE NUMBER

ITEM_RESTRICT_SUBINV_CODE NUMBER

ITEM_RESTRICT_LOCATORS_CODE NUMBER

ITEM_REVISION_QTY_CONTROL_CODE NUMBER

ITEM_PRIMARY_UOM_CODE VARCHAR2 (3)
ITEM_UOM_CLASS VARCHAR2 (10)
ITEM_SHELF_LIFE_CODE NUMBER

ITEM_SHELF_LIFE_DAYS NUMBER

ITEM_LOT_CONTROL_CODE NUMBER

ITEM_SERIAL_CONTROL_CODE NUMBER

ITEM_INVENTORY_ASSET_FLAG VARCHAR2 (1)
ALLOWED_UNITS_LOOKUP_CODE NUMBER

DEPARTMENT_ID NUMBER

DEPARTMENT_CODE VARCHAR2 (10)
WIP_SUPPLY_TYPE NUMBER

SUPPLY_SUBINVENTORY VARCHAR2 (10)
SUPPLY_LOCATOR_ID NUMBER

VALID_SUBINVENTORY_FLAG VARCHAR2 (1)
VALID_LOCATOR_FLAG VARCHAR2 (1)
LOCATOR_SEGMENTS VARCHAR2 (240)
CURRENT_LOCATOR_CONTROL_CODE NUMBER

NUMBER_OF_LOTS_ENTERED NUMBER

WIP_COMMIT_FLAG VARCHAR2 (1)
NEXT_LOT_NUMBER VARCHAR2 (30)
LOT_ALPHA_PREFIX VARCHAR2 (30)
NEXT_SERIAL_NUMBER VARCHAR2 (30)
SERIAL_ALPHA_PREFIX VARCHAR2 (30)
SHIPPABLE_FLAG VARCHAR2 (1)
POSTING_FLAG VARCHAR2 (1)
REQUIRED_FLAG VARCHAR2 (1)
PROCESS_FLAG VARCHAR2 (1)
ERROR_CODE VARCHAR2 (240)
ERROR_EXPLANATION VARCHAR2 (240)
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

RESERVATION_QUANTITY NUMBER

SHIPPED_QUANTITY NUMBER

TRANSACTION_LINE_NUMBER NUMBER

TASK_ID NUMBER (15)
TO_TASK_ID NUMBER (15)
SOURCE_TASK_ID NUMBER

PROJECT_ID NUMBER (15)
SOURCE_PROJECT_ID NUMBER

PA_EXPENDITURE_ORG_ID NUMBER

TO_PROJECT_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30)
FINAL_COMPLETION_FLAG VARCHAR2 (1)
TRANSFER_PERCENTAGE NUMBER

TRANSACTION_SEQUENCE_ID NUMBER

MATERIAL_ACCOUNT NUMBER

MATERIAL_OVERHEAD_ACCOUNT NUMBER

RESOURCE_ACCOUNT NUMBER

OUTSIDE_PROCESSING_ACCOUNT NUMBER

OVERHEAD_ACCOUNT NUMBER

FLOW_SCHEDULE VARCHAR2 (1)
COST_GROUP_ID NUMBER

DEMAND_CLASS VARCHAR2 (30)
QA_COLLECTION_ID NUMBER

KANBAN_CARD_ID NUMBER

OVERCOMPLETION_TRANSACTION_QTY NUMBER

OVERCOMPLETION_PRIMARY_QTY NUMBER

OVERCOMPLETION_TRANSACTION_ID NUMBER

END_ITEM_UNIT_NUMBER VARCHAR2 (60)
SCHEDULED_PAYBACK_DATE DATE

LINE_TYPE_CODE NUMBER

PARENT_TRANSACTION_TEMP_ID NUMBER

PUT_AWAY_STRATEGY_ID NUMBER

PUT_AWAY_RULE_ID NUMBER

PICK_STRATEGY_ID NUMBER

PICK_RULE_ID NUMBER

MOVE_ORDER_LINE_ID NUMBER

TASK_GROUP_ID NUMBER

PICK_SLIP_NUMBER NUMBER

RESERVATION_ID NUMBER

COMMON_BOM_SEQ_ID NUMBER

COMMON_ROUTING_SEQ_ID NUMBER

ORG_COST_GROUP_ID NUMBER

COST_TYPE_ID NUMBER

TRANSACTION_STATUS NUMBER

STANDARD_OPERATION_ID NUMBER

TASK_PRIORITY NUMBER

WMS_TASK_TYPE NUMBER

PARENT_LINE_ID NUMBER

SOURCE_LOT_NUMBER VARCHAR2 (80)
TRANSFER_COST_GROUP_ID NUMBER

LPN_ID NUMBER

TRANSFER_LPN_ID NUMBER

WMS_TASK_STATUS NUMBER

CONTENT_LPN_ID NUMBER

CONTAINER_ITEM_ID NUMBER

CARTONIZATION_ID NUMBER

PICK_SLIP_DATE DATE

REBUILD_ITEM_ID NUMBER

REBUILD_SERIAL_NUMBER VARCHAR2 (30)
REBUILD_ACTIVITY_ID NUMBER

REBUILD_JOB_NAME VARCHAR2 (240)
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 (240)
SECONDARY_TRANSACTION_QUANTITY NUMBER

ALLOCATED_LPN_ID NUMBER

SCHEDULE_NUMBER VARCHAR2 (60)
SCHEDULED_FLAG NUMBER

CLASS_CODE VARCHAR2 (10)
SCHEDULE_GROUP NUMBER

BUILD_SEQUENCE NUMBER

BOM_REVISION VARCHAR2 (3)
ROUTING_REVISION VARCHAR2 (3)
BOM_REVISION_DATE DATE

ROUTING_REVISION_DATE DATE

ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
TRANSACTION_BATCH_ID NUMBER

TRANSACTION_BATCH_SEQ NUMBER

OPERATION_PLAN_ID NUMBER

INTRANSIT_ACCOUNT NUMBER

FOB_POINT NUMBER

MOVE_ORDER_HEADER_ID NUMBER

SERIAL_ALLOCATED_FLAG VARCHAR2 (1)
TRX_FLOW_HEADER_ID NUMBER

LOGICAL_TRX_TYPE_CODE NUMBER

ORIGINAL_TRANSACTION_TEMP_ID NUMBER

TRANSFER_SECONDARY_QUANTITY NUMBER

TRANSFER_SECONDARY_UOM VARCHAR2 (3)
RELIEVE_RESERVATIONS_FLAG VARCHAR2 (1)
RELIEVE_HIGH_LEVEL_RSV_FLAG VARCHAR2 (1)
TRANSFER_PRICE NUMBER

MATERIAL_EXPENSE_ACCOUNT NUMBER

FULFILLMENT_BASE VARCHAR2 (1)
Query Text

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


SELECT TRANSACTION_HEADER_ID
,      TRANSACTION_TEMP_ID
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      TRANSACTION_MODE
,      LOCK_FLAG
,      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_QUANTITY
,      PRIMARY_QUANTITY
,      TRANSACTION_UOM
,      TRANSACTION_COST
,      TRANSACTION_TYPE_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_NAME
,      TRANSACTION_DATE
,      ACCT_PERIOD_ID
,      DISTRIBUTION_ACCOUNT_ID
,      TRANSACTION_REFERENCE
,      REQUISITION_LINE_ID
,      REQUISITION_DISTRIBUTION_ID
,      REASON_ID
,      LOT_NUMBER
,      LOT_EXPIRATION_DATE
,      SERIAL_NUMBER
,      RECEIVING_DOCUMENT
,      DEMAND_ID
,      RCV_TRANSACTION_ID
,      MOVE_TRANSACTION_ID
,      COMPLETION_TRANSACTION_ID
,      WIP_ENTITY_TYPE
,      SCHEDULE_ID
,      REPETITIVE_LINE_ID
,      EMPLOYEE_CODE
,      PRIMARY_SWITCH
,      SCHEDULE_UPDATE_CODE
,      SETUP_TEARDOWN_CODE
,      ITEM_ORDERING
,      NEGATIVE_REQ_FLAG
,      OPERATION_SEQ_NUM
,      PICKING_LINE_ID
,      TRX_SOURCE_LINE_ID
,      TRX_SOURCE_DELIVERY_ID
,      PHYSICAL_ADJUSTMENT_ID
,      CYCLE_COUNT_ID
,      RMA_LINE_ID
,      CUSTOMER_SHIP_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      USSGL_TRANSACTION_CODE
,      VENDOR_LOT_NUMBER
,      ENCUMBRANCE_ACCOUNT
,      ENCUMBRANCE_AMOUNT
,      SHIP_TO_LOCATION
,      SHIPMENT_NUMBER
,      TRANSFER_COST
,      TRANSPORTATION_COST
,      TRANSPORTATION_ACCOUNT
,      FREIGHT_CODE
,      CONTAINERS
,      WAYBILL_AIRBILL
,      EXPECTED_ARRIVAL_DATE
,      TRANSFER_SUBINVENTORY
,      TRANSFER_ORGANIZATION
,      TRANSFER_TO_LOCATION
,      NEW_AVERAGE_COST
,      VALUE_CHANGE
,      PERCENTAGE_CHANGE
,      MATERIAL_ALLOCATION_TEMP_ID
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE
,      DEMAND_SOURCE_DELIVERY
,      ITEM_SEGMENTS
,      ITEM_DESCRIPTION
,      ITEM_TRX_ENABLED_FLAG
,      ITEM_LOCATION_CONTROL_CODE
,      ITEM_RESTRICT_SUBINV_CODE
,      ITEM_RESTRICT_LOCATORS_CODE
,      ITEM_REVISION_QTY_CONTROL_CODE
,      ITEM_PRIMARY_UOM_CODE
,      ITEM_UOM_CLASS
,      ITEM_SHELF_LIFE_CODE
,      ITEM_SHELF_LIFE_DAYS
,      ITEM_LOT_CONTROL_CODE
,      ITEM_SERIAL_CONTROL_CODE
,      ITEM_INVENTORY_ASSET_FLAG
,      ALLOWED_UNITS_LOOKUP_CODE
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      WIP_SUPPLY_TYPE
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      VALID_SUBINVENTORY_FLAG
,      VALID_LOCATOR_FLAG
,      LOCATOR_SEGMENTS
,      CURRENT_LOCATOR_CONTROL_CODE
,      NUMBER_OF_LOTS_ENTERED
,      WIP_COMMIT_FLAG
,      NEXT_LOT_NUMBER
,      LOT_ALPHA_PREFIX
,      NEXT_SERIAL_NUMBER
,      SERIAL_ALPHA_PREFIX
,      SHIPPABLE_FLAG
,      POSTING_FLAG
,      REQUIRED_FLAG
,      PROCESS_FLAG
,      ERROR_CODE
,      ERROR_EXPLANATION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      MOVEMENT_ID
,      RESERVATION_QUANTITY
,      SHIPPED_QUANTITY
,      TRANSACTION_LINE_NUMBER
,      TASK_ID
,      TO_TASK_ID
,      SOURCE_TASK_ID
,      PROJECT_ID
,      SOURCE_PROJECT_ID
,      PA_EXPENDITURE_ORG_ID
,      TO_PROJECT_ID
,      EXPENDITURE_TYPE
,      FINAL_COMPLETION_FLAG
,      TRANSFER_PERCENTAGE
,      TRANSACTION_SEQUENCE_ID
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      RESOURCE_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      OVERHEAD_ACCOUNT
,      FLOW_SCHEDULE
,      COST_GROUP_ID
,      DEMAND_CLASS
,      QA_COLLECTION_ID
,      KANBAN_CARD_ID
,      OVERCOMPLETION_TRANSACTION_QTY
,      OVERCOMPLETION_PRIMARY_QTY
,      OVERCOMPLETION_TRANSACTION_ID
,      END_ITEM_UNIT_NUMBER
,      SCHEDULED_PAYBACK_DATE
,      LINE_TYPE_CODE
,      PARENT_TRANSACTION_TEMP_ID
,      PUT_AWAY_STRATEGY_ID
,      PUT_AWAY_RULE_ID
,      PICK_STRATEGY_ID
,      PICK_RULE_ID
,      MOVE_ORDER_LINE_ID
,      TASK_GROUP_ID
,      PICK_SLIP_NUMBER
,      RESERVATION_ID
,      COMMON_BOM_SEQ_ID
,      COMMON_ROUTING_SEQ_ID
,      ORG_COST_GROUP_ID
,      COST_TYPE_ID
,      TRANSACTION_STATUS
,      STANDARD_OPERATION_ID
,      TASK_PRIORITY
,      WMS_TASK_TYPE
,      PARENT_LINE_ID
,      SOURCE_LOT_NUMBER
,      TRANSFER_COST_GROUP_ID
,      LPN_ID
,      TRANSFER_LPN_ID
,      WMS_TASK_STATUS
,      CONTENT_LPN_ID
,      CONTAINER_ITEM_ID
,      CARTONIZATION_ID
,      PICK_SLIP_DATE
,      REBUILD_ITEM_ID
,      REBUILD_SERIAL_NUMBER
,      REBUILD_ACTIVITY_ID
,      REBUILD_JOB_NAME
,      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
,      ALLOCATED_LPN_ID
,      SCHEDULE_NUMBER
,      SCHEDULED_FLAG
,      CLASS_CODE
,      SCHEDULE_GROUP
,      BUILD_SEQUENCE
,      BOM_REVISION
,      ROUTING_REVISION
,      BOM_REVISION_DATE
,      ROUTING_REVISION_DATE
,      ALTERNATE_BOM_DESIGNATOR
,      ALTERNATE_ROUTING_DESIGNATOR
,      TRANSACTION_BATCH_ID
,      TRANSACTION_BATCH_SEQ
,      OPERATION_PLAN_ID
,      INTRANSIT_ACCOUNT
,      FOB_POINT
,      MOVE_ORDER_HEADER_ID
,      SERIAL_ALLOCATED_FLAG
,      TRX_FLOW_HEADER_ID
,      LOGICAL_TRX_TYPE_CODE
,      ORIGINAL_TRANSACTION_TEMP_ID
,      TRANSFER_SECONDARY_QUANTITY
,      TRANSFER_SECONDARY_UOM
,      RELIEVE_RESERVATIONS_FLAG
,      RELIEVE_HIGH_LEVEL_RSV_FLAG
,      TRANSFER_PRICE
,      MATERIAL_EXPENSE_ACCOUNT
,      FULFILLMENT_BASE
FROM INV.MTL_MATERIAL_TRANSACTIONS_TEM#;

Dependencies

[top of page]

INV.MTL_MATERIAL_TRANSACTIONS_TEM# references the following:

SchemaINV
TableMTL_MATERIAL_TRANSACTIONS_TEMP
INV.MTL_MATERIAL_TRANSACTIONS_TEM# is referenced by following:

SchemaAPPS
SynonymMTL_MATERIAL_TRANSACTIONS_TEMP
TriggerMTL_MMTT_T