[Home] [Help]
230: ,l_replenish_to_order_flag
231: ,l_config_model_type
232: FROM mtl_system_items mtl_msi
233: WHERE mtl_msi.inventory_item_id = l_inventory_item_id
234: AND mtl_msi.organization_id=OE_SYS_PARAMETERS.Value('MASTER_ORGANIZATION_ID',p_org_id); --Bug 5524710
235:
236: IF l_debug_level > 0 THEN
237: OE_DEBUG_PUB.Add('BOM Item Type:'||l_bom_item_type,3);
238: OE_DEBUG_PUB.Add('Replenish to Order:'||l_replenish_to_order_flag,3);
292: INTO l_config_model_type
293: FROM mtl_system_items mtl_msi, oe_order_lines oe_l
294: WHERE oe_l.line_id = l_top_model_line_id
295: AND oe_l.inventory_item_id = mtl_msi.inventory_item_id
296: AND mtl_msi.organization_id = OE_SYS_PARAMETERS.Value('MASTER_ORGANIZATION_ID',p_org_id); --Bug 5524710
297:
298: IF l_debug_level > 0 THEN
299: OE_DEBUG_PUB.Add('Model Type:'||l_config_model_type,2);
300: END IF;
579: SELECT nvl(comms_nl_trackable_flag, 'N')
580: INTO l_ib_trackable_flag
581: FROM mtl_system_items
582: WHERE inventory_item_id = p_line_rec.inventory_item_id
583: AND organization_id = OE_SYS_PARAMETERS.Value('MASTER_ORGANIZATION_ID');
584:
585: IF l_ib_trackable_flag = 'Y' THEN
586: IF l_debug_level > 0 THEN
587: OE_DEBUG_PUB.Add ('Item is IB trackable',3);
1780:
1781: CZ_NETWORK_API_PUB.Add_To_Config_Tree
1782: ( p_api_version => 1.0
1783: ,p_inventory_item_id => l_inventory_item_id
1784: ,p_organization_id => OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
1785: ,p_config_hdr_id => l_config_header_id
1786: ,p_config_rev_nbr => l_config_rev_nbr
1787: ,p_instance_tbl => l_config_tbl
1788: --,p_tree_copy_mode => CZ_API_PUB.G_NEW_REVISION_COPY_MODE