[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_MATERIAL_TRANSACTIONS_TEMP |
|---|---|
| Object Type: | TABLE |
| Owner: | INV |
| FND Design Data: |  INV.MTL_MATERIAL_TRANSACTIONS_TEMP
|
| Subobject Name: | |
| Status: | VALID |
MTL_MATERIAL_TRANSACTIONS_TEMP is the gateway for all material
transactions.
.
.
.
Records are processed from this table into Inventory through the
transaction processor. All Inventory transaction forms write directly
to this table. Outside applications must write transaction records to
MTL_TRANSACTIONS_INTERFACE to be processed through
MTL_MATERIAL_TRANSACTIONS_TEMP and the transaction processor by the
Transaction Worker concurrent program.
.
.
.
Lots and serial numbers for a MTL_MATERIAL_TRANSACTIONS_TEMP(MMTT)
record are stored in the tables MTL_TRANSACTION_LOTS_TEMP(MTLT) and
MTL_SERIAL_NUMBERS_TEMP(MSNT). If the item is under lot control, then
MMTT.TRANSACTION_TEMP_ID joins to MTLT.TRANSACTION_TEMP_ID. If the
item is also under serial number control, then
MTLT.SERIAL_TRANSACTION_TEMP_ID joins to MSNT.TRANSACTION_TEMP_ID. If
the item is only under serial number control, then
MMTT.TRANSACTION_TEMP_ID joins to MSNT.TRANSACTION_TEMP_ID.
.
.
.
Transfer transactions are stored in this table as a single record.
The transaction processor creates two transactions from the single
record.
.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MTL_MATERIAL_TRANS_TEMP_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 TRANSACTION_TEMP_ID
|
| MTL_MATERIAL_TRANS_TEMP_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TRANSACTION_HEADER_ID
|
| MTL_MATERIAL_TRANS_TEMP_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
SUBINVENTORY_CODE
LOCATOR_ID
|
| MTL_MATERIAL_TRANS_TEMP_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TRANSFER_SUBINVENTORY
TRANSFER_TO_LOCATION
ORGANIZATION_ID
|
| MTL_MATERIAL_TRANS_TEMP_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PICK_SLIP_NUMBER
|
| MTL_MATERIAL_TRANS_TEMP_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
MOVE_ORDER_LINE_ID
|
| MTL_MATERIAL_TRANS_TEMP_N15 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RESERVATION_ID
|
| MTL_MATERIAL_TRANS_TEMP_N16 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
WMS_TASK_TYPE
STANDARD_OPERATION_ID
|
| MTL_MATERIAL_TRANS_TEMP_N18 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ALLOCATED_LPN_ID
ORGANIZATION_ID
|
| MTL_MATERIAL_TRANS_TEMP_N19 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
INVENTORY_ITEM_ID
TRANSACTION_ACTION_ID
POSTING_FLAG
|
| MTL_MATERIAL_TRANS_TEMP_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INVENTORY_ITEM_ID
SUBINVENTORY_CODE
ORGANIZATION_ID
|
| MTL_MATERIAL_TRANS_TEMP_N20 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TRANSFER_LPN_ID
|
| MTL_MATERIAL_TRANS_TEMP_N21 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
MOVE_ORDER_HEADER_ID
|
| MTL_MATERIAL_TRANS_TEMP_N22 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CARTONIZATION_ID
|
| MTL_MATERIAL_TRANS_TEMP_N23 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LPN_ID
|
| MTL_MATERIAL_TRANS_TEMP_N24 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TRANSACTION_BATCH_ID
|
| MTL_MATERIAL_TRANS_TEMP_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PICKING_LINE_ID
|
| MTL_MATERIAL_TRANS_TEMP_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COMPLETION_TRANSACTION_ID
|
| MTL_MATERIAL_TRANS_TEMP_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARENT_LINE_ID
|
| MTL_MATERIAL_TRANS_TEMP_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARENT_TRANSACTION_TEMP_ID
|
| MTL_MATERIAL_TRANS_TEMP_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TRANSACTION_SOURCE_TYPE_ID
ORGANIZATION_ID
TRANSACTION_DATE
TRANSACTION_SOURCE_NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTION_HEADER_ID | NUMBER | Transaction group identifier | ||
| TRANSACTION_TEMP_ID | NUMBER | Transaction line identifier used to join to lot or serial table when under these controls | ||
| SOURCE_CODE | VARCHAR2 | (30) | Source identifier | |
| SOURCE_LINE_ID | NUMBER | Source line identifier | ||
| TRANSACTION_MODE | NUMBER | Process mode code | ||
| LOCK_FLAG | VARCHAR2 | (1) | Row lock flag used by Transaction Manager | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| REQUEST_ID | NUMBER | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
| PROGRAM_ID | NUMBER | Standard Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
| INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
| REVISION | VARCHAR2 | (3) | Inventory item revision code | |
| ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
| SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory name | |
| LOCATOR_ID | NUMBER | Locator identifier | ||
| TRANSACTION_QUANTITY | NUMBER | Yes | Quantity entered at transaction time | |
| PRIMARY_QUANTITY | NUMBER | Yes | Transaction quantity in terms of the primary uom of the item | |
| TRANSACTION_UOM | VARCHAR2 | (3) | Yes | UOM used at the time of transaction |
| TRANSACTION_COST | NUMBER | Transaction cost | ||
| TRANSACTION_TYPE_ID | NUMBER | Yes | Transaction type identifier | |
| TRANSACTION_ACTION_ID | NUMBER | Yes | Transaction action identifier | |
| TRANSACTION_SOURCE_TYPE_ID | NUMBER | Yes | Transaction source type identifier | |
| TRANSACTION_SOURCE_ID | NUMBER | Transaction source idenfier | ||
| TRANSACTION_SOURCE_NAME | VARCHAR2 | (80) | Transaction source identifier | |
| TRANSACTION_DATE | DATE | Yes | Transaction date | |
| ACCT_PERIOD_ID | NUMBER | Yes | Accounting period identifier | |
| DISTRIBUTION_ACCOUNT_ID | NUMBER | Account identifier the transaction charged to | ||
| TRANSACTION_REFERENCE | VARCHAR2 | (240) | Transaction reference | |
| REQUISITION_LINE_ID | NUMBER | Requisition line identifier | ||
| REQUISITION_DISTRIBUTION_ID | NUMBER | Requisition distribution identifier | ||
| REASON_ID | NUMBER | Transaction reason identifier | ||
| LOT_NUMBER | VARCHAR2 | (80) | Lot Number | |
| LOT_EXPIRATION_DATE | DATE | Lot expiration date | ||
| SERIAL_NUMBER | VARCHAR2 | (30) | Serial number | |
| RECEIVING_DOCUMENT | VARCHAR2 | (10) | Receiving document | |
| DEMAND_ID | NUMBER | Demand identifier | ||
| RCV_TRANSACTION_ID | NUMBER | Receiving transaction identifier | ||
| MOVE_TRANSACTION_ID | NUMBER | Move transaction identifier | ||
| COMPLETION_TRANSACTION_ID | NUMBER | Completion transaction identifier | ||
| WIP_ENTITY_TYPE | NUMBER | Wip entity type code | ||
| SCHEDULE_ID | NUMBER | WIP repetitive schedule identifier | ||
| REPETITIVE_LINE_ID | NUMBER | Repetitive line identifier | ||
| EMPLOYEE_CODE | VARCHAR2 | (10) | Employee code | |
| PRIMARY_SWITCH | NUMBER | Primary assembly identifier | ||
| SCHEDULE_UPDATE_CODE | NUMBER | Schedule update code | ||
| SETUP_TEARDOWN_CODE | NUMBER | Setup teardown code | ||
| ITEM_ORDERING | NUMBER | Item ordering | ||
| NEGATIVE_REQ_FLAG | NUMBER | Negative requirement flag | ||
| OPERATION_SEQ_NUM | NUMBER | Operation sequence number within a routing | ||
| PICKING_LINE_ID | NUMBER | Picking line id | ||
| TRX_SOURCE_LINE_ID | NUMBER | Line level transaction source identifier | ||
| TRX_SOURCE_DELIVERY_ID | NUMBER | Delivery level transaction source identifier | ||
| PHYSICAL_ADJUSTMENT_ID | NUMBER | Physical adjustment identifier | ||
| CYCLE_COUNT_ID | NUMBER | Cycle count identifier | ||
| RMA_LINE_ID | NUMBER | RMA line identifier | ||
| CUSTOMER_SHIP_ID | NUMBER | Customer shipping identifier | ||
| CURRENCY_CODE | VARCHAR2 | (10) | Currency code | |
| CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
| CURRENCY_CONVERSION_DATE | DATE | Currency conversion date | ||
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | USSGL transaction date | |
| VENDOR_LOT_NUMBER | VARCHAR2 | (30) | Supplier lot number | |
| ENCUMBRANCE_ACCOUNT | NUMBER | Encumbrance account identifier | ||
| ENCUMBRANCE_AMOUNT | NUMBER | Encumbrance amount | ||
| SHIP_TO_LOCATION | NUMBER | Ship to location identifier | ||
| SHIPMENT_NUMBER | VARCHAR2 | (30) | Intransit shipment identifier | |
| TRANSFER_COST | NUMBER | Transfer cost | ||
| TRANSPORTATION_COST | NUMBER | Transportation cost | ||
| TRANSPORTATION_ACCOUNT | NUMBER | Transportation account | ||
| FREIGHT_CODE | VARCHAR2 | (30) | Freight identifier | |
| CONTAINERS | NUMBER | Number of containers | ||
| WAYBILL_AIRBILL | VARCHAR2 | (30) | Waybill / Airbill | |
| EXPECTED_ARRIVAL_DATE | DATE | Expected arrival date | ||
| TRANSFER_SUBINVENTORY | VARCHAR2 | (10) | Opposing subinventory identifier in transfer transactions | |
| TRANSFER_ORGANIZATION | NUMBER | Opposing organization identifier in transfer transactions | ||
| TRANSFER_TO_LOCATION | NUMBER | Opposing locator identifier in transfer transactions | ||
| NEW_AVERAGE_COST | NUMBER | New average cost used for average cost update | ||
| VALUE_CHANGE | NUMBER | Value change used for average cost update | ||
| PERCENTAGE_CHANGE | NUMBER | Percent change used for average cost update | ||
| MATERIAL_ALLOCATION_TEMP_ID | NUMBER | Material allocation temporary identifier | ||
| DEMAND_SOURCE_HEADER_ID | NUMBER | Demand source header identifier | ||
| DEMAND_SOURCE_LINE | VARCHAR2 | (30) | Demand source line identifier | |
| DEMAND_SOURCE_DELIVERY | VARCHAR2 | (30) | Demand source line identifier | |
| ITEM_SEGMENTS | VARCHAR2 | (240) | Inventory item segments | |
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Inventory item description | |
| ITEM_TRX_ENABLED_FLAG | VARCHAR2 | (1) | Inventory item transaction enabled flag | |
| ITEM_LOCATION_CONTROL_CODE | NUMBER | Inventory item locator control code | ||
| ITEM_RESTRICT_SUBINV_CODE | NUMBER | Inventory item restrict subinventory code | ||
| ITEM_RESTRICT_LOCATORS_CODE | NUMBER | Inventory item restrict locators code | ||
| ITEM_REVISION_QTY_CONTROL_CODE | NUMBER | Inventory item revision control code | ||
| ITEM_PRIMARY_UOM_CODE | VARCHAR2 | (3) | Inventory item primary uom | |
| ITEM_UOM_CLASS | VARCHAR2 | (10) | Inventory item uom class | |
| ITEM_SHELF_LIFE_CODE | NUMBER | Inventory item shelf life code | ||
| ITEM_SHELF_LIFE_DAYS | NUMBER | Inventory item shelf life days | ||
| ITEM_LOT_CONTROL_CODE | NUMBER | Inventory item lot control code | ||
| ITEM_SERIAL_CONTROL_CODE | NUMBER | Inventory item serial control code | ||
| ITEM_INVENTORY_ASSET_FLAG | VARCHAR2 | (1) | Inventory item asset flag | |
| ALLOWED_UNITS_LOOKUP_CODE | NUMBER | Inventory item uom conversions type | ||
| DEPARTMENT_ID | NUMBER | Department identifier | ||
| DEPARTMENT_CODE | VARCHAR2 | (10) | Department code | |
| WIP_SUPPLY_TYPE | NUMBER | Wip supply type | ||
| SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | Supply subinventory | |
| SUPPLY_LOCATOR_ID | NUMBER | Supply locator identifier | ||
| VALID_SUBINVENTORY_FLAG | VARCHAR2 | (1) | Valid subinventory flag | |
| VALID_LOCATOR_FLAG | VARCHAR2 | (1) | Valid locator flag | |
| LOCATOR_SEGMENTS | VARCHAR2 | (240) | Locator segments | |
| CURRENT_LOCATOR_CONTROL_CODE | NUMBER | Inventory item locator control code | ||
| NUMBER_OF_LOTS_ENTERED | NUMBER | Total lot records entered | ||
| WIP_COMMIT_FLAG | VARCHAR2 | (1) | WIP commit flag | |
| NEXT_LOT_NUMBER | VARCHAR2 | (30) | Inventory item next lot number | |
| LOT_ALPHA_PREFIX | VARCHAR2 | (30) | Inventory item lot prefix | |
| NEXT_SERIAL_NUMBER | VARCHAR2 | (30) | Inventory item next valid serial number | |
| SERIAL_ALPHA_PREFIX | VARCHAR2 | (30) | Inventory item serial prefix | |
| SHIPPABLE_FLAG | VARCHAR2 | (1) | Inventory item shippable flag | |
| POSTING_FLAG | VARCHAR2 | (1) | Posting flag | |
| REQUIRED_FLAG | VARCHAR2 | (1) | Required flag | |
| PROCESS_FLAG | VARCHAR2 | (1) | Row process flag used by Transaction Manager | |
| ERROR_CODE | VARCHAR2 | (240) | Error code | |
| ERROR_EXPLANATION | VARCHAR2 | (240) | Error explanation | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| MOVEMENT_ID | NUMBER | Movement statistics cross reference | ||
| RESERVATION_QUANTITY | NUMBER | Reservation quantity | ||
| SHIPPED_QUANTITY | NUMBER | Shipped quantity | ||
| TRANSACTION_LINE_NUMBER | NUMBER | Transaction line number. | ||
| TASK_ID | NUMBER | (15) | Task identifier | |
| TO_TASK_ID | NUMBER | (15) | "To" task identifier | |
| SOURCE_TASK_ID | NUMBER | Source task identifier | ||
| PROJECT_ID | NUMBER | (15) | Project identifier | |
| SOURCE_PROJECT_ID | NUMBER | Source project identifier | ||
| PA_EXPENDITURE_ORG_ID | NUMBER | Oracle Projects related expenditure organization identifier | ||
| TO_PROJECT_ID | NUMBER | (15) | "To" project identifier | |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Oracle Projects related expenditure type | |
| FINAL_COMPLETION_FLAG | VARCHAR2 | (1) | Indicates if job costs must be flushed out for this job completion. | |
| TRANSFER_PERCENTAGE | NUMBER | Percentage of value to attribute to transfer costs in an inter-org transfer | ||
| TRANSACTION_SEQUENCE_ID | NUMBER | Transaction sequence identifier (currently not used) | ||
| MATERIAL_ACCOUNT | NUMBER | Specifies the material account | ||
| MATERIAL_OVERHEAD_ACCOUNT | NUMBER | specifies the material overhead account | ||
| RESOURCE_ACCOUNT | NUMBER | Specifies the resource account | ||
| OUTSIDE_PROCESSING_ACCOUNT | NUMBER | Specifies the account to be charged for outside processing | ||
| OVERHEAD_ACCOUNT | NUMBER | Specifies the overhead account | ||
| FLOW_SCHEDULE | VARCHAR2 | (1) | Specifies whether the WIP transaction is a flow or schedule type transaction | |
| COST_GROUP_ID | NUMBER | Cost group identifier | ||
| DEMAND_CLASS | VARCHAR2 | (30) | Demand Class | |
| QA_COLLECTION_ID | NUMBER | Quality Results Identifier | ||
| KANBAN_CARD_ID | NUMBER | Kanban card identifier | ||
| OVERCOMPLETION_TRANSACTION_QTY | NUMBER | Overcompletion transaction quantity | ||
| OVERCOMPLETION_PRIMARY_QTY | NUMBER | Overcompletion Primary quantity | ||
| OVERCOMPLETION_TRANSACTION_ID | NUMBER | Overcompletion Transaction Identifier | ||
| END_ITEM_UNIT_NUMBER | VARCHAR2 | (60) | End Item Unit Number | |
| SCHEDULED_PAYBACK_DATE | DATE | Standard Who column | ||
| LINE_TYPE_CODE | NUMBER | Line type code | ||
| PARENT_TRANSACTION_TEMP_ID | NUMBER | Parent transaction temp id | ||
| PUT_AWAY_STRATEGY_ID | NUMBER | Put away Strategy ID - used by WMS only | ||
| PUT_AWAY_RULE_ID | NUMBER | Put away Rule ID - used by WMS only | ||
| PICK_STRATEGY_ID | NUMBER | Pick Strategy ID - used by WMS only | ||
| PICK_RULE_ID | NUMBER | Pick Rule ID | ||
| MOVE_ORDER_LINE_ID | NUMBER | Move order line identifier that this transaction line is tied to | ||
| TASK_GROUP_ID | NUMBER | Task group identifier for this task | ||
| PICK_SLIP_NUMBER | NUMBER | Pick Slip number for the transaction line | ||
| RESERVATION_ID | NUMBER | Reservation identifier | ||
| COMMON_BOM_SEQ_ID | NUMBER | Bill identifier of common bom used | ||
| COMMON_ROUTING_SEQ_ID | NUMBER | Routing id of the common routing used | ||
| ORG_COST_GROUP_ID | NUMBER | Organization's cost group identifier | ||
| COST_TYPE_ID | NUMBER | Cost type | ||
| TRANSACTION_STATUS | NUMBER | Indicates if it has to be processed or just saved. NULL or 1 is default behavior. 2 is save only. 3 is ready to process | ||
| STANDARD_OPERATION_ID | NUMBER | Standard operation identifier - used by WMS only | ||
| TASK_PRIORITY | NUMBER | Task priority - used by WMS only | ||
| WMS_TASK_TYPE | NUMBER | WMS Task Type - used by WMS only | ||
| PARENT_LINE_ID | NUMBER | (For future use only) | ||
| SOURCE_LOT_NUMBER | VARCHAR2 | (80) | Source lot number | |
| TRANSFER_COST_GROUP_ID | NUMBER | Transfer Cost Group | ||
| LPN_ID | NUMBER | License Plate Number Identifier - used by WMS only | ||
| TRANSFER_LPN_ID | NUMBER | Transfer License Plate Number Identifier - used by WMS only | ||
| WMS_TASK_STATUS | NUMBER | Status of the WMS task | ||
| CONTENT_LPN_ID | NUMBER | Transfer License Plate Number Identifier - used by WMS only | ||
| CONTAINER_ITEM_ID | NUMBER | Item id for suggested container item for this line - used by WMS only | ||
| CARTONIZATION_ID | NUMBER | Sequential LPN Id generated by cartonization - used by WMS only | ||
| PICK_SLIP_DATE | DATE | Pick Slip Date | ||
| REBUILD_ITEM_ID | NUMBER | Rebuildable Inventory item identifier | ||
| REBUILD_SERIAL_NUMBER | VARCHAR2 | (30) | Serial Number of the rebuildable item | |
| REBUILD_ACTIVITY_ID | NUMBER | Activity performed on the Rebuildable item | ||
| REBUILD_JOB_NAME | VARCHAR2 | (240) | Job Name performed on the Rebuildable item | |
| ORGANIZATION_TYPE | NUMBER | Organization Type. The values are based on MTL_TP_TYPES lookup. | ||
| TRANSFER_ORGANIZATION_TYPE | NUMBER | Transfer Organization Type. The values are based on MTL_TP_TYPES lookup. | ||
| OWNING_ORGANIZATION_ID | NUMBER | Owning organization identifier | ||
| OWNING_TP_TYPE | NUMBER | Owning Trading Partner Type. The values are based on MTL_TP_TYPES lookup. | ||
| XFR_OWNING_ORGANIZATION_ID | NUMBER | Transfer owning organization identifier | ||
| TRANSFER_OWNING_TP_TYPE | NUMBER | Transfer Owning Trading Partner Type. The values are based on MTL_TP_TYPES lookup. | ||
| PLANNING_ORGANIZATION_ID | NUMBER | Planning organization identifier | ||
| PLANNING_TP_TYPE | NUMBER | Planning Trading Partner Type. The values are based on MTL_TP_TYPES lookup. | ||
| XFR_PLANNING_ORGANIZATION_ID | NUMBER | Transfer planning organization identifier | ||
| TRANSFER_PLANNING_TP_TYPE | NUMBER | Transfer Planning Trading Partner Type. The values are based on MTL_TP_TYPES lookup. | ||
| SECONDARY_UOM_CODE | VARCHAR2 | (240) | Secondary unit of measure that may have been used to do the material transaction | |
| SECONDARY_TRANSACTION_QUANTITY | NUMBER | Secondary quantity | ||
| ALLOCATED_LPN_ID | NUMBER | Allocated LPN Identifier | ||
| SCHEDULE_NUMBER | VARCHAR2 | (60) | Schedule number | |
| SCHEDULED_FLAG | NUMBER | Scheduled Flag | ||
| CLASS_CODE | VARCHAR2 | (10) | Class code; This column is called ACCOUNTING_CLASS in MTL_TRANSACTIONS_INTERFACE | |
| SCHEDULE_GROUP | NUMBER | Schedule Group | ||
| BUILD_SEQUENCE | NUMBER | Build Sequence | ||
| BOM_REVISION | VARCHAR2 | (3) | BOM Revision | |
| ROUTING_REVISION | VARCHAR2 | (3) | Routing Revision | |
| BOM_REVISION_DATE | DATE | BOM Revision Date | ||
| ROUTING_REVISION_DATE | DATE | Routing Revision Date | ||
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | Alternate BOM Designator | |
| ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | Alternate Routing Designator | |
| TRANSACTION_BATCH_ID | NUMBER | Batch Identifier for transaction | ||
| TRANSACTION_BATCH_SEQ | NUMBER | Batch Sequence for Transactions | ||
| OPERATION_PLAN_ID | NUMBER | Operation plan ID assigned by rule based operation plan selection process | ||
| INTRANSIT_ACCOUNT | NUMBER | INTRANSIT_ACCOUNT corresponds to INV_INTRANSIT_ACCOUNT in mtl_interorg_parameters | ||
| FOB_POINT | NUMBER | FOB_POINT corresponds to the FOB_POINT in mtl_interorg_parameters | ||
| MOVE_ORDER_HEADER_ID | NUMBER | Move Order Header ID identifier | ||
| SERIAL_ALLOCATED_FLAG | VARCHAR2 | (1) | Serial Allocated Flag | |
| TRX_FLOW_HEADER_ID | NUMBER | Indicates the transaction flow that is being used for this transaction | ||
| LOGICAL_TRX_TYPE_CODE | NUMBER | Identifies the Logical Transaction Type that originated the logical transactions | ||
| ORIGINAL_TRANSACTION_TEMP_ID | NUMBER | Required for electronic records to keep the original transaction's temp ID | ||
| TRANSFER_SECONDARY_QUANTITY | NUMBER | Transfer Secondary Quantity | ||
| TRANSFER_SECONDARY_UOM | VARCHAR2 | (3) | Transfer Secondary UOM | |
| RELIEVE_RESERVATIONS_FLAG | VARCHAR2 | (1) | Indicates whether to relieve the reservations during transaction processing | |
| RELIEVE_HIGH_LEVEL_RSV_FLAG | VARCHAR2 | (1) | Indicates whether to check for high level reservations that needs to be relieved during transaction processing | |
| TRANSFER_PRICE | NUMBER | Transfer Price | ||
| MATERIAL_EXPENSE_ACCOUNT | NUMBER | Specifies the material expense account | ||
| FULFILLMENT_BASE | VARCHAR2 | (1) | Fulfillment Base - 'P' (or null) is Primary, 'S' is Secondary |
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_TEMP;
INV.MTL_MATERIAL_TRANSACTIONS_TEMP does not reference any database object
INV.MTL_MATERIAL_TRANSACTIONS_TEMP is referenced by following:
INV
MTL_MATERIAL_TRANSACTIONS_TEM#
|
|
|
|