bbom表的BILL_SEQUENCE_ID和COMMON_BILL_SEQUENCE_ID有何区别?
bom.BOM_BILL_OF_MATERIALS bbom 物料清单主表有这两个字段:
BILL_SEQUENCE_ID--清单序号
COMMON_BILL_SEQUENCE_ID ----公共序号
bom.BOM_INVENTORY_COMPONENTS bic 物料清单关系表 有字段
BILL_SEQUENCE_ID--清单序号
我在展bom的时候,发现在这两种情况下,展出的bom结果是一样的:
一。bom.BILL_SEQUENCE_ID=bic.BILL_SEQUENCE_ID
SELECT bbom.bill_sequence_id,
bbom.ASSEMBLY_ITEM_ID,
BIC.COMPONENT_ITEM_ID COMPONENT_ITEM_ID,
NVL(BIC.COMPONENT_QUANTITY, 0) COMPONENT_QUANTITY,
BIC.OPERATION_SEQ_NUM OPERATION_SEQ_NUM,
BIC.ITEM_NUM ITEM_NUM,
BIC.COMPONENT_SEQUENCE_ID,
NVL(MSI.ITEM_TYPE, ' ') ITEM_TYPE,
NVL(BIC.SUPPLY_SUBINVENTORY, MSI.WIP_SUPPLY_SUBINVENTORY) SUBINVENTORY_CODE,
MSI.PRIMARY_UOM_CODE PRIMARY_UOM_CODE,
MSI.SEGMENT1 COMPONENT_ITEM_NUMBER,
MSI.DESCRIPTION COMPONENT_DESC,
BIC.EFFECTIVITY_DATE,
BIC.DISABLE_DATE,
MSI.wip_supply_type
FROM apps.BOM_BILL_OF_MATERIALSBBOM,
apps.BOM_INVENTORY_COMPONENTS BIC,
apps.MTL_SYSTEM_ITEMS MSI
WHERE BBOM.ASSEMBLY_ITEM_ID =10825
AND BBOM.ORGANIZATION_ID =4
AND BBOM.ALTERNATE_BOM_DESIGNATOR IS NULL
AND BIC.BILL_SEQUENCE_ID = BBOM.COMMON_BILL_SEQUENCE_ID
AND (BIC.IMPLEMENTATION_DATE IS NOT NULL)
AND MSI.INVENTORY_ITEM_ID = BIC.COMPONENT_ITEM_ID
AND MSI.ORGANIZATION_ID = BBOM.ORGANIZATION_ID
AND MSI.ENABLED_FLAG = 'Y'
ORDER BY BIC.ITEM_NUM, BIC.OPERATION_SEQ_NUM
二。bom.COMMON_BILL_SEQUENCE_ID=bic.BILL_SEQUENCE_ID
SELECT bbom.bill_sequence_id,
bic.operation_seq_num,
msi.inventory_item_id assembly_item,
msi.DESCRIPTION,
msi.segment1 assembly_segment,
msi1.inventory_item_id component_item,
msi1.DESCRIPTION,
msi1.segment1 component_segment,
bic.component_quantity,
bic.ITEM_NUM
FROM BOM.BOM_BILL_OF_MATERIALSbbom,
INV.mtl_system_items msi,
INV.mtl_system_items msi1,
BOM.BOM_INVENTORY_COMPONENTS BIC
where msi.organization_id = 4
and msi.organization_id = bbom.organization_id
and msi.organization_id = msi1.organization_id
and bbom.assembly_item_id = msi.inventory_item_id
and bic.bill_sequence_id = bbom.bill_sequence_id
and bic.implementation_date is not null
and bic.component_item_id = msi1.inventory_item_id
and msi.segment1like '%&p_segment%'
哪位高手帮忙解释一下,bbom表的BILL_SEQUENCE_ID和COMMON_BILL_SEQUENCE_ID有何区别? |