DBA Data[Home] [Help]

APPS.CSD_ESTIMATES_FROM_BOM_PVT dependencies on DUAL

Line 80: SELECT bom_explosion_temp_s.nextval INTO l_group_id from dual;

76: SELECT MAXIMUM_BOM_LEVEL INTO l_max_level
77: FROM BOM_PARAMETERS
78: WHERE ORGANIZATION_ID = l_org_id;
79: -- get the group id used for explosion.
80: SELECT bom_explosion_temp_s.nextval INTO l_group_id from dual;
81: -- clear the bom temporary table
82: delete from bom_small_expl_temp;
83: -- calling exploder_userexit API.
84: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then