DBA Data[Home] [Help]

APPS.BOMPXINQ dependencies on DUAL

Line 582: /* Bug 9355186 : Individual updates converted into bulk update

578: End if;
579: close conv; -- added for Bug #2994556
580: END LOOP; -- curCSI.count loop
581:
582: /* Bug 9355186 : Individual updates converted into bulk update
583: if is_cost_organization <> 'Y' then
584: UPDATE BOM_SMALL_EXPL_TEMP
585: SET item_cost = item_cost*t_conversion_rate
586: WHERE group_id = cr.curGI and

Line 867: INTO l_group_id from dual;

863: FROM BOM_PARAMETERS
864: WHERE ORGANIZATION_ID = t_org_code_list(I);
865:
866: SELECT bom_explosion_temp_s.nextval
867: INTO l_group_id from dual;
868:
869: DELETE from bom_small_expl_temp where group_id =l_group_id;
870:
871: --dbms_output.put_line('calling explosion . . . ');