APPS.ENGPKIMP dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 3057: WHERE EXISTS (SELECT 1 FROM bom_substitute_components

3053: l_BOMEvents_Bill_Event_Name VARCHAR2(240);
3054: CURSOR c_Comp_Child_Entity_Modified(cp_component_sequence_id IN NUMBER)
3055: IS
3056: SELECT 1 FROM dual
3057: WHERE EXISTS (SELECT 1 FROM bom_substitute_components
3058: WHERE component_sequence_id = cp_component_sequence_id
3059: AND acd_type IS NOT NULL)
3060: OR EXISTS (SELECT 1 FROM bom_substitute_components
3061: WHERE component_sequence_id = cp_component_sequence_id

Line 3060: OR EXISTS (SELECT 1 FROM bom_substitute_components

3056: SELECT 1 FROM dual
3057: WHERE EXISTS (SELECT 1 FROM bom_substitute_components
3058: WHERE component_sequence_id = cp_component_sequence_id
3059: AND acd_type IS NOT NULL)
3060: OR EXISTS (SELECT 1 FROM bom_substitute_components
3061: WHERE component_sequence_id = cp_component_sequence_id
3062: AND acd_type IS NOT NULL);
3063: -- End Changes for bug 4584490
3064:

Line 3075: FROM bom_substitute_components a,

3071: b.old_component_sequence_id,
3072: a.acd_type,
3073: a.substitute_component_id,
3074: f.concatenated_segments item_number
3075: FROM bom_substitute_components a,
3076: bom_inventory_components b,
3077: mtl_system_items_b_kfv f
3078: WHERE a.component_sequence_id = b.component_sequence_id
3079: and b.revised_item_sequence_id = revised_item

Line 3087: from bom_substitute_components a, bom_inventory_components b

3083: and nvl(a.acd_type,acd_add) = acd_add;
3084:
3085: Cursor check_existing_substitutes(X_old_comp_seq_id number,X_sub_comp_id number,X_change_notice varchar2) is
3086: select 'x'
3087: from bom_substitute_components a, bom_inventory_components b
3088: where a.component_sequence_id = b.component_sequence_id
3089: and b.component_sequence_id = X_old_comp_seq_id
3090: and nvl(a.acd_type, acd_add) = acd_add
3091: and b.change_notice = X_change_notice

Line 3270: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(

3266: select count(*) into l_no_bom_dis_sub_comps from dual where exists(
3267: select 1 from mtl_system_items_b WHERE inventory_item_id IN
3268: (
3269: --Get all the sub components for all the components for this item
3270: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3271: -- Get all the components for this item
3272: select COMPONENT_SEQUENCE_ID from bom_components_b WHERE bill_sequence_id IN
3273: (
3274: select bill_sequence_id from bom_bill_of_materials where

Line 3309: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(

3305: select count(*) into l_no_bom_dis_sub_comps from dual where exists(
3306: select 1 from mtl_system_items_b WHERE inventory_item_id IN
3307: (
3308: --Get all the sub components for all the components for this item
3309: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3310: -- Get all the components for this item
3311: select COMPONENT_SEQUENCE_ID from bom_components_b WHERE bill_sequence_id IN
3312: (
3313: select bill_sequence_id from bom_bill_of_materials where

Line 3480: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(

3476: SELECT Count(*) INTO no_bom_disabled_sub_comps FROM dual WHERE EXISTS(
3477: select 1 from mtl_system_items_b WHERE inventory_item_id IN
3478: (
3479: --Get all the sub components for all the components for this item
3480: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3481: -- Get all the components for this item
3482: select COMPONENT_SEQUENCE_ID from bom_components_b WHERE bill_sequence_id IN
3483: (
3484: select bill_sequence_id from bom_bill_of_materials where

Line 7074: BOM_SUBSTITUTE_COMPONENTS bsc

7070: rec_exist:=0;
7071: BEGIN
7072: SELECT bsc.acd_type into rec_exist
7073: FROM Bom_Inventory_Components bic,
7074: BOM_SUBSTITUTE_COMPONENTS bsc
7075: WHERE bic.Old_Component_Sequence_Id = sub_component.old_component_sequence_id
7076: AND bic.Change_Notice = item.change_notice
7077: AND bic.Implementation_Date IS NULL
7078: AND bsc.component_sequence_id = bic.component_sequence_id

Line 7119: Insert into bom_substitute_components(

7115: -- Bug 5854437 End
7116:
7117:
7118: -- Copy substitute components
7119: Insert into bom_substitute_components(
7120: substitute_component_id,
7121: last_update_date,
7122: last_updated_by,
7123: creation_date,

Line 7181: from bom_substitute_components

7177: attribute12,
7178: attribute13,
7179: attribute14,
7180: attribute15
7181: from bom_substitute_components
7182: where component_sequence_id =
7183: component.old_component_sequence_id
7184: and nvl(acd_type, acd_add) = acd_add
7185: and substitute_component_id not in (

Line 7187: from bom_substitute_components

7183: component.old_component_sequence_id
7184: and nvl(acd_type, acd_add) = acd_add
7185: and substitute_component_id not in (
7186: select substitute_component_id
7187: from bom_substitute_components
7188: where component_sequence_id =
7189: component.component_sequence_id);
7190: -- Copy reference designators
7191: Insert into bom_reference_designators (

Line 8965: -- Delete the related bom_substitute_components

8961: --fixed for bug 1870813
8962: revised_item_sequence_id = p_revised_item_sequence_id
8963: ) ;
8964: */
8965: -- Delete the related bom_substitute_components
8966: /* DELETE FROM bom_substitute_components
8967: WHERE component_sequence_id IN
8968: ( SELECT component_sequence_id
8969: FROM bom_inventory_components

Line 8966: /* DELETE FROM bom_substitute_components

8962: revised_item_sequence_id = p_revised_item_sequence_id
8963: ) ;
8964: */
8965: -- Delete the related bom_substitute_components
8966: /* DELETE FROM bom_substitute_components
8967: WHERE component_sequence_id IN
8968: ( SELECT component_sequence_id
8969: FROM bom_inventory_components
8970: -- fixed for bug 1870813