APPS.CTO_ITEM_PK dependencies on DUAL

Line 221: from dual

217:
218: begin
219:
220: select 'Y' into v_bcol_data_exists
221: from dual
222: where exists ( select line_id from bom_cto_order_lines
223: where line_id = pTopAtoLineId ) ;
224:
225:

Line 1735: select 1 /* BCMO not in synch with Model Item */ into v_model_item_status from dual

1731: v_model_item_status := 0 ;
1732: v_config_item_status := 0 ;
1733:
1734: begin
1735: select 1 /* BCMO not in synch with Model Item */ into v_model_item_status from dual
1736: where exists ( select organization_id from mtl_system_items msi
1737: where not exists
1738: ( select organization_id from bom_cto_model_orgs bcmo
1739: where bcmo.config_item_id = lXConfigId

Line 1752: select 1 /*Config not in synch with Model Item */ into v_config_item_status from dual

1748:
1749:
1750:
1751: begin
1752: select 1 /*Config not in synch with Model Item */ into v_config_item_status from dual
1753: where exists ( select organization_id from mtl_system_items model
1754: where not exists
1755: ( select organization_id from mtl_system_items config
1756: where config.inventory_item_id = lXConfigId