Ürün Ağacı Oluşturma ( Interface )

CREATE TABLE magbaba_aktarogul (component VARCHAR2(30),assembly VARCHAR2(30),organization_id NUMBER,operation_seq_num NUMBER,effectivity_date DATE,component_quantity NUMBER,wip_supply_type NUMBER,item_num NUMBER)

INSERT INTO bom_bill_of_mtls_interface
 
(organization_id,
assembly_item_id,
Assembly_type,
Transaction_type,
Process_flag)
SELECT mag.organization_id,inventory_item_id,1,'Create',1
FROM magbaba_govde_aktarbaba mag, mtl_system_items_b msi
WHERE segment1 = assembly
AND organization_id = p_organization_id
INSERT INTO bom_inventory_comps_interface bom
(bom.component_item_id,
bom.assembly_item_id,
bom.organization_id,
bom.operation_seq_num,
bom.effectivity_date,
bom.Transaction_type,
bom.Process_flag,
bom.Component_quantity,
bom.wip_supply_type)
SELECT MSI.INVENTORY_ITEM_ID,
MSI2.INVENTORY_ITEM_ID,
ogl.organization_id,
ogl.OPERATION_SEQ_NUM,
SYSDATE,
'Create',
1,
ogl.Component_quantity,
ogl.wip_supply_type
FROM MAGBABA_AKTAROGUL OGL,
MTL_SYSTEM_ITEMS_B MSI,
MTL_SYSTEM_ITEMS_B MSI2
WHERE OGL.COMPONENT = MSI.SEGMENT1
AND OGL.ASSEMBLY = MSI2.SEGMENT1
AND MSI.ORGANIZATION_ID = p_organization_id
AND MSI2.ORGANIZATION_ID = MSI.ORGANIZATION_ID