[Home] [Help]
676: SELECT concatenated_segments
677: INTO l_concatenated_segments
678: FROM MTL_SYSTEM_ITEMS_KFV
679: WHERE inventory_item_id = config_rec.inventory_item_id
680: AND organization_id = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
681: EXCEPTION
682: WHEN NO_DATA_FOUND THEN
683: RAISE FND_API.G_EXC_ERROR;
684: END;
877: SELECT concatenated_segments
878: INTO l_concatenated_segments
879: FROM MTL_SYSTEM_ITEMS_KFV
880: WHERE inventory_item_id = config_rec.inventory_item_id
881: AND organization_id = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
882: EXCEPTION
883: WHEN NO_DATA_FOUND THEN
884: RAISE FND_API.G_EXC_ERROR;
885: END;
2414: INTO l_indivisible_flag
2415: FROM mtl_system_items
2416: WHERE inventory_item_id = l_child_inv_item_id
2417: AND organization_id =
2418: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2419:
2420: IF nvl(l_indivisible_flag, 'N') = 'N' THEN
2421: IF l_debug_level > 0 THEN
2422: OE_DEBUG_PUB.ADD('this Option can have decimal ratio', 1);
3237: FROM mtl_system_items
3238: WHERE inventory_item_id =
3239: OEATO.inventory_item_id
3240: AND organization_id =
3241: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')
3242: AND replenish_to_order_flag = 'Y'
3243: )
3244: AND OEATO.COMPONENT_CODE =
3245: ( SELECT MIN( OEMIN.COMPONENT_CODE )
3254: FROM mtl_system_items
3255: WHERE inventory_item_id =
3256: OEMIN.inventory_item_id
3257: AND organization_id =
3258: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')
3259: AND replenish_to_order_flag = 'Y'
3260: )
3261: )
3262: AND ((SUBSTR(OEOPT.component_code,
3921: IS
3922: /* variables for call to explode */
3923: l_rev_date DATE;
3924: l_validation_org NUMBER :=
3925: OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
3926: l_stdcompflag VARCHAR2(10)
3927: := OE_Config_Util.OE_BMX_OPTION_COMPS;
3928: l_top_item_id NUMBER;
3929: l_op_qty NUMBER;