APPS.CTO_ITEM_PK dependencies on DUAL

Line 236: from dual

232:
233: begin
234:
235: select 'Y' into v_bcol_data_exists
236: from dual
237: where exists ( select line_id from bom_cto_order_lines
238: where line_id = pTopAtoLineId ) ;
239:
240:

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

1791: v_model_item_status := 0 ;
1792: v_config_item_status := 0 ;
1793:
1794: begin
1795: select 1 /* BCMO not in synch with Model Item */ into v_model_item_status from dual
1796: where exists ( select organization_id from mtl_system_items msi
1797: where not exists
1798: ( select organization_id from bom_cto_model_orgs bcmo
1799: where bcmo.config_item_id = lXConfigId

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

1808:
1809:
1810:
1811: begin
1812: select 1 /*Config not in synch with Model Item */ into v_config_item_status from dual
1813: where exists ( select organization_id from mtl_system_items model
1814: where not exists
1815: ( select organization_id from mtl_system_items config
1816: where config.inventory_item_id = lXConfigId