全文预览已结束
下载本文档
版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
在在 OM 二次开发常用到的表 视图及关系二次开发常用到的表 视图及关系 表 MTL ONHAND LOCATOR V MOLV WIP DISCRETE JOBS WDJ OE ORDER HEADERS ALL OOHA OE ORDER LINES ALL OOLA MTL CUSTOMER ITEM XREFS V MCIX 关系 MOLV INVENTORY ITEM ID MCIX INVENTORY ITEM ID WDJ PRIMARY ITEM ID MCIX INVENTORY ITEM ID OOHA HEADER ID OOLA HEADER ID AND OOLA INVENTORY ITEM ID MCIX INVENTORY ITEM ID 表 WIP REQUIREMENT OPERATIONS WRO WIP ENTITIES WE MTL SYSTEM ITEMS B MSIB WIP DISCRETE JOBS WDJ 关系 WE WIP ENTITY ID WRO WIP ENTITY ID WRO WIP ENTITY ID WDJ WIP ENTITY ID MSIB INVENTORY ITEM ID WRO INVENTORY ITEM ID 表 OE ORDER HEADERS ALL OOHA OE ORDER LINES ALL OOLA MTL SYSTEM ITEMS B MSIB MTL RESERVATIONS MR 表 MTL SALES ORDERS KFV MSOK MTL RESERVATIONS MR OE ORDER HEADERS ALL OOHA1 OE ORDER LINES ALL OOLA1 关系 OOLA1 HEADER ID OOHA1 HEADER ID OOLA1 INVENTORY ITEM ID MR INVENTORY ITEM ID MSOK SALES ORDER ID MR DEMAND SOURCE HEADER ID TO NUMBER MSOK SEGMENT1 OOHA1 ORDER NUMBER T 关系 OOHA HEADER ID OOLA HEADER ID MSIB INVENTORY ITEM ID OOLA INVENTORY ITEM ID MR DEMAND SOURCE LINE ID OOLA LINE ID T HEADER ID OOLA HEADER ID T LINE ID OOLA LINE ID 表 WIP DISCRETE JOBS WDJ WIP ENTITIES WE MTL SYSTEM ITEMS B MSIB 关系 WE WIP ENTITY ID WDJ WIP ENTITY ID MSIB INVENTORY ITEM ID WDJ PRIMARY ITEM ID 例子 CREATE OR REPLACE VIEW XXOM OF MAIN V AS select mcix customer id MCIX CUSTOMER NAME mcix customer item id MCIX CUSTOMER ITEM NUMBER mcix INVENTORY ITEM ID MCIX CONCATENATED SEGMENTS MCIX ATTRIBUTE15 NVL SELECT MOLV TOTAL QOH FROM MTL ONHAND LOCATOR V MOLV WHERE MOLV INVENTORY ITEM ID MCIX INVENTORY ITEM ID AND MOLV SUBINVENTORY CODE MODULE AND MOLV ORGANIZATION ID FND PROFILE VALUE MFG ORGANIZATION ID AND MOLV LOCATOR ID 1 0 LOCATOR A NVL SELECT MOLV TOTAL QOH FROM MTL ONHAND LOCATOR V MOLV WHERE MOLV INVENTORY ITEM ID MCIX INVENTORY ITEM ID AND MOLV SUBINVENTORY CODE MODULE AND MOLV ORGANIZATION ID FND PROFILE VALUE MFG ORGANIZATION ID AND MOLV LOCATOR ID 2 0 LOCATOR B NVL SELECT MOLV TOTAL QOH FROM MTL ONHAND LOCATOR V MOLV WHERE MOLV INVENTORY ITEM ID MCIX INVENTORY ITEM ID AND MOLV SUBINVENTORY CODE MODULE AND MOLV ORGANIZATION ID FND PROFILE VALUE MFG ORGANIZATION ID AND MOLV LOCATOR ID 3 0 LOCATOR C NVL SELECT SUM MOLV TOTAL QOH FROM MTL ONHAND LOCATOR V MOLV WHERE MOLV INVENTORY ITEM ID MCIX INVENTORY ITEM ID AND MOLV SUBINVENTORY CODE MODULE AND MOLV ORGANIZATION ID FND PROFILE VALUE MFG ORGANIZATION ID 0 INVENTORY NUM NVL SELECT SUM WDJ START QUANTITY WDJ QUANTITY COMPLETED FROM WIP DISCRETE JOBS WDJ WHERE WDJ PRIMARY ITEM ID MCIX INVENTORY ITEM ID AND WDJ STATUS TYPE 7 CANCELLED WIP AND WDJ ORGANIZATION ID FND PROFILE VALUE MFG ORGANIZATION ID 0 ORDER NUM NVL SELECT SUM oola ORDERED QUANTITY NVL oola SHIPPED QUANTITY 0 from oe order headers all ooha oe order lines all oola where ooha header id oola header id AND ooha booked flag Y and oola cancelled flag N AND OOLA INVENTORY ITEM ID MCIX INVENTORY ITEM ID AND OOHA SHIP FROM ORG ID FND PROFILE VALUE MFG ORGANIZATION ID 0 REQUIREMENT NUM FROM MTL CUSTOMER ITEM XREFS V MCIX WHERE MCIX MASTER ORGANIZATION ID SELECT MPV ORGANIZATION ID FROM MTL PARAMETERS VIEW MPV WHERE MPV ORGANIZATION ID FND PROFILE VALUE MFG ORGANIZATION ID CREATE OR REPLACE VIEW XXOM OF DETAIL V AS SELECT WRO ORGANIZATION ID WRO INVENTORY ITEM ID MSIB SEGMENT1 CONCATENATED SEGMENTS WRO DATE REQUIRED SD DATE WIP Components SD TYPE WE WIP ENTITY NAME WS NUMBER 1 NVL WRO REQUIRED QUANTITY 0 NVL WRO QUANTITY ISSUED 0 QUANTITY FROM WIP REQUIREMENT OPERATIONS WRO WIP ENTITIES WE MTL SYSTEM ITEMS B MSIB WIP DISCRETE JOBS WDJ WHERE WE WIP ENTITY ID WRO WIP ENTITY ID AND WRO WIP ENTITY ID WDJ WIP ENTITY ID AND WDJ STATUS TYPE 7 CANCELLED WIP AND WRO ORGANIZATION ID FND PROFILE VALUE MFG ORGANIZATION ID AND NVL WRO REQUIRED QUANTITY 0 NVL WRO QUANTITY ISSUED 0 0 AND MSIB INVENTORY ITEM ID WRO INVENTORY ITEM ID AND MSIB ORGANIZATION ID FND PROFILE VALUE MFG ORGANIZATION ID UNION ALL SELECT OOHA SHIP FROM ORG ID OOLA INVENTORY ITEM ID MSIB SEGMENT1 CONCATENATED SEGMENTS NVL T REQUIREMENT DATE OOLA SCHEDULE SHIP DATE SD DATE NVL MR REQUIREMENT DATE OOLA SCHEDULE SHIP DATE SD DATE Sales Order SD TYPE TO CHAR OOHA ORDER NUMBER WS NUMBER 1 OOLA ORDERED QUANTITY NVL OOLA SHIPPED QUANTITY 0 QUANTITY FROM oe order headers all ooha oe order lines all oola MTL SYSTEM ITEMS B MSIB MTL RESERVATIONS MR SELECT MR REQUIREMENT DATE OOLA1 HEADER ID OOLA1 LINE ID FROM MTL SALES ORDERS KFV MSOK MTL RESERVATIONS MR OE ORDER HEADERS ALL OOHA1 OE ORDER LINES ALL OOLA1 WHERE OOLA1 HEADER ID OOHA1 HEADER ID AND OOLA1 INVENTORY ITEM ID MR INVENTORY ITEM ID AND MSOK SALES ORDER ID MR DEMAND SOURCE HEADER ID AND TO NUMBER MSOK SEGMENT1 OOHA1 ORDER NUMBER T WHERE ooha header id oola header id AND ooha booked flag Y and oola cancelled flag N AND OOHA SHIP FROM ORG ID FND PROFILE VALUE MFG ORGANIZATION ID AND OOLA ORDERED QUANTITY NVL OOLA SHIPPED QUANTITY 0 0 AND MSIB INVENTORY ITEM ID OOLA INVENTORY ITEM ID AND MSIB ORGANIZATION ID FND PROFILE VALUE MFG ORGANIZATION ID and MR DEMAND SOURCE LINE ID OOLA LINE ID AND T HEADER ID OOLA HEADER ID AND T LINE ID OOLA LINE ID UNION ALL SELECT wdj organization id WDJ PRIMARY ITEM ID INVENTORY ITEM ID MSIB SEGMENT1 CONCATENATED SEGMENTS WDJ Scheduled Completion Date SD DATE Discrete Jobs SD TYPE WE wip entity name SD NUMBER NVL wdj start quantity 0 NVL wdj quantity completed 0 QUANTITY FROM wip discrete jobs WDJ wip entities WE MTL SYSTEM ITEMS B MSIB WHERE WE WIP ENTITY ID
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 2024-2030年中国光学镜头行业市场发展分析及发展趋势与投资前景研究报告
- 2024-2030年中国儿科用药行业发展策略分析及投资价值评估报告
- 2024-2030年中国健身器材行业市场运行分析及发展趋势与投资研究报告
- 2024-2030年中国倍他环糊精项目可行性研究报告
- 2024-2030年中国供暖设备行业发展趋势与前景展望战略分析报告
- 2024-2030年中国传统伤口护理行业市场发展趋势与前景展望战略分析报告
- 2024-2030年中国代餐营养补充剂市场销售现状与营销前景预测报告
- 2024-2030年中国人造革旅游鞋行业市场运行分析及发展趋势与投资研究报告
- 2024-2030年中国人用益生菌成分行业市场发展趋势与前景展望战略分析报告
- 2024-2030年中国产业用纺织品行业营销态势与经营效益预测报告
- 2024福建福州首邑文化旅游投资限公司第三批招聘12人高频考题难、易错点模拟试题(共500题)附带答案详解
- 【企业杜邦分析国内外文献综述6000字】
- 华为鸿蒙深度研究
- 费用报销单表格表单
- 安全经验分享-受限空间作业安全
- 酒店创新菜品奖励制度
- 反物质:世界的终极镜像
- 西北有高楼课件.ppt
- 《动漫店创业计划书》PPT课件
- 血液保存课件
- EN1822-4空气过滤器中文.doc
评论
0/150
提交评论