[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_TRANSACTIONS_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | INV |
| FND Design Data: |  INV.MTL_TRANSACTIONS_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
MTL_TRANSACTIONS_INTERFACE allows calling applications to post
material transactions (movements, issues, receipts etc. to Oracle Inventory
transaction module.
Transaction Manager concurrent program polls this table at a
user-specified process interval, and submits the Transaction Workers
to process them. Processing consists of data derivation, validation,
and the transfer of records from MTL_TRANSACTIONS_INTERFACE,
MTL_TRANSACTION_LOTS_INTERFACE, and MTL_SERIAL_NUMBERS_INTERFACE into
their respective temporary tables, from where they are processed by the
transaction processor.
MTL_TRANSACTIONS_INTERFACE follows the Inventory standard for
interfacing flexfields. Any parameters which are represented by
flexfields may be entered in the interface table either as code
combination identifiers or as flexfield segment combinations. The
Transaction Worker will validate that any given identifiers are valid
and enabled. If no identifier is given, then the Transaction Worker
will validate and decode the flexfield segment values, and where
appropriate, create new flexfield combinations in the database.
The Transaction Manager picks up the rows to process based on the
LOCK_FLAG, TRANSACTION_MODE, PROCESS_FLAG.
Only records with TRANSACTION_MODE of '3', LOCK_FLAG of '2',
and PROCESS_FLAG of '1' will be picked up by the Transaction Manager
and assigned to a Transaction Worker. If a record fails to process
completely, then PROCESS_FLAG will be set to '3' and ERROR_CODE and
ERROR_EXPLANATION will be populated with the cause for the error.
Scope: public
Lifecycle: active
Display Name: Material Transactions Interface
Product: INV
Category: BUSINESS_ENTITY INV_MATERIAL_TRANSACTION
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MTL_TRANSACTIONS_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 TRANSACTION_INTERFACE_ID
|
| MTL_TRANSACTIONS_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRANSACTION_HEADER_ID
|
| MTL_TRANSACTIONS_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PARENT_ID
|
| MTL_TRANSACTIONS_INTERFACE_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PICKING_LINE_ID
|
| MTL_TRANSACTIONS_INTERFACE_N4 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRANSACTION_SOURCE_TYPE_ID
TRANSACTION_ACTION_ID
TRANSACTION_SOURCE_ID
|
| MTL_TRANSACTIONS_INTERFACE_N5 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRX_SOURCE_LINE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTION_INTERFACE_ID | NUMBER | Transaction interface line identifier | ||
| TRANSACTION_HEADER_ID | NUMBER | Transaction group identifier and Workers, only user-specified values will be ignored | ||
| SOURCE_CODE | VARCHAR2 | (30) | Yes | Transaction source identifier; Used for auditing and process control |
| SOURCE_LINE_ID | NUMBER | Yes | Transaction source line identifier; Used for auditing only | |
| SOURCE_HEADER_ID | NUMBER | Yes | Transaction source group identifier; Used for process control by user-submitted Transaction Workers | |
| PROCESS_FLAG | NUMBER | (1) | Yes | Flag indicating whether transaction is ready to be processed by the Transaction Manager or Worker ('1' for ready, '2' for not ready); if the transaction fails for some reason, the Transaction Worker sets the value of PROCESS_FLAG to '3' |
| VALIDATION_REQUIRED | NUMBER | Full validation required flag | ||
| TRANSACTION_MODE | NUMBER | Yes | Code that indicates whether the transaction is to be processed in immediate concurrent processing mode (2) or background processing mode (3) | |
| LOCK_FLAG | NUMBER | (1) | Flag indicating whether the transaction is locked by the Transaction Manager or Workers ('1' for locked, '2' or NULL for not locked); this prevents two different Workers from processing the same transaction; You should always specify '2' | |
| 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 | Request Identifier | ||
| PROGRAM_APPLICATION_ID | NUMBER | Program application Identifier | ||
| PROGRAM_ID | NUMBER | Program Identifier | ||
| PROGRAM_UPDATE_DATE | DATE | Program update date | ||
| INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
| ITEM_SEGMENT1 | VARCHAR2 | (40) | Inventory item segment identifier 1 | |
| ITEM_SEGMENT2 | VARCHAR2 | (40) | Inventory item segment identifier 2 | |
| ITEM_SEGMENT3 | VARCHAR2 | (40) | Inventory item segment identifier 3 | |
| ITEM_SEGMENT4 | VARCHAR2 | (40) | Inventory item segment identifier 4 | |
| ITEM_SEGMENT5 | VARCHAR2 | (40) | Inventory item segment identifier 5 | |
| ITEM_SEGMENT6 | VARCHAR2 | (40) | Inventory item segment identifier 6 | |
| ITEM_SEGMENT7 | VARCHAR2 | (40) | Inventory item segment identifier 7 | |
| ITEM_SEGMENT8 | VARCHAR2 | (40) | Inventory item segment identifier 8 | |
| ITEM_SEGMENT9 | VARCHAR2 | (40) | Inventory item segment identifier 9 | |
| ITEM_SEGMENT10 | VARCHAR2 | (40) | Inventory item segment identifier 10 | |
| ITEM_SEGMENT11 | VARCHAR2 | (40) | Inventory item segment identifier 11 | |
| ITEM_SEGMENT12 | VARCHAR2 | (40) | Inventory item segment identifier 12 | |
| ITEM_SEGMENT13 | VARCHAR2 | (40) | Inventory item segment identifier 13 | |
| ITEM_SEGMENT14 | VARCHAR2 | (40) | Inventory item segment identifier 14 | |
| ITEM_SEGMENT15 | VARCHAR2 | (40) | Inventory item segment identifier 15 | |
| ITEM_SEGMENT16 | VARCHAR2 | (40) | Inventory item segment identifier 16 | |
| ITEM_SEGMENT17 | VARCHAR2 | (40) | Inventory item segment identifier 17 | |
| ITEM_SEGMENT18 | VARCHAR2 | (40) | Inventory item segment identifier 18 | |
| ITEM_SEGMENT19 | VARCHAR2 | (40) | Inventory item segment identifier 19 | |
| ITEM_SEGMENT20 | VARCHAR2 | (40) | Inventory item segment identifier 20 | |
| REVISION | VARCHAR2 | (3) | Inventory item revision code | |
| ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
| TRANSACTION_QUANTITY | NUMBER | Yes | Transaction quantity | |
| PRIMARY_QUANTITY | NUMBER | Transaction quantity in primary unit of measure | ||
| TRANSACTION_UOM | VARCHAR2 | (3) | Yes | Transaction unit of measure |
| TRANSACTION_DATE | DATE | Yes | Transaction date; No timestamp, will be truncated by Transaction Worker | |
| ACCT_PERIOD_ID | NUMBER | Accounting period identifier; the Transaction Worker derives this information from the TRANSACTION_DATE column | ||
| SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory name | |
| LOCATOR_ID | NUMBER | Locator identifier; locator must be specified for items under locator control either by locator identifier, or by individual segment values | ||
| LOC_SEGMENT1 | VARCHAR2 | (40) | Locator identifier 1 | |
| LOC_SEGMENT2 | VARCHAR2 | (40) | Locator identifier 2 | |
| LOC_SEGMENT3 | VARCHAR2 | (40) | Locator identifier 3 | |
| LOC_SEGMENT4 | VARCHAR2 | (40) | Locator identifier 4 | |
| LOC_SEGMENT5 | VARCHAR2 | (40) | Locator identifier 5 | |
| LOC_SEGMENT6 | VARCHAR2 | (40) | Locator identifier 6 | |
| LOC_SEGMENT7 | VARCHAR2 | (40) | Locator identifier 7 | |
| LOC_SEGMENT8 | VARCHAR2 | (40) | Locator identifier 8 | |
| LOC_SEGMENT9 | VARCHAR2 | (40) | Locator identifier 9 | |
| LOC_SEGMENT10 | VARCHAR2 | (40) | Locator identifier 10 | |
| LOC_SEGMENT11 | VARCHAR2 | (40) | Locator identifier 11 | |
| LOC_SEGMENT12 | VARCHAR2 | (40) | Locator identifier 12 | |
| LOC_SEGMENT13 | VARCHAR2 | (40) | Locator identifier 13 | |
| LOC_SEGMENT14 | VARCHAR2 | (40) | Locator identifier 14 | |
| LOC_SEGMENT15 | VARCHAR2 | (40) | Locator identifier 15 | |
| LOC_SEGMENT16 | VARCHAR2 | (40) | Locator identifier 16 | |
| LOC_SEGMENT17 | VARCHAR2 | (40) | Locator identifier 17 | |
| LOC_SEGMENT18 | VARCHAR2 | (40) | Locator identifier 18 | |
| LOC_SEGMENT19 | VARCHAR2 | (40) | Locator identifier 19 | |
| LOC_SEGMENT20 | VARCHAR2 | (40) | Locator identifier 20 | |
| TRANSACTION_SOURCE_ID | NUMBER | Transaction source identifier | ||
| DSP_SEGMENT1 | VARCHAR2 | (40) | Transaction source segment 1 | |
| DSP_SEGMENT2 | VARCHAR2 | (40) | Transaction source segment 2 | |
| DSP_SEGMENT3 | VARCHAR2 | (40) | Transaction source segment 3 | |
| DSP_SEGMENT4 | VARCHAR2 | (40) | Transaction source segment 4 | |
| DSP_SEGMENT5 | VARCHAR2 | (40) | Transaction source segment 5 | |
| DSP_SEGMENT6 | VARCHAR2 | (40) | Transaction source segment 6 | |
| DSP_SEGMENT7 | VARCHAR2 | (40) | Transaction source segment 7 | |
| DSP_SEGMENT8 | VARCHAR2 | (40) | Transaction source segment 8 | |
| DSP_SEGMENT9 | VARCHAR2 | (40) | Transaction source segment 9 | |
| DSP_SEGMENT10 | VARCHAR2 | (40) | Transaction source segment 10 | |
| DSP_SEGMENT11 | VARCHAR2 | (40) | Transaction source segment 11 | |
| DSP_SEGMENT12 | VARCHAR2 | (40) | Transaction source segment 12 | |
| DSP_SEGMENT13 | VARCHAR2 | (40) | Transaction source segment 13 | |
| DSP_SEGMENT14 | VARCHAR2 | (40) | Transaction source segment 14 | |
| DSP_SEGMENT15 | VARCHAR2 | (40) | Transaction source segment 15 | |
| DSP_SEGMENT16 | VARCHAR2 | (40) | Transaction source segment 16 | |
| DSP_SEGMENT17 | VARCHAR2 | (40) | Transaction source segment 17 | |
| DSP_SEGMENT18 | VARCHAR2 | (40) | Transaction source segment 18 | |
| DSP_SEGMENT19 | VARCHAR2 | (40) | Transaction source segment 19 | |
| DSP_SEGMENT20 | VARCHAR2 | (40) | Transaction source segment 20 | |
| DSP_SEGMENT21 | VARCHAR2 | (40) | Transaction source segment 21 | |
| DSP_SEGMENT22 | VARCHAR2 | (40) | Transaction source segment 22 | |
| DSP_SEGMENT23 | VARCHAR2 | (40) | Transaction source segment 23 | |
| DSP_SEGMENT24 | VARCHAR2 | (40) | Transaction source segment 24 | |
| DSP_SEGMENT25 | VARCHAR2 | (40) | Transaction source segment 25 | |
| DSP_SEGMENT26 | VARCHAR2 | (40) | Transaction source segment 26 | |
| DSP_SEGMENT27 | VARCHAR2 | (40) | Transaction source segment 27 | |
| DSP_SEGMENT28 | VARCHAR2 | (40) | Transaction source segment 28 | |
| DSP_SEGMENT29 | VARCHAR2 | (40) | Transaction source segment 29 | |
| DSP_SEGMENT30 | VARCHAR2 | (40) | Transaction source segment 30 | |
| TRANSACTION_SOURCE_NAME | VARCHAR2 | (80) | Transaction source identifier | |
| TRANSACTION_SOURCE_TYPE_ID | NUMBER | Transaction source type identifier | ||
| TRANSACTION_ACTION_ID | NUMBER | Transaction action identifier | ||
| TRANSACTION_TYPE_ID | NUMBER | Yes | Transaction type identifier | |
| REASON_ID | NUMBER | Transaction reason identifier | ||
| TRANSACTION_REFERENCE | VARCHAR2 | (240) | Transaction reference | |
| TRANSACTION_COST | NUMBER | Transaction cost; this is a per-unit value | ||
| DISTRIBUTION_ACCOUNT_ID | NUMBER | GL code combination identifier | ||
| DST_SEGMENT1 | VARCHAR2 | (25) | Distribution account segment identifier 1 | |
| DST_SEGMENT2 | VARCHAR2 | (25) | Distribution account segment identifier 2 | |
| DST_SEGMENT3 | VARCHAR2 | (25) | Distribution account segment identifier 3 | |
| DST_SEGMENT4 | VARCHAR2 | (25) | Distribution account segment identifier 4 | |
| DST_SEGMENT5 | VARCHAR2 | (25) | Distribution account segment identifier 5 | |
| DST_SEGMENT6 | VARCHAR2 | (25) | Distribution account segment identifier 6 | |
| DST_SEGMENT7 | VARCHAR2 | (25) | Distribution account segment identifier 7 | |
| DST_SEGMENT8 | VARCHAR2 | (25) | Distribution account segment identifier 8 | |
| DST_SEGMENT9 | VARCHAR2 | (25) | Distribution account segment identifier 9 | |
| DST_SEGMENT10 | VARCHAR2 | (25) | Distribution account segment identifier 10 | |
| DST_SEGMENT11 | VARCHAR2 | (25) | Distribution account segment identifier 11 | |
| DST_SEGMENT12 | VARCHAR2 | (25) | Distribution account segment identifier 12 | |
| DST_SEGMENT13 | VARCHAR2 | (25) | Distribution account segment identifier 13 | |
| DST_SEGMENT14 | VARCHAR2 | (25) | Distribution account segment identifier 14 | |
| DST_SEGMENT15 | VARCHAR2 | (25) | Distribution account segment identifier 15 | |
| DST_SEGMENT16 | VARCHAR2 | (25) | Distribution account segment identifier 16 | |
| DST_SEGMENT17 | VARCHAR2 | (25) | Distribution account segment identifier 17 | |
| DST_SEGMENT18 | VARCHAR2 | (25) | Distribution account segment identifier 18 | |
| DST_SEGMENT19 | VARCHAR2 | (25) | Distribution account segment identifier 19 | |
| DST_SEGMENT20 | VARCHAR2 | (25) | Distribution account segment identifier 20 | |
| DST_SEGMENT21 | VARCHAR2 | (25) | Distribution account segment identifier 21 | |
| DST_SEGMENT22 | VARCHAR2 | (25) | Distribution account segment identifier 22 | |
| DST_SEGMENT23 | VARCHAR2 | (25) | Distribution account segment identifier 23 | |
| DST_SEGMENT24 | VARCHAR2 | (25) | Distribution account segment identifier 24 | |
| DST_SEGMENT25 | VARCHAR2 | (25) | Distribution account segment identifier 25 | |
| DST_SEGMENT26 | VARCHAR2 | (25) | Distribution account segment identifier 26 | |
| DST_SEGMENT27 | VARCHAR2 | (25) | Distribution account segment identifier 27 | |
| DST_SEGMENT28 | VARCHAR2 | (25) | Distribution account segment identifier 28 | |
| DST_SEGMENT29 | VARCHAR2 | (25) | Distribution account segment identifier 29 | |
| DST_SEGMENT30 | VARCHAR2 | (25) | Distribution account segment identifier 30 | |
| REQUISITION_LINE_ID | NUMBER | Requisition line identifier | ||
| CURRENCY_CODE | VARCHAR2 | (30) | Currency code | |
| CURRENCY_CONVERSION_DATE | DATE | Currency conversion date | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
| CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate | ||
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | USSGL transaction code | |
| WIP_ENTITY_TYPE | NUMBER | WIP entity type | ||
| SCHEDULE_ID | NUMBER | WIP repetitive schedule identifier | ||
| EMPLOYEE_CODE | VARCHAR2 | (10) | Employee code | |
| DEPARTMENT_ID | NUMBER | WIP department code | ||
| SCHEDULE_UPDATE_CODE | NUMBER | Code indicating whether or not to update the Master Production Schedule | ||
| SETUP_TEARDOWN_CODE | NUMBER | Setup Teardown code | ||
| PRIMARY_SWITCH | NUMBER | Flag indicating whether inventory item is a primary assembly for WIP (1 for primary assembly, null otherwise) | ||
| MRP_CODE | NUMBER | Code indicating whether MRP should be relieved for WIP | ||
| OPERATION_SEQ_NUM | NUMBER | Operation sequence number within a routing | ||
| REPETITIVE_LINE_ID | NUMBER | Repetitive line identifier | ||
| PICKING_LINE_ID | NUMBER | Reservation picking line identifier | ||
| TRX_SOURCE_LINE_ID | NUMBER | Line identifier for sales orders | ||
| TRX_SOURCE_DELIVERY_ID | NUMBER | Delivery identifier for sales orders | ||
| DEMAND_ID | NUMBER | Demand identifier | ||
| CUSTOMER_SHIP_ID | NUMBER | Customer ship-to address identifier for sales orders | ||
| LINE_ITEM_NUM | NUMBER | Line item number for purchase orders | ||
| RECEIVING_DOCUMENT | VARCHAR2 | (10) | Receiving document identifier | |
| RCV_TRANSACTION_ID | NUMBER | Receiving transaction identifier; Not currently used | ||
| SHIP_TO_LOCATION_ID | NUMBER | Ship to location identifier | ||
| ENCUMBRANCE_ACCOUNT | NUMBER | Encumbrance account identifier | ||
| ENCUMBRANCE_AMOUNT | NUMBER | Encumbrance amount | ||
| VENDOR_LOT_NUMBER | VARCHAR2 | (30) | Supplier lot number | |
| TRANSFER_SUBINVENTORY | VARCHAR2 | (10) | Destination subinventory name for a transfer transaction | |
| TRANSFER_ORGANIZATION | NUMBER | Destination organization identifier for transfer transactions | ||
| TRANSFER_LOCATOR | NUMBER | Destination locator identifier for transfer transactions; transfer to location must be specified for inventory items under location control either by transfer to location identifier, or by individual segment values | ||
| XFER_LOC_SEGMENT1 | VARCHAR2 | (40) | Transfer locator segment identifier 1 | |
| XFER_LOC_SEGMENT2 | VARCHAR2 | (40) | Transfer locator segment identifier 2 | |
| XFER_LOC_SEGMENT3 | VARCHAR2 | (40) | Transfer locator segment identifier 3 | |
| XFER_LOC_SEGMENT4 | VARCHAR2 | (40) | Transfer locator segment identifier 4 | |
| XFER_LOC_SEGMENT5 | VARCHAR2 | (40) | Transfer locator segment identifier 5 | |
| XFER_LOC_SEGMENT6 | VARCHAR2 | (40) | Transfer locator segment identifier 6 | |
| XFER_LOC_SEGMENT7 | VARCHAR2 | (40) | Transfer locator segment identifier 7 | |
| XFER_LOC_SEGMENT8 | VARCHAR2 | (40) | Transfer locator segment identifier 8 | |
| XFER_LOC_SEGMENT9 | VARCHAR2 | (40) | Transfer locator segment identifier 9 | |
| XFER_LOC_SEGMENT10 | VARCHAR2 | (40) | Transfer locator segment identifier 10 | |
| XFER_LOC_SEGMENT11 | VARCHAR2 | (40) | Transfer locator segment identifier 11 | |
| XFER_LOC_SEGMENT12 | VARCHAR2 | (40) | Transfer locator segment identifier 12 | |
| XFER_LOC_SEGMENT13 | VARCHAR2 | (40) | Transfer locator segment identifier 13 | |
| XFER_LOC_SEGMENT14 | VARCHAR2 | (40) | Transfer locator segment identifier 14 | |
| XFER_LOC_SEGMENT15 | VARCHAR2 | (40) | Transfer locator segment identifier 15 | |
| XFER_LOC_SEGMENT16 | VARCHAR2 | (40) | Transfer locator segment identifier 16 | |
| XFER_LOC_SEGMENT17 | VARCHAR2 | (40) | Transfer locator segment identifier 17 | |
| XFER_LOC_SEGMENT18 | VARCHAR2 | (40) | Transfer locator segment identifier 18 | |
| XFER_LOC_SEGMENT19 | VARCHAR2 | (40) | Transfer locator segment identifier 19 | |
| XFER_LOC_SEGMENT20 | VARCHAR2 | (40) | Transfer locator segment identifier 20 | |
| SHIPMENT_NUMBER | VARCHAR2 | (30) | Shipment number identifier | |
| TRANSPORTATION_COST | NUMBER | Transportation cost; per-transaction value | ||
| TRANSPORTATION_ACCOUNT | NUMBER | Transportation account identifier | ||
| TRANSFER_COST | NUMBER | Transfer cost; per-transaction value | ||
| FREIGHT_CODE | VARCHAR2 | (30) | Freight identifier | |
| CONTAINERS | NUMBER | Number of containers | ||
| WAYBILL_AIRBILL | VARCHAR2 | (30) | Waybill/airbill identifier | |
| EXPECTED_ARRIVAL_DATE | DATE | Expected arrival date; truncated, no timestamp | ||
| 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 | Percentage change for average cost update | ||
| 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 delivery identifier | |
| NEGATIVE_REQ_FLAG | NUMBER | Negative requirement flag | ||
| ERROR_EXPLANATION | VARCHAR2 | (240) | Error explanation | |
| SHIPPABLE_FLAG | VARCHAR2 | (1) | Item shippable flag | |
| ERROR_CODE | VARCHAR2 | (240) | Error code | |
| REQUIRED_FLAG | VARCHAR2 | (1) | Required flag | |
| 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 | |
| REQUISITION_DISTRIBUTION_ID | NUMBER | Requisition distribution identifier | ||
| MOVEMENT_ID | NUMBER | Movement statistics cross reference | ||
| RESERVATION_QUANTITY | NUMBER | Reservation quantity | ||
| SHIPPED_QUANTITY | NUMBER | Shipped quantity | ||
| INVENTORY_ITEM | VARCHAR2 | (2000) | Concatenated inventory item number used for shipping transactions interface | |
| LOCATOR_NAME | VARCHAR2 | (2000) | Concatenated inventory locator name for shipping transactions interface | |
| 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 | |
| TO_PROJECT_ID | NUMBER | (15) | "To" Project identifier | |
| SOURCE_PROJECT_ID | NUMBER | Source project identifier | ||
| PA_EXPENDITURE_ORG_ID | NUMBER | Oracle Projects related expenditure organization 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 | Indicates the percentage of value to be attributed 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 | ||
| BOM_REVISION | VARCHAR2 | (3) | Item revision used for getting the bill information while backflushing the flow schedule | |
| ROUTING_REVISION | VARCHAR2 | (3) | Routing revision used for getting the routing information while charging the flow schedule | |
| BOM_REVISION_DATE | DATE | Date of inventory item revision used for exploding the bill for the flow schedule | ||
| ROUTING_REVISION_DATE | DATE | Date of item routing revision used for exploding the routing for the flow schedule | ||
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | Alternate BOM designator | |
| ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | Alternate Routing designator | |
| ACCOUNTING_CLASS | VARCHAR2 | (10) | Accounting class to be used for the flow schedule | |
| DEMAND_CLASS | VARCHAR2 | (30) | The class to which the demand is tied | |
| PARENT_ID | NUMBER | In substitution records for flow schedules, specifies the parent completion records transaction interface id | ||
| SUBSTITUTION_TYPE_ID | NUMBER | Identifies the kind of substitution allowed | ||
| SUBSTITUTION_ITEM_ID | NUMBER | The substitution item's inventory Item ID | ||
| SCHEDULE_GROUP | NUMBER | Specifies schedule group (used for flow manufacturing) | ||
| BUILD_SEQUENCE | NUMBER | Specifies the sequence to be built (used for flow manufacturing) | ||
| SCHEDULE_NUMBER | VARCHAR2 | (30) | Flow schedule number | |
| SCHEDULED_FLAG | NUMBER | Specifies whether flow schedule is scheduled or not | ||
| FLOW_SCHEDULE | VARCHAR2 | (1) | Specifies whether the WIP transaction is a flow or schedule type transaction | |
| COST_GROUP_ID | NUMBER | Cost group identifier - Used by WMS only | ||
| KANBAN_CARD_ID | NUMBER | Kanban Card Identifier | ||
| QA_COLLECTION_ID | NUMBER | QA Results 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 | ||
| ORG_COST_GROUP_ID | NUMBER | Cost group of organization | ||
| COST_TYPE_ID | NUMBER | Organization Cost type | ||
| SOURCE_LOT_NUMBER | VARCHAR2 | (80) | Source Lot Number | |
| TRANSFER_COST_GROUP_ID | NUMBER | Transfer Cost Group Identifier | ||
| LPN_ID | NUMBER | License Plate Number Identifier | ||
| TRANSFER_LPN_ID | NUMBER | Transfer License Plate Number Identifier | ||
| CONTENT_LPN_ID | NUMBER | Transfer License Plate Number Identifier | ||
| XML_DOCUMENT_ID | VARCHAR2 | (240) | XML Document Id | |
| 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 | ||
| TRANSACTION_GROUP_ID | NUMBER | |||
| TRANSACTION_GROUP_SEQ | NUMBER | |||
| REPRESENTATIVE_LOT_NUMBER | VARCHAR2 | (80) | Representative Lot Number | |
| TRANSACTION_BATCH_ID | NUMBER | Batch id for transaction | ||
| TRANSACTION_BATCH_SEQ | NUMBER | Batch sequence for transaction | ||
| REBUILD_ITEM_ID | NUMBER | Rebuildable item that needs to be replaced/repaired | ||
| REBUILD_SERIAL_NUMBER | VARCHAR2 | (30) | Serial Number of the Rebuild Item | |
| REBUILD_ACTIVITY_ID | NUMBER | Maintenance Activity that needs to be done on rebuildable item | ||
| REBUILD_JOB_NAME | VARCHAR2 | (240) | Name of Rebuild Work Order that has been defined for rebuiladable item | |
| MOVE_TRANSACTION_ID | NUMBER | Move Transaction Identifier | ||
| COMPLETION_TRANSACTION_ID | NUMBER | Completion Transaction Identifier | ||
| WIP_SUPPLY_TYPE | NUMBER | Wip Supply Type | ||
| 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 | Expense Account |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_INTERFACE_ID
, TRANSACTION_HEADER_ID
, SOURCE_CODE
, SOURCE_LINE_ID
, SOURCE_HEADER_ID
, PROCESS_FLAG
, VALIDATION_REQUIRED
, 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
, ITEM_SEGMENT1
, ITEM_SEGMENT2
, ITEM_SEGMENT3
, ITEM_SEGMENT4
, ITEM_SEGMENT5
, ITEM_SEGMENT6
, ITEM_SEGMENT7
, ITEM_SEGMENT8
, ITEM_SEGMENT9
, ITEM_SEGMENT10
, ITEM_SEGMENT11
, ITEM_SEGMENT12
, ITEM_SEGMENT13
, ITEM_SEGMENT14
, ITEM_SEGMENT15
, ITEM_SEGMENT16
, ITEM_SEGMENT17
, ITEM_SEGMENT18
, ITEM_SEGMENT19
, ITEM_SEGMENT20
, REVISION
, ORGANIZATION_ID
, TRANSACTION_QUANTITY
, PRIMARY_QUANTITY
, TRANSACTION_UOM
, TRANSACTION_DATE
, ACCT_PERIOD_ID
, SUBINVENTORY_CODE
, LOCATOR_ID
, LOC_SEGMENT1
, LOC_SEGMENT2
, LOC_SEGMENT3
, LOC_SEGMENT4
, LOC_SEGMENT5
, LOC_SEGMENT6
, LOC_SEGMENT7
, LOC_SEGMENT8
, LOC_SEGMENT9
, LOC_SEGMENT10
, LOC_SEGMENT11
, LOC_SEGMENT12
, LOC_SEGMENT13
, LOC_SEGMENT14
, LOC_SEGMENT15
, LOC_SEGMENT16
, LOC_SEGMENT17
, LOC_SEGMENT18
, LOC_SEGMENT19
, LOC_SEGMENT20
, TRANSACTION_SOURCE_ID
, DSP_SEGMENT1
, DSP_SEGMENT2
, DSP_SEGMENT3
, DSP_SEGMENT4
, DSP_SEGMENT5
, DSP_SEGMENT6
, DSP_SEGMENT7
, DSP_SEGMENT8
, DSP_SEGMENT9
, DSP_SEGMENT10
, DSP_SEGMENT11
, DSP_SEGMENT12
, DSP_SEGMENT13
, DSP_SEGMENT14
, DSP_SEGMENT15
, DSP_SEGMENT16
, DSP_SEGMENT17
, DSP_SEGMENT18
, DSP_SEGMENT19
, DSP_SEGMENT20
, DSP_SEGMENT21
, DSP_SEGMENT22
, DSP_SEGMENT23
, DSP_SEGMENT24
, DSP_SEGMENT25
, DSP_SEGMENT26
, DSP_SEGMENT27
, DSP_SEGMENT28
, DSP_SEGMENT29
, DSP_SEGMENT30
, TRANSACTION_SOURCE_NAME
, TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_ACTION_ID
, TRANSACTION_TYPE_ID
, REASON_ID
, TRANSACTION_REFERENCE
, TRANSACTION_COST
, DISTRIBUTION_ACCOUNT_ID
, DST_SEGMENT1
, DST_SEGMENT2
, DST_SEGMENT3
, DST_SEGMENT4
, DST_SEGMENT5
, DST_SEGMENT6
, DST_SEGMENT7
, DST_SEGMENT8
, DST_SEGMENT9
, DST_SEGMENT10
, DST_SEGMENT11
, DST_SEGMENT12
, DST_SEGMENT13
, DST_SEGMENT14
, DST_SEGMENT15
, DST_SEGMENT16
, DST_SEGMENT17
, DST_SEGMENT18
, DST_SEGMENT19
, DST_SEGMENT20
, DST_SEGMENT21
, DST_SEGMENT22
, DST_SEGMENT23
, DST_SEGMENT24
, DST_SEGMENT25
, DST_SEGMENT26
, DST_SEGMENT27
, DST_SEGMENT28
, DST_SEGMENT29
, DST_SEGMENT30
, REQUISITION_LINE_ID
, CURRENCY_CODE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, USSGL_TRANSACTION_CODE
, WIP_ENTITY_TYPE
, SCHEDULE_ID
, EMPLOYEE_CODE
, DEPARTMENT_ID
, SCHEDULE_UPDATE_CODE
, SETUP_TEARDOWN_CODE
, PRIMARY_SWITCH
, MRP_CODE
, OPERATION_SEQ_NUM
, REPETITIVE_LINE_ID
, PICKING_LINE_ID
, TRX_SOURCE_LINE_ID
, TRX_SOURCE_DELIVERY_ID
, DEMAND_ID
, CUSTOMER_SHIP_ID
, LINE_ITEM_NUM
, RECEIVING_DOCUMENT
, RCV_TRANSACTION_ID
, SHIP_TO_LOCATION_ID
, ENCUMBRANCE_ACCOUNT
, ENCUMBRANCE_AMOUNT
, VENDOR_LOT_NUMBER
, TRANSFER_SUBINVENTORY
, TRANSFER_ORGANIZATION
, TRANSFER_LOCATOR
, XFER_LOC_SEGMENT1
, XFER_LOC_SEGMENT2
, XFER_LOC_SEGMENT3
, XFER_LOC_SEGMENT4
, XFER_LOC_SEGMENT5
, XFER_LOC_SEGMENT6
, XFER_LOC_SEGMENT7
, XFER_LOC_SEGMENT8
, XFER_LOC_SEGMENT9
, XFER_LOC_SEGMENT10
, XFER_LOC_SEGMENT11
, XFER_LOC_SEGMENT12
, XFER_LOC_SEGMENT13
, XFER_LOC_SEGMENT14
, XFER_LOC_SEGMENT15
, XFER_LOC_SEGMENT16
, XFER_LOC_SEGMENT17
, XFER_LOC_SEGMENT18
, XFER_LOC_SEGMENT19
, XFER_LOC_SEGMENT20
, SHIPMENT_NUMBER
, TRANSPORTATION_COST
, TRANSPORTATION_ACCOUNT
, TRANSFER_COST
, FREIGHT_CODE
, CONTAINERS
, WAYBILL_AIRBILL
, EXPECTED_ARRIVAL_DATE
, NEW_AVERAGE_COST
, VALUE_CHANGE
, PERCENTAGE_CHANGE
, DEMAND_SOURCE_HEADER_ID
, DEMAND_SOURCE_LINE
, DEMAND_SOURCE_DELIVERY
, NEGATIVE_REQ_FLAG
, ERROR_EXPLANATION
, SHIPPABLE_FLAG
, ERROR_CODE
, REQUIRED_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUISITION_DISTRIBUTION_ID
, MOVEMENT_ID
, RESERVATION_QUANTITY
, SHIPPED_QUANTITY
, INVENTORY_ITEM
, LOCATOR_NAME
, TASK_ID
, TO_TASK_ID
, SOURCE_TASK_ID
, PROJECT_ID
, TO_PROJECT_ID
, SOURCE_PROJECT_ID
, PA_EXPENDITURE_ORG_ID
, EXPENDITURE_TYPE
, FINAL_COMPLETION_FLAG
, TRANSFER_PERCENTAGE
, TRANSACTION_SEQUENCE_ID
, MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT
, RESOURCE_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT
, OVERHEAD_ACCOUNT
, BOM_REVISION
, ROUTING_REVISION
, BOM_REVISION_DATE
, ROUTING_REVISION_DATE
, ALTERNATE_BOM_DESIGNATOR
, ALTERNATE_ROUTING_DESIGNATOR
, ACCOUNTING_CLASS
, DEMAND_CLASS
, PARENT_ID
, SUBSTITUTION_TYPE_ID
, SUBSTITUTION_ITEM_ID
, SCHEDULE_GROUP
, BUILD_SEQUENCE
, SCHEDULE_NUMBER
, SCHEDULED_FLAG
, FLOW_SCHEDULE
, COST_GROUP_ID
, KANBAN_CARD_ID
, QA_COLLECTION_ID
, OVERCOMPLETION_TRANSACTION_QTY
, OVERCOMPLETION_PRIMARY_QTY
, OVERCOMPLETION_TRANSACTION_ID
, END_ITEM_UNIT_NUMBER
, SCHEDULED_PAYBACK_DATE
, ORG_COST_GROUP_ID
, COST_TYPE_ID
, SOURCE_LOT_NUMBER
, TRANSFER_COST_GROUP_ID
, LPN_ID
, TRANSFER_LPN_ID
, CONTENT_LPN_ID
, XML_DOCUMENT_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_ID
, TRANSACTION_GROUP_SEQ
, REPRESENTATIVE_LOT_NUMBER
, TRANSACTION_BATCH_ID
, TRANSACTION_BATCH_SEQ
, REBUILD_ITEM_ID
, REBUILD_SERIAL_NUMBER
, REBUILD_ACTIVITY_ID
, REBUILD_JOB_NAME
, MOVE_TRANSACTION_ID
, COMPLETION_TRANSACTION_ID
, WIP_SUPPLY_TYPE
, RELIEVE_RESERVATIONS_FLAG
, RELIEVE_HIGH_LEVEL_RSV_FLAG
, TRANSFER_PRICE
, MATERIAL_EXPENSE_ACCOUNT
FROM INV.MTL_TRANSACTIONS_INTERFACE;
INV.MTL_TRANSACTIONS_INTERFACE does not reference any database object
INV.MTL_TRANSACTIONS_INTERFACE is referenced by following:
INV
MTL_TRANSACTIONS_INTERFACE#
|
|
|
|