APPS.CTO_AUTO_PROCURE_PK dependencies on BOM_EXPLOSION_TEMP

Line 2168: from bom_explosion_temp

2164:
2165: Cursor buy_configs is
2166: select component_item_id,
2167: line_id
2168: from bom_explosion_temp
2169: where group_id = x_group_id
2170: and configurator_flag = 'Y'
2171: order by plan_level desc; /* Check With Sajani */
2172:

Line 2246: from bom_explosion_temp

2242: lStmtNumber := 50;
2243: Begin
2244: select line_id
2245: into l_line_id
2246: from bom_explosion_temp
2247: where group_id = x_group_id
2248: and assembly_item_id = p_config_item_id
2249: and component_item_id = (select base_item_id
2250: from mtl_system_items

Line 2398: from bom_explosion_temp exp,

2394: exp.primary_uom_code uom_code,
2395: exp.component_item_id comp_item_id,
2396: msi.primary_uom_code prim_uom_code,
2397: nvl(msi.list_price_per_unit,0) list_price_per_unit
2398: from bom_explosion_temp exp,
2399: mtl_system_items msi
2400: where exp.group_id = p_group_id
2401: and exp.assembly_item_id = p_config_item_id
2402: and exp.component_item_id = msi.inventory_item_id

Line 2408: from bom_explosion_temp exp

2404:
2405: Cursor child_configs_cur is
2406: Select exp.component_item_id comp_item_id,
2407: exp.component_quantity comp_qty
2408: from bom_explosion_temp exp
2409: where exp.group_id = p_group_id
2410: and exp.assembly_item_id = p_config_item_id
2411: and exp.configurator_flag = 'Y'
2412: and not exists (select 'X'

Line 3154: from bom_explosion_temp exp

3150: select exp.component_item_id comp_item_id,
3151: exp.component_quantity comp_qty,
3152: exp.primary_uom_code uom_code,
3153: exp.configurator_flag config_flag
3154: from bom_explosion_temp exp
3155: where group_id = p_group_id
3156: and assembly_item_id = p_config_item_id;
3157: l_rollup_price Number;
3158: