Item revision 信息查询

来源：互联网发布：网络舆情监控的目的编辑：程序博客网时间：2024/06/11 03:11

Inventory>Items>Organization Items
Query Item
Click on Tools>Revisions
Check to see if Revisions have been defined for this Item/Organization combination

Checking at the table level:
1.Checking to see if any Item Revisions exist
select inventory_item_id,organization_id,revision
from mtl_item_revisions
where inventory_item_id = &item_id
and organization_id = &org_id;

2.Checking for Item Revision turned on
select inventory_item_id,segment1,
revision_qty_control_code,organization_id
from mtl_system_items_b
where inventory_item_id = &item_id
and organization_id = &org_id;

Value returned = 1 Not under revision control

Value returned = 2 Under revision control

与Item Revision有交互的一般来说有 MRP, INV 和ASCP三个产品，所有都是通过配置文件来控制是否最新的物料Item会默认到物料信息中，或者不populate任何 Item Revision;

下面是Item Revision的配置文件分别是：

MRP:Purchasing By Revision
INV:Purchasing By Revision

分配Sourcing Rule 的FORM 界面没有Item Revision，只有Item。

Item和Item Revision的组合是独特的，一般来说在一些来源文件中必须是规定好的，如BPA，Quotation等

0 0