mtl_material_transactions关联查找

来源：互联网发布：超级淘宝系统小说编辑：程序博客网时间：2024/06/13 10:44

Oracle ebs中的事务处理表：mtl_material_transactions关联的来源活动众多。

其中主要的字段有：
1、transaction_type_id(事物处理类型)
关联表：select *
from mtl_transaction_types

2、transaction_action_id(事物处理活动)
关联表：select *
from mfg_lookups v
where lookup_type ='MTL_TRANSACTION_ACTION'

3、transaction_source_type_id(事物处理来源)
关联表：select *
from mfg_lookups m
where lookup_type ='MTL_DISPOSITION'

Table

Foreign Table

Foreign Key Column

MTL_MATERIAL_TRANSACTIONS

GL_CODE_COMBINATIONS

MTL_MATERIAL_TRANSACTIONS.

TRANSFER_COST_DIST_ACCOUNT

MTL_MATERIAL_TRANSACTIONS

MTL_ITEM_REVISIONS_B

MTL_MATERIAL_TRANSACTIONS.

INVENTORY_ITEM_ID

MTL_MATERIAL_TRANSACTIONS.

ORGANIZATION_ID

MTL_MATERIAL_TRANSACTIONS.

REVISION

MTL_MATERIAL_TRANSACTIONS

MTL_CYCLE_COUNT_ENTRIES

MTL_MATERIAL_TRANSACTIONS.

CYCLE_COUNT_ID

MTL_MATERIAL_TRANSACTIONS

MTL_PHYSICAL_ADJUSTMENTS

MTL_MATERIAL_TRANSACTIONS.

PHYSICAL_ADJUSTMENT_ID

MTL_MATERIAL_TRANSACTIONS

MTL_TRANSACTION_TYPES

MTL_MATERIAL_TRANSACTIONS.

TRANSACTION_TYPE_ID

MTL_MATERIAL_TRANSACTIONS

GL_DAIL

Y_CONVERSION_TYPES

MTL_MATERIAL_TRANSACTIONS.

CURRENCY_CODE

MTL_MATERIAL_TRANSACTIONS

MTL_SYSTEM_ITEMS_B

MTL_MATERIAL_TRANSACTIONS.

INVENTORY_ITEM_ID

MTL_MATERIAL_TRANSACTIONS.

ORGANIZATION_ID

MTL_MATERIAL_TRANSACTIONS

CST_COST_GROUPS

MTL_MATERIAL_TRANSACTIONS.

TRANSFER_COST_GROUP_ID

MTL_MATERIAL_TRANSACTIONS

WIP_DISCRETE_JOBS

MTL_MATERIAL_TRANSACTIONS.

TRANSACTION_SOURCE_ID

MTL_MATERIAL_TRANSACTIONS

WIP_REPETITIVE_ITEMS

MTL_MATERIAL_TRANSACTIONS.

TRANSACTION_SOURCE_ID

MTL_MATERIAL_TRANSACTIONS.

REPETITIVE_LINE_ID

MTL_MATERIAL_TRANSACTIONS

MTL_ITEM_LOCA

TIONS

MTL_MATERIAL_TRANSACTIONS.

LOCATOR_ID

MTL_MATERIAL_TRANSACTIONS.

ORGANIZATION_ID

0 0