Skip to content

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

VIEW: INV.MTL_TRANSACTIONS_INTERFACE#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_INTERFACE_ID NUMBER

TRANSACTION_HEADER_ID NUMBER

SOURCE_CODE VARCHAR2 (30) Yes
SOURCE_LINE_ID NUMBER
Yes
SOURCE_HEADER_ID NUMBER
Yes
PROCESS_FLAG NUMBER (1) Yes
VALIDATION_REQUIRED NUMBER

TRANSACTION_MODE NUMBER
Yes
LOCK_FLAG NUMBER (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

ITEM_SEGMENT1 VARCHAR2 (40)
ITEM_SEGMENT2 VARCHAR2 (40)
ITEM_SEGMENT3 VARCHAR2 (40)
ITEM_SEGMENT4 VARCHAR2 (40)
ITEM_SEGMENT5 VARCHAR2 (40)
ITEM_SEGMENT6 VARCHAR2 (40)
ITEM_SEGMENT7 VARCHAR2 (40)
ITEM_SEGMENT8 VARCHAR2 (40)
ITEM_SEGMENT9 VARCHAR2 (40)
ITEM_SEGMENT10 VARCHAR2 (40)
ITEM_SEGMENT11 VARCHAR2 (40)
ITEM_SEGMENT12 VARCHAR2 (40)
ITEM_SEGMENT13 VARCHAR2 (40)
ITEM_SEGMENT14 VARCHAR2 (40)
ITEM_SEGMENT15 VARCHAR2 (40)
ITEM_SEGMENT16 VARCHAR2 (40)
ITEM_SEGMENT17 VARCHAR2 (40)
ITEM_SEGMENT18 VARCHAR2 (40)
ITEM_SEGMENT19 VARCHAR2 (40)
ITEM_SEGMENT20 VARCHAR2 (40)
REVISION VARCHAR2 (3)
ORGANIZATION_ID NUMBER
Yes
TRANSACTION_QUANTITY NUMBER
Yes
PRIMARY_QUANTITY NUMBER

TRANSACTION_UOM VARCHAR2 (3) Yes
TRANSACTION_DATE DATE
Yes
ACCT_PERIOD_ID NUMBER

SUBINVENTORY_CODE VARCHAR2 (10)
LOCATOR_ID NUMBER

LOC_SEGMENT1 VARCHAR2 (40)
LOC_SEGMENT2 VARCHAR2 (40)
LOC_SEGMENT3 VARCHAR2 (40)
LOC_SEGMENT4 VARCHAR2 (40)
LOC_SEGMENT5 VARCHAR2 (40)
LOC_SEGMENT6 VARCHAR2 (40)
LOC_SEGMENT7 VARCHAR2 (40)
LOC_SEGMENT8 VARCHAR2 (40)
LOC_SEGMENT9 VARCHAR2 (40)
LOC_SEGMENT10 VARCHAR2 (40)
LOC_SEGMENT11 VARCHAR2 (40)
LOC_SEGMENT12 VARCHAR2 (40)
LOC_SEGMENT13 VARCHAR2 (40)
LOC_SEGMENT14 VARCHAR2 (40)
LOC_SEGMENT15 VARCHAR2 (40)
LOC_SEGMENT16 VARCHAR2 (40)
LOC_SEGMENT17 VARCHAR2 (40)
LOC_SEGMENT18 VARCHAR2 (40)
LOC_SEGMENT19 VARCHAR2 (40)
LOC_SEGMENT20 VARCHAR2 (40)
TRANSACTION_SOURCE_ID NUMBER

DSP_SEGMENT1 VARCHAR2 (40)
DSP_SEGMENT2 VARCHAR2 (40)
DSP_SEGMENT3 VARCHAR2 (40)
DSP_SEGMENT4 VARCHAR2 (40)
DSP_SEGMENT5 VARCHAR2 (40)
DSP_SEGMENT6 VARCHAR2 (40)
DSP_SEGMENT7 VARCHAR2 (40)
DSP_SEGMENT8 VARCHAR2 (40)
DSP_SEGMENT9 VARCHAR2 (40)
DSP_SEGMENT10 VARCHAR2 (40)
DSP_SEGMENT11 VARCHAR2 (40)
DSP_SEGMENT12 VARCHAR2 (40)
DSP_SEGMENT13 VARCHAR2 (40)
DSP_SEGMENT14 VARCHAR2 (40)
DSP_SEGMENT15 VARCHAR2 (40)
DSP_SEGMENT16 VARCHAR2 (40)
DSP_SEGMENT17 VARCHAR2 (40)
DSP_SEGMENT18 VARCHAR2 (40)
DSP_SEGMENT19 VARCHAR2 (40)
DSP_SEGMENT20 VARCHAR2 (40)
DSP_SEGMENT21 VARCHAR2 (40)
DSP_SEGMENT22 VARCHAR2 (40)
DSP_SEGMENT23 VARCHAR2 (40)
DSP_SEGMENT24 VARCHAR2 (40)
DSP_SEGMENT25 VARCHAR2 (40)
DSP_SEGMENT26 VARCHAR2 (40)
DSP_SEGMENT27 VARCHAR2 (40)
DSP_SEGMENT28 VARCHAR2 (40)
DSP_SEGMENT29 VARCHAR2 (40)
DSP_SEGMENT30 VARCHAR2 (40)
TRANSACTION_SOURCE_NAME VARCHAR2 (80)
TRANSACTION_SOURCE_TYPE_ID NUMBER

TRANSACTION_ACTION_ID NUMBER

TRANSACTION_TYPE_ID NUMBER
Yes
REASON_ID NUMBER

TRANSACTION_REFERENCE VARCHAR2 (240)
TRANSACTION_COST NUMBER

DISTRIBUTION_ACCOUNT_ID NUMBER

DST_SEGMENT1 VARCHAR2 (25)
DST_SEGMENT2 VARCHAR2 (25)
DST_SEGMENT3 VARCHAR2 (25)
DST_SEGMENT4 VARCHAR2 (25)
DST_SEGMENT5 VARCHAR2 (25)
DST_SEGMENT6 VARCHAR2 (25)
DST_SEGMENT7 VARCHAR2 (25)
DST_SEGMENT8 VARCHAR2 (25)
DST_SEGMENT9 VARCHAR2 (25)
DST_SEGMENT10 VARCHAR2 (25)
DST_SEGMENT11 VARCHAR2 (25)
DST_SEGMENT12 VARCHAR2 (25)
DST_SEGMENT13 VARCHAR2 (25)
DST_SEGMENT14 VARCHAR2 (25)
DST_SEGMENT15 VARCHAR2 (25)
DST_SEGMENT16 VARCHAR2 (25)
DST_SEGMENT17 VARCHAR2 (25)
DST_SEGMENT18 VARCHAR2 (25)
DST_SEGMENT19 VARCHAR2 (25)
DST_SEGMENT20 VARCHAR2 (25)
DST_SEGMENT21 VARCHAR2 (25)
DST_SEGMENT22 VARCHAR2 (25)
DST_SEGMENT23 VARCHAR2 (25)
DST_SEGMENT24 VARCHAR2 (25)
DST_SEGMENT25 VARCHAR2 (25)
DST_SEGMENT26 VARCHAR2 (25)
DST_SEGMENT27 VARCHAR2 (25)
DST_SEGMENT28 VARCHAR2 (25)
DST_SEGMENT29 VARCHAR2 (25)
DST_SEGMENT30 VARCHAR2 (25)
REQUISITION_LINE_ID NUMBER

CURRENCY_CODE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_RATE NUMBER

USSGL_TRANSACTION_CODE VARCHAR2 (30)
WIP_ENTITY_TYPE NUMBER

SCHEDULE_ID NUMBER

EMPLOYEE_CODE VARCHAR2 (10)
DEPARTMENT_ID NUMBER

SCHEDULE_UPDATE_CODE NUMBER

SETUP_TEARDOWN_CODE NUMBER

PRIMARY_SWITCH NUMBER

MRP_CODE NUMBER

OPERATION_SEQ_NUM NUMBER

REPETITIVE_LINE_ID NUMBER

PICKING_LINE_ID NUMBER

TRX_SOURCE_LINE_ID NUMBER

TRX_SOURCE_DELIVERY_ID NUMBER

DEMAND_ID NUMBER

CUSTOMER_SHIP_ID NUMBER

LINE_ITEM_NUM NUMBER

RECEIVING_DOCUMENT VARCHAR2 (10)
RCV_TRANSACTION_ID NUMBER

SHIP_TO_LOCATION_ID NUMBER

ENCUMBRANCE_ACCOUNT NUMBER

ENCUMBRANCE_AMOUNT NUMBER

VENDOR_LOT_NUMBER VARCHAR2 (30)
TRANSFER_SUBINVENTORY VARCHAR2 (10)
TRANSFER_ORGANIZATION NUMBER

TRANSFER_LOCATOR NUMBER

XFER_LOC_SEGMENT1 VARCHAR2 (40)
XFER_LOC_SEGMENT2 VARCHAR2 (40)
XFER_LOC_SEGMENT3 VARCHAR2 (40)
XFER_LOC_SEGMENT4 VARCHAR2 (40)
XFER_LOC_SEGMENT5 VARCHAR2 (40)
XFER_LOC_SEGMENT6 VARCHAR2 (40)
XFER_LOC_SEGMENT7 VARCHAR2 (40)
XFER_LOC_SEGMENT8 VARCHAR2 (40)
XFER_LOC_SEGMENT9 VARCHAR2 (40)
XFER_LOC_SEGMENT10 VARCHAR2 (40)
XFER_LOC_SEGMENT11 VARCHAR2 (40)
XFER_LOC_SEGMENT12 VARCHAR2 (40)
XFER_LOC_SEGMENT13 VARCHAR2 (40)
XFER_LOC_SEGMENT14 VARCHAR2 (40)
XFER_LOC_SEGMENT15 VARCHAR2 (40)
XFER_LOC_SEGMENT16 VARCHAR2 (40)
XFER_LOC_SEGMENT17 VARCHAR2 (40)
XFER_LOC_SEGMENT18 VARCHAR2 (40)
XFER_LOC_SEGMENT19 VARCHAR2 (40)
XFER_LOC_SEGMENT20 VARCHAR2 (40)
SHIPMENT_NUMBER VARCHAR2 (30)
TRANSPORTATION_COST NUMBER

TRANSPORTATION_ACCOUNT NUMBER

TRANSFER_COST NUMBER

FREIGHT_CODE VARCHAR2 (30)
CONTAINERS NUMBER

WAYBILL_AIRBILL VARCHAR2 (30)
EXPECTED_ARRIVAL_DATE DATE

NEW_AVERAGE_COST NUMBER

VALUE_CHANGE NUMBER

PERCENTAGE_CHANGE NUMBER

DEMAND_SOURCE_HEADER_ID NUMBER

DEMAND_SOURCE_LINE VARCHAR2 (30)
DEMAND_SOURCE_DELIVERY VARCHAR2 (30)
NEGATIVE_REQ_FLAG NUMBER

ERROR_EXPLANATION VARCHAR2 (240)
SHIPPABLE_FLAG VARCHAR2 (1)
ERROR_CODE VARCHAR2 (240)
REQUIRED_FLAG VARCHAR2 (1)
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)
REQUISITION_DISTRIBUTION_ID NUMBER

MOVEMENT_ID NUMBER

RESERVATION_QUANTITY NUMBER

SHIPPED_QUANTITY NUMBER

INVENTORY_ITEM VARCHAR2 (2000)
LOCATOR_NAME VARCHAR2 (2000)
TASK_ID NUMBER (15)
TO_TASK_ID NUMBER (15)
SOURCE_TASK_ID NUMBER

PROJECT_ID NUMBER (15)
TO_PROJECT_ID NUMBER (15)
SOURCE_PROJECT_ID NUMBER

PA_EXPENDITURE_ORG_ID NUMBER

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

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)
ACCOUNTING_CLASS VARCHAR2 (10)
DEMAND_CLASS VARCHAR2 (30)
PARENT_ID NUMBER

SUBSTITUTION_TYPE_ID NUMBER

SUBSTITUTION_ITEM_ID NUMBER

SCHEDULE_GROUP NUMBER

BUILD_SEQUENCE NUMBER

SCHEDULE_NUMBER VARCHAR2 (30)
SCHEDULED_FLAG NUMBER

FLOW_SCHEDULE VARCHAR2 (1)
COST_GROUP_ID NUMBER

KANBAN_CARD_ID NUMBER

QA_COLLECTION_ID NUMBER

OVERCOMPLETION_TRANSACTION_QTY NUMBER

OVERCOMPLETION_PRIMARY_QTY NUMBER

OVERCOMPLETION_TRANSACTION_ID NUMBER

END_ITEM_UNIT_NUMBER VARCHAR2 (60)
SCHEDULED_PAYBACK_DATE DATE

ORG_COST_GROUP_ID NUMBER

COST_TYPE_ID NUMBER

SOURCE_LOT_NUMBER VARCHAR2 (80)
TRANSFER_COST_GROUP_ID NUMBER

LPN_ID NUMBER

TRANSFER_LPN_ID NUMBER

CONTENT_LPN_ID NUMBER

XML_DOCUMENT_ID 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

TRANSACTION_GROUP_ID NUMBER

TRANSACTION_GROUP_SEQ NUMBER

REPRESENTATIVE_LOT_NUMBER VARCHAR2 (80)
TRANSACTION_BATCH_ID NUMBER

TRANSACTION_BATCH_SEQ NUMBER

REBUILD_ITEM_ID NUMBER

REBUILD_SERIAL_NUMBER VARCHAR2 (30)
REBUILD_ACTIVITY_ID NUMBER

REBUILD_JOB_NAME VARCHAR2 (240)
MOVE_TRANSACTION_ID NUMBER

COMPLETION_TRANSACTION_ID NUMBER

WIP_SUPPLY_TYPE NUMBER

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

MATERIAL_EXPENSE_ACCOUNT NUMBER

Query Text

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#;

Dependencies

[top of page]

INV.MTL_TRANSACTIONS_INTERFACE# references the following:

SchemaINV
TableMTL_TRANSACTIONS_INTERFACE
INV.MTL_TRANSACTIONS_INTERFACE# is referenced by following:

SchemaAPPS
SynonymMTL_TRANSACTIONS_INTERFACE