资源描述：
《om常用表_视图及关系》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、在OM二次开发常用到的表、视图及关系表：MTL_ONHAND_LOCATOR_VMOLVWIP_DISCRETE_JOBSWDJOE_ORDER_HEADERS_ALLOOHA,OE_ORDER_LINES_ALLOOLAMTL_CUSTOMER_ITEM_XREFS_VMCIX关系：MOLV.INVENTORY_ITEM_ID=MCIX.INVENTORY_ITEM_IDWDJ.PRIMARY_ITEM_ID=MCIX.INVENTORY_ITEM_IDOOHA.HEADER_ID=OOLA.HEADER_ID ANDOOLA.INVENTORY_ITEM_ID=MCIX.I
2、NVENTORY_ITEM_ID表：WIP_REQUIREMENT_OPERATIONSWRO,WIP_ENTITIESWE,MTL_SYSTEM_ITEMS_BMSIB,WIP_DISCRETE_JOBSWDJ关系：WE.WIP_ENTITY_ID=WRO.WIP_ENTITY_IDWRO.WIP_ENTITY_ID=WDJ.WIP_ENTITY_IDMSIB.INVENTORY_ITEM_ID=WRO.INVENTORY_ITEM_ID表：OE_ORDER_HEADERS_ALLOOHA,OE_ORDER_LINES_ALLOOLA,MTL_SYSTEM_ITEMS_BMS
3、IB,MTL_RESERVATIONSMR表：MTL_SALES_ORDERS_KFVMSOK,MTL_RESERVATIONSMR,OE_ORDER_HEADERS_ALLOOHA1,OE_ORDER_LINES_ALLOOLA1关系：OOLA1.HEADER_ID=OOHA1.HEADER_IDOOLA1.INVENTORY_ITEM_ID=MR.INVENTORY_ITEM_IDMSOK.SALES_ORDER_ID=MR.DEMAND_SOURCE_HEADER_IDTO_NUMBER(MSOK.SEGMENT1)=OOHA1.ORDER_NUMBER)T关系：OOHA
4、.HEADER_ID=OOLA.HEADER_IDMSIB.INVENTORY_ITEM_ID=OOLA.INVENTORY_ITEM_IDMR.DEMAND_SOURCE_LINE_ID=OOLA.LINE_IDT.HEADER_ID=OOLA.HEADER_IDT.LINE_ID=OOLA.LINE_ID表：WIP_DISCRETE_JOBSWDJ,WIP_ENTITIESWE,MTL_SYSTEM_ITEMS_BMSIB关系：WE.WIP_ENTITY_ID=WDJ.WIP_ENTITY_IDMSIB.INVENTORY_ITEM_ID=WDJ.PRIMARY_ITEM_
5、ID例子：CREATEORREPLACEVIEWXXOM_OF_MAIN_VASselectmcix.customer_id,MCIX.CUSTOMER_NAME,mcix.customer_item_id,MCIX.CUSTOMER_ITEM_NUMBER,mcix.INVENTORY_ITEM_ID,MCIX.CONCATENATED_SEGMENTS,MCIX.ATTRIBUTE15,NVL((SELECTMOLV.TOTAL_QOHFROMMTL_ONHAND_LOCATOR_VMOLVWHEREMOLV.INVENTORY_ITEM_ID=MCIX.INVENTORY
6、_ITEM_IDANDMOLV.SUBINVENTORY_CODE='MODULE'ANDMOLV.ORGANIZATION_ID=FND_PROFILE.VALUE('MFG_ORGANIZATION_ID')ANDMOLV.LOCATOR_ID=1),0)LOCATOR_A,NVL((SELECTMOLV.TOTAL_QOHFROMMTL_ONHAND_LOCATOR_VMOLVWHEREMOLV.INVENTORY_ITEM_ID=MCIX.INVENTORY_ITEM_IDANDMOLV.SUBINVENTORY_CODE='MODULE'ANDMOLV.ORGANIZ
7、ATION_ID=FND_PROFILE.VALUE('MFG_ORGANIZATION_ID')ANDMOLV.LOCATOR_ID=2),0)LOCATOR_B,NVL((SELECTMOLV.TOTAL_QOHFROMMTL_ONHAND_LOCATOR_VMOLVWHEREMOLV.INVENTORY_ITEM_ID=MCIX.INVENTORY_ITEM_IDANDMOLV.SUBINVENTORY_CODE='MODULE'ANDMOLV.ORGANIZATION_ID=FND_
