Oracle MASTER BOM展开
来源:互联网 发布:51单片机组合键复位 编辑:程序博客网 时间:2024/06/05 16:36
Oracle MASTER BOM展开
select rownum seq_num
,top_item
,lpad(to_char(level),decode(level,1,1,level+1),'.') bom_level
,bbm.ASSEMBLY_ITEM_ID
,msi.segment1 assembly_item
,msi.description assembly_description
,bbm.COMMON_ASSEMBLY_ITEM_ID
,bic.item_NUM
,bbm.COMMON_BILL_SEQUENCE_ID
,bbm.BILL_SEQUENCE_ID
,msic.segment1 component_item
,msic.description c_item_description
,bic.COMPONENT_ITEM_ID
,bic.COMPONENT_QUANTITY
,msic.primary_unit_of_measure
,bic.COMPONENT_YIELD_FACTOR
,bic.EFFECTIVITY_DATE
,bic.ATTRIBUTE1
,bic.ATTRIBUTE2
,bic.CHANGE_NOTICE
,ood.ORGANIZATION_CODE
,ood.ORGANIZATION_NAME
,ood.ORGANIZATION_ID
from bom_bill_of_materials bbm
,bom_inventory_components bic
,mtl_system_items_b msi
,mtl_system_items_b msic
,org_organization_definitions ood
where
bbm.ASSEMBLY_ITEM_ID = msi.inventory_item_id
and bbm.ORGANIZATION_ID = msi.organization_id
and bic.COMPONENT_ITEM_ID =msic.inventory_item_id
and bic.PK2_VALUE =msic.organization_id
and bbm.BILL_SEQUENCE_ID=bic.BILL_SEQUENCE_ID
and (bic.DISABLE_DATE is null or bic.DISABLE_DATE >= sysdate)
and bic.EFFECTIVITY_DATE <= sysdate
and ood.ORGANIZATION_ID=msi.organization_id
connect by bbm.ASSEMBLY_ITEM_ID = prior bic.COMPONENT_ITEM_ID
start with msi.segment1=:P_ITEM
and ood.ORGANIZATION_CODE =:P_ORG
本文出处:http://www.itpub.net/thread-926584-1-1.html
- Oracle MASTER BOM展开
- 展开BOM
- 展开BOM
- 展开BOM
- 展开BOM
- 展开BOM
- 展开BOM
- 展开BOM
- 展开BOM
- 展开BOM
- 展开BOM
- 展开BOM
- 展开BOM
- 展开BOM
- 展开BOM
- 展开BOM
- 展开BOM
- BOM展开
- 成功的经典要素:杠杆借力
- PHP如何防止注入
- TDateTimePicker同时修改日期时间
- 第五代计算机为什么难产?
- C C++语言—入门必做的题
- Oracle MASTER BOM展开
- 设计一套SAP监控系统
- 唉,我的股沟文档
- 搭建OPhone开发平台——安装Eclipse 插件 (WDT)
- silverlight:Child Windows
- 拼接显示
- 传智播客--------java基础
- silverlight:Element Data Binding
- 使用Oracle里的包Bompexpl将BOM展开