eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENGPKIMP dependencies on BOM_INVENTORY_COMPONENTS

Line 97: bom_inventory_components bic,

93: FROM DUAL
94: WHERE EXISTS (
95: SELECT 1
96: FROM bom_bill_of_materials bbom,
97: bom_inventory_components bic,
98: mtl_system_items msi
99: WHERE bbom.assembly_item_id = L_NEW_ASSEMBLY_ITEM_ID
100: AND bbom.organization_id = VAR_ORGANIZATION_ID
101: AND ((VAR_SELECTION_OPTION = 2 AND

Line 1901: from bom_components_b c, --bom_inventory_components c,

1897: f.bom_item_type, --BOM ER 9946990
1898: f.replenish_to_order_flag, --BOM ER 9946990
1899: c.optional, --BOM ER 9946990
1900: c.component_remarks
1901: from bom_components_b c, --bom_inventory_components c,
1902: mtl_system_items_b_kfv f
1903: where c.revised_item_sequence_id = revised_item
1904: AND c.bill_sequence_id = cp_bill_sequence_id -- R12: Added for common bom changes
1905: and f.inventory_item_id = c.component_item_id

Line 1933: from bom_components_b c --bom_inventory_components c

1929: Cursor check_existing_component(X_bill number, X_component number,
1930: X_operation number, X_comp_seq_id number, X_disable_date date,X_old_comp_seq_id number
1931: ,X_old_rec_disable_date date) is
1932: Select 'x' -- overlapping effectivity
1933: from bom_components_b c --bom_inventory_components c
1934: where c.bill_sequence_id = X_bill
1935: and c.component_item_id = X_component
1936: and c.operation_seq_num = X_operation
1937: and c.implementation_date is not null

Line 1962: from bom_components_b c --bom_inventory_components c

1958: and (c.disable_date <> c.effectivity_date or c.disable_date is null) ) ); --bug 12807712
1959: /*
1960: union
1961: select 'x' -- duplicate value on unique index
1962: from bom_components_b c --bom_inventory_components c
1963: where c.bill_sequence_id = X_bill
1964: and c.component_item_id = X_component
1965: and c.operation_seq_num = X_operation
1966: and c.effectivity_date = eff_date

Line 1974: from bom_components_b c--bom_inventory_components c

1970: Cursor check_existing_unit(X_bill number, X_component number,
1971: X_operation number, X_comp_seq_id number, X_from_unit_number varchar2,
1972: X_to_unit_number varchar2) is
1973: Select 'x' -- overlapping effectivity
1974: from bom_components_b c--bom_inventory_components c
1975: where c.bill_sequence_id = X_bill
1976: and c.component_item_id = X_component
1977: and c.operation_seq_num = X_operation
1978: and c.implementation_date is not null

Line 1999: FROM bom_components_b o -- bom_inventory_components o

1995: o.overlapping_changes,
1996: o.component_sequence_id,
1997: o.from_end_item_rev_id,
1998: o.to_end_item_rev_id
1999: FROM bom_components_b o -- bom_inventory_components o
2000: where o.component_sequence_id = old_id
2001: for update of o.change_notice,
2002: o.disable_date,
2003: o.to_object_revision_id,

Line 2557: FROM bom_components_b --bom_inventory_components

2553: )
2554: IS
2555:
2556: SELECT operation_seq_num
2557: FROM bom_components_b --bom_inventory_components
2558: WHERE component_sequence_id = p_old_component_sequence_id ;
2559: -- Cursor completed Bug 2722280
2560:
2561: CURSOR l_wip_name_for_job_cur

Line 3076: bom_inventory_components b,

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
3080: and f.inventory_item_id = a.substitute_component_id

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 6024: -- question from bom_inventory_components

6020:
6021: -- ECO for Bills implementation process
6022: --
6023: -- Select all component rows for the assembly and change notice in
6024: -- question from bom_inventory_components
6025: --
6026: -- if the common bom has a diiferent effectivity from the scheduled date then
6027: -- reset the eff_date value used for processing
6028: -- assuming that the components with the same effectivity are grouped together

Line 6672: Update bom_components_b --bom_inventory_components

6668: ELSE*/
6669: old_comp_rec.disable_date := eff_date;
6670: --END IF;
6671:
6672: Update bom_components_b --bom_inventory_components
6673: set disable_date = old_comp_rec.disable_date,
6674: to_object_revision_id = old_comp_rec.to_object_revision_id,
6675: overlapping_changes = old_comp_rec.overlapping_changes,
6676: change_notice = old_comp_rec.change_notice,

Line 6711: Update bom_components_b --bom_inventory_components

6707: Raise abort_implementation;
6708: end if;
6709: end if;
6710:
6711: Update bom_components_b --bom_inventory_components
6712: set to_end_item_unit_number = X_prev_unit_number,
6713: to_object_revision_id = old_comp_rec.to_object_revision_id,
6714: overlapping_changes = old_comp_rec.overlapping_changes,
6715: change_notice = old_comp_rec.change_notice,

Line 6745: Update bom_components_b --bom_inventory_components

6741: ELSE*/
6742: old_comp_rec.disable_date := eff_date;
6743: --END IF;
6744:
6745: Update bom_components_b --bom_inventory_components
6746: set disable_date = old_comp_rec.disable_date,
6747: to_object_revision_id = old_comp_rec.to_object_revision_id,
6748: overlapping_changes = old_comp_rec.overlapping_changes,
6749: change_notice = old_comp_rec.change_notice,

Line 6794: Update bom_components_b --bom_inventory_components

6790: Raise abort_implementation;
6791: end if;
6792: end if;
6793:
6794: Update bom_components_b --bom_inventory_components
6795: set to_end_item_rev_id = l_prev_end_item_rev_id,
6796: to_object_revision_id = old_comp_rec.to_object_revision_id,
6797: overlapping_changes = old_comp_rec.overlapping_changes,
6798: change_notice = old_comp_rec.change_notice,

Line 6831: Update bom_components_b --bom_inventory_components

6827: END IF;*/
6828: old_comp_rec.disable_date := eff_date; --bug 5622459
6829: l_old_disable_date := old_comp_rec.disable_date;
6830: -- Date effectivity implementation
6831: Update bom_components_b --bom_inventory_components
6832: set disable_date = old_comp_rec.disable_date,
6833: to_object_revision_id = old_comp_rec.to_object_revision_id,
6834: overlapping_changes = old_comp_rec.overlapping_changes,
6835: change_notice = old_comp_rec.change_notice,

Line 7073: FROM Bom_Inventory_Components bic,

7069: If check_existing_substitutes%found then
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

Line 7319: Update bom_components_b--bom_inventory_components

7315: component.overlapping_changes := null;
7316: END IF;
7317: end if;
7318:
7319: Update bom_components_b--bom_inventory_components
7320: set implementation_date = today,
7321: change_notice = item.change_notice,
7322: disable_date = component.disable_date,
7323: effectivity_date = eff_date,

Line 7344: UPDATE bom_components_b--bom_inventory_components

7340: -- Not done as any UI updates will maintain the attrs in sync
7341: -----------------------------------------------------------
7342: IF isCommonedBOM = 'Y'
7343: THEN
7344: UPDATE bom_components_b--bom_inventory_components
7345: SET implementation_date = today,
7346: change_notice = item.change_notice,
7347: disable_date = component.disable_date,
7348: effectivity_date = eff_date,

Line 7418: Update bom_components_b--bom_inventory_components

7414: --
7415:
7416: If component.acd_type = acd_change then
7417: IF item.eco_for_production = 2 Then
7418: Update bom_components_b--bom_inventory_components
7419: set old_component_sequence_id = component.component_sequence_id,
7420: last_update_date = sysdate,
7421: last_updated_by = userid,
7422: last_update_login = loginid,

Line 7581: from bom_components_b --bom_inventory_components

7577: TO_END_ITEM_MINOR_REV_ID,
7578: COMPONENT_ITEM_REVISION_ID,
7579: COMMON_COMPONENT_SEQUENCE_ID,
7580: BASIS_TYPE
7581: from bom_components_b --bom_inventory_components
7582: where component_sequence_id = component.component_sequence_id;
7583: If component.acd_type = acd_delete then
7584: Delete from bom_components_b --bom_inventory_components
7585: -- where current of chng_component_rows;

Line 7584: Delete from bom_components_b --bom_inventory_components

7580: BASIS_TYPE
7581: from bom_components_b --bom_inventory_components
7582: where component_sequence_id = component.component_sequence_id;
7583: If component.acd_type = acd_delete then
7584: Delete from bom_components_b --bom_inventory_components
7585: -- where current of chng_component_rows;
7586: where component_sequence_id = component.component_sequence_id;
7587:
7588: -----------------------------------------------------------

Line 8959: FROM bom_inventory_components

8955: --
8956: /* DELETE FROM bom_reference_designators
8957: WHERE component_sequence_id IN
8958: ( SELECT component_sequence_id
8959: FROM bom_inventory_components
8960: WHERE
8961: --fixed for bug 1870813
8962: revised_item_sequence_id = p_revised_item_sequence_id
8963: ) ;

Line 8969: FROM bom_inventory_components

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
8971: WHERE revised_item_sequence_id = p_revised_item_sequence_id
8972: ) ;
8973: */

Line 8974: -- before delete the related bom_inventory_components records,

8970: -- fixed for bug 1870813
8971: WHERE revised_item_sequence_id = p_revised_item_sequence_id
8972: ) ;
8973: */
8974: -- before delete the related bom_inventory_components records,
8975: -- make the old conponents active again.
8976: FOR i in 1..rev_comp_disable_date_tbl.count
8977: LOOP
8978:

Line 8979: UPDATE bom_components_b--bom_inventory_components

8975: -- make the old conponents active again.
8976: FOR i in 1..rev_comp_disable_date_tbl.count
8977: LOOP
8978:
8979: UPDATE bom_components_b--bom_inventory_components
8980: SET
8981: disable_date = rev_comp_disable_date_tbl(i).disable_date,
8982: last_update_date = sysdate,
8983: last_updated_by = userid,

Line 9016: -- Delete the related bom_inventory_components whose

9012: END IF;
9013: -----------------------------------------------------------
9014: -- R12: End Step 2.1: Changes for Common BOM Enhancement --
9015: -----------------------------------------------------------
9016: -- Delete the related bom_inventory_components whose
9017: -- eco_for_production = 1.
9018: DELETE FROM bom_components_b--bom_inventory_components
9019: WHERE revised_item_sequence_id = p_revised_item_sequence_id ;
9020:

Line 9018: DELETE FROM bom_components_b--bom_inventory_components

9014: -- R12: End Step 2.1: Changes for Common BOM Enhancement --
9015: -----------------------------------------------------------
9016: -- Delete the related bom_inventory_components whose
9017: -- eco_for_production = 1.
9018: DELETE FROM bom_components_b--bom_inventory_components
9019: WHERE revised_item_sequence_id = p_revised_item_sequence_id ;
9020:
9021: -- Delete the related eng revised _components whose
9022: -- eco_for_production = 1.