APPS.CSI_ORDER_FULFILL_PUB dependencies on DUAL

Line 1923: FROM sys.dual

1919: IF p_ato_line_id is not null THEN
1920: BEGIN
1921: SELECT 'Y'
1922: INTO l_sub_model_flag
1923: FROM sys.dual
1924: WHERE exists (
1925: SELECT 'X'
1926: FROM bom_cto_order_lines
1927: WHERE ato_line_id = p_ato_line_id

Line 5049: FROM sys.dual

5045: BEGIN
5046: -- Bug 10403570
5047: -- Selecting wip requirement operation for which required qty is > 0
5048: SELECT 'Y' INTO l_phantom
5049: FROM sys.dual
5050: WHERE EXISTS (
5051: SELECT '1' FROM wip_requirement_operations
5052: WHERE wip_entity_id = p_wip_entity_id
5053: AND inventory_item_id = p_option_item_id

Line 5223: FROM sys.dual;

5219: END; --End of code Added for bug 11744133
5220:
5221: SELECT Bom_Explosion_Temp_S.NextVal
5222: INTO l_group_id
5223: FROM sys.dual;
5224: debug('Calling Bompxinq.Exploder_Userexit');
5225: --
5226: Bompxinq.Exploder_Userexit
5227: (

Line 5359: SELECT Bom_Explosion_Temp_S.NextVal INTO l_group_id FROM sys.dual;

5355: debug('Start get_trackable_bom_comp_count');
5356:
5357: l_csi_bom_explosion_level := to_number(fnd_profile.value('CSI_BOM_EXPLOSION_LEVEL'));
5358: --
5359: SELECT Bom_Explosion_Temp_S.NextVal INTO l_group_id FROM sys.dual;
5360:
5361: debug('Calling Bompxinq.Exploder_Userexit');
5362: --
5363: Bompxinq.Exploder_Userexit

Line 7966: FROM sys.dual;

7962: to_char(l_qty_ratio)||':'||
7963: p_order_line_rec.order_quantity_uom ||':'||
7964: p_order_line_rec.ordered_quantity --added for bug5096435
7965: INTO l_model_hierarchy
7966: FROM sys.dual;
7967:
7968: debug(' model hierarchy string: '||l_model_hierarchy);
7969:
7970: csi_t_utilities_pvt.cascade_child(

Line 10082: FROM sys.dual;

10078: to_char(l_qty_ratio)||':'||
10079: l_order_line_rec.order_quantity_uom ||':'||
10080: l_order_line_rec.ordered_quantity --added for bug5096435
10081: INTO l_model_hierarchy
10082: FROM sys.dual;
10083:
10084: csi_t_utilities_pvt.cascade_child(
10085: p_data_string => l_model_hierarchy,
10086: x_return_status => l_return_status );