APPS.ENGPKIMP dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 2926: WHERE EXISTS (SELECT 1 FROM bom_substitute_components

2922: l_BOMEvents_Bill_Event_Name VARCHAR2(240);
2923: CURSOR c_Comp_Child_Entity_Modified(cp_component_sequence_id IN NUMBER)
2924: IS
2925: SELECT 1 FROM dual
2926: WHERE EXISTS (SELECT 1 FROM bom_substitute_components
2927: WHERE component_sequence_id = cp_component_sequence_id
2928: AND acd_type IS NOT NULL)
2929: OR EXISTS (SELECT 1 FROM bom_substitute_components
2930: WHERE component_sequence_id = cp_component_sequence_id

Line 2929: OR EXISTS (SELECT 1 FROM bom_substitute_components

2925: SELECT 1 FROM dual
2926: WHERE EXISTS (SELECT 1 FROM bom_substitute_components
2927: WHERE component_sequence_id = cp_component_sequence_id
2928: AND acd_type IS NOT NULL)
2929: OR EXISTS (SELECT 1 FROM bom_substitute_components
2930: WHERE component_sequence_id = cp_component_sequence_id
2931: AND acd_type IS NOT NULL);
2932: -- End Changes for bug 4584490
2933:

Line 2944: FROM bom_substitute_components a,

2940: b.old_component_sequence_id,
2941: a.acd_type,
2942: a.substitute_component_id,
2943: f.concatenated_segments item_number
2944: FROM bom_substitute_components a,
2945: bom_inventory_components b,
2946: mtl_system_items_b_kfv f
2947: WHERE a.component_sequence_id = b.component_sequence_id
2948: and b.revised_item_sequence_id = revised_item

Line 2956: from bom_substitute_components a, bom_inventory_components b

2952: and nvl(a.acd_type,acd_add) = acd_add;
2953:
2954: Cursor check_existing_substitutes(X_old_comp_seq_id number,X_sub_comp_id number,X_change_notice varchar2) is
2955: select 'x'
2956: from bom_substitute_components a, bom_inventory_components b
2957: where a.component_sequence_id = b.component_sequence_id
2958: and b.component_sequence_id = X_old_comp_seq_id
2959: and nvl(a.acd_type, acd_add) = acd_add
2960: and b.change_notice = X_change_notice

Line 3080: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(

3076: select count(*) into l_no_bom_dis_sub_comps from dual where exists(
3077: select 1 from mtl_system_items_b WHERE inventory_item_id IN
3078: (
3079: --Get all the sub components for all the components for this item
3080: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3081: -- Get all the components for this item
3082: select COMPONENT_SEQUENCE_ID from bom_components_b WHERE bill_sequence_id IN
3083: (
3084: select bill_sequence_id from bom_bill_of_materials where

Line 3102: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(

3098: select count(*) into l_no_bom_dis_sub_comps from dual where exists(
3099: select 1 from mtl_system_items_b WHERE inventory_item_id IN
3100: (
3101: --Get all the sub components for all the components for this item
3102: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3103: -- Get all the components for this item
3104: select COMPONENT_SEQUENCE_ID from bom_components_b WHERE bill_sequence_id IN
3105: (
3106: select bill_sequence_id from bom_bill_of_materials where

Line 3256: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(

3252: SELECT Count(*) INTO no_bom_disabled_sub_comps FROM dual WHERE EXISTS(
3253: select 1 from mtl_system_items_b WHERE inventory_item_id IN
3254: (
3255: --Get all the sub components for all the components for this item
3256: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3257: -- Get all the components for this item
3258: select COMPONENT_SEQUENCE_ID from bom_components_b WHERE bill_sequence_id IN
3259: (
3260: select bill_sequence_id from bom_bill_of_materials where

Line 6757: BOM_SUBSTITUTE_COMPONENTS bsc

6753: rec_exist:=0;
6754: BEGIN
6755: SELECT bsc.acd_type into rec_exist
6756: FROM Bom_Inventory_Components bic,
6757: BOM_SUBSTITUTE_COMPONENTS bsc
6758: WHERE bic.Old_Component_Sequence_Id = sub_component.old_component_sequence_id
6759: AND bic.Change_Notice = item.change_notice
6760: AND bic.Implementation_Date IS NULL
6761: AND bsc.component_sequence_id = bic.component_sequence_id

Line 6801: Insert into bom_substitute_components(

6797: -- Bug 5854437 End
6798:
6799:
6800: -- Copy substitute components
6801: Insert into bom_substitute_components(
6802: substitute_component_id,
6803: last_update_date,
6804: last_updated_by,
6805: creation_date,

Line 6863: from bom_substitute_components

6859: attribute12,
6860: attribute13,
6861: attribute14,
6862: attribute15
6863: from bom_substitute_components
6864: where component_sequence_id =
6865: component.old_component_sequence_id
6866: and nvl(acd_type, acd_add) = acd_add
6867: and substitute_component_id not in (

Line 6869: from bom_substitute_components

6865: component.old_component_sequence_id
6866: and nvl(acd_type, acd_add) = acd_add
6867: and substitute_component_id not in (
6868: select substitute_component_id
6869: from bom_substitute_components
6870: where component_sequence_id =
6871: component.component_sequence_id);
6872: -- Copy reference designators
6873: Insert into bom_reference_designators (

Line 8620: -- Delete the related bom_substitute_components

8616: --fixed for bug 1870813
8617: revised_item_sequence_id = p_revised_item_sequence_id
8618: ) ;
8619: */
8620: -- Delete the related bom_substitute_components
8621: /* DELETE FROM bom_substitute_components
8622: WHERE component_sequence_id IN
8623: ( SELECT component_sequence_id
8624: FROM bom_inventory_components

Line 8621: /* DELETE FROM bom_substitute_components

8617: revised_item_sequence_id = p_revised_item_sequence_id
8618: ) ;
8619: */
8620: -- Delete the related bom_substitute_components
8621: /* DELETE FROM bom_substitute_components
8622: WHERE component_sequence_id IN
8623: ( SELECT component_sequence_id
8624: FROM bom_inventory_components
8625: -- fixed for bug 1870813