[Home] [Help]
664: SELECT concatenated_segments
665: INTO l_concatenated_segments
666: FROM MTL_SYSTEM_ITEMS_KFV
667: WHERE inventory_item_id = config_rec.inventory_item_id
668: AND organization_id = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
669: EXCEPTION
670: WHEN NO_DATA_FOUND THEN
671: RAISE FND_API.G_EXC_ERROR;
672: END;
865: SELECT concatenated_segments
866: INTO l_concatenated_segments
867: FROM MTL_SYSTEM_ITEMS_KFV
868: WHERE inventory_item_id = config_rec.inventory_item_id
869: AND organization_id = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
870: EXCEPTION
871: WHEN NO_DATA_FOUND THEN
872: RAISE FND_API.G_EXC_ERROR;
873: END;
2312: INTO l_indivisible_flag
2313: FROM mtl_system_items
2314: WHERE inventory_item_id = l_child_inv_item_id
2315: AND organization_id =
2316: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2317:
2318: IF nvl(l_indivisible_flag, 'N') = 'N' THEN
2319: IF l_debug_level > 0 THEN
2320: OE_DEBUG_PUB.ADD('this Option can have decimal ratio', 1);
2810: FROM mtl_system_items
2811: WHERE inventory_item_id =
2812: OEATO.inventory_item_id
2813: AND organization_id =
2814: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')
2815: AND replenish_to_order_flag = 'Y'
2816: )
2817: AND OEATO.COMPONENT_CODE =
2818: ( SELECT MIN( OEMIN.COMPONENT_CODE )
2827: FROM mtl_system_items
2828: WHERE inventory_item_id =
2829: OEMIN.inventory_item_id
2830: AND organization_id =
2831: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')
2832: AND replenish_to_order_flag = 'Y'
2833: )
2834: )
2835: AND ((SUBSTR(OEOPT.component_code,
3489: IS
3490: /* variables for call to explode */
3491: l_rev_date DATE;
3492: l_validation_org NUMBER :=
3493: OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
3494: l_stdcompflag VARCHAR2(10)
3495: := OE_Config_Util.OE_BMX_OPTION_COMPS;
3496: l_top_item_id NUMBER;
3497: l_op_qty NUMBER;