APPS.CTO_AUTO_PROCURE_PK dependencies on BOM_EXPLOSION_TEMP

Line 2553: from bom_explosion_temp

2549:
2550: Cursor buy_configs is
2551: select component_item_id,
2552: line_id
2553: from bom_explosion_temp
2554: where group_id = x_group_id
2555: and configurator_flag = 'Y'
2556: order by plan_level desc; /* Check With Sajani */
2557:

Line 2631: from bom_explosion_temp

2627: lStmtNumber := 50;
2628: Begin
2629: select line_id
2630: into l_line_id
2631: from bom_explosion_temp
2632: where group_id = x_group_id
2633: and assembly_item_id = p_config_item_id
2634: and component_item_id = (select base_item_id
2635: from mtl_system_items

Line 2783: from bom_explosion_temp exp,

2779: exp.primary_uom_code uom_code,
2780: exp.component_item_id comp_item_id,
2781: msi.primary_uom_code prim_uom_code,
2782: nvl(msi.list_price_per_unit,0) list_price_per_unit
2783: from bom_explosion_temp exp,
2784: mtl_system_items msi
2785: where exp.group_id = p_group_id
2786: and exp.assembly_item_id = p_config_item_id
2787: and exp.component_item_id = msi.inventory_item_id

Line 2793: from bom_explosion_temp exp

2789:
2790: Cursor child_configs_cur is
2791: Select exp.component_item_id comp_item_id,
2792: exp.component_quantity comp_qty
2793: from bom_explosion_temp exp
2794: where exp.group_id = p_group_id
2795: and exp.assembly_item_id = p_config_item_id
2796: and exp.configurator_flag = 'Y'
2797: and not exists (select 'X'

Line 3539: from bom_explosion_temp exp

3535: select exp.component_item_id comp_item_id,
3536: exp.component_quantity comp_qty,
3537: exp.primary_uom_code uom_code,
3538: exp.configurator_flag config_flag
3539: from bom_explosion_temp exp
3540: where group_id = p_group_id
3541: and assembly_item_id = p_config_item_id;
3542: l_rollup_price Number;
3543: