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 1808: from bom_components_b c, --bom_inventory_components c,

1804: c.to_end_item_rev_id,
1805: c.component_item_revision_id,
1806: c.obj_name,
1807: c.component_remarks
1808: from bom_components_b c, --bom_inventory_components c,
1809: mtl_system_items_b_kfv f
1810: where c.revised_item_sequence_id = revised_item
1811: AND c.bill_sequence_id = cp_bill_sequence_id -- R12: Added for common bom changes
1812: and f.inventory_item_id = c.component_item_id

Line 1840: from bom_components_b c --bom_inventory_components c

1836: Cursor check_existing_component(X_bill number, X_component number,
1837: X_operation number, X_comp_seq_id number, X_disable_date date,X_old_comp_seq_id number
1838: ,X_old_rec_disable_date date) is
1839: Select 'x' -- overlapping effectivity
1840: from bom_components_b c --bom_inventory_components c
1841: where c.bill_sequence_id = X_bill
1842: and c.component_item_id = X_component
1843: and c.operation_seq_num = X_operation
1844: and c.implementation_date is not null

Line 1866: from bom_components_b c --bom_inventory_components c

1862: and c.disable_date <> c.effectivity_date ) );
1863: /*
1864: union
1865: select 'x' -- duplicate value on unique index
1866: from bom_components_b c --bom_inventory_components c
1867: where c.bill_sequence_id = X_bill
1868: and c.component_item_id = X_component
1869: and c.operation_seq_num = X_operation
1870: and c.effectivity_date = eff_date

Line 1878: from bom_components_b c--bom_inventory_components c

1874: Cursor check_existing_unit(X_bill number, X_component number,
1875: X_operation number, X_comp_seq_id number, X_from_unit_number varchar2,
1876: X_to_unit_number varchar2) is
1877: Select 'x' -- overlapping effectivity
1878: from bom_components_b c--bom_inventory_components c
1879: where c.bill_sequence_id = X_bill
1880: and c.component_item_id = X_component
1881: and c.operation_seq_num = X_operation
1882: and c.implementation_date is not null

Line 1903: FROM bom_components_b o -- bom_inventory_components o

1899: o.overlapping_changes,
1900: o.component_sequence_id,
1901: o.from_end_item_rev_id,
1902: o.to_end_item_rev_id
1903: FROM bom_components_b o -- bom_inventory_components o
1904: where o.component_sequence_id = old_id
1905: for update of o.change_notice,
1906: o.disable_date,
1907: o.to_object_revision_id,

Line 2461: FROM bom_components_b --bom_inventory_components

2457: )
2458: IS
2459:
2460: SELECT operation_seq_num
2461: FROM bom_components_b --bom_inventory_components
2462: WHERE component_sequence_id = p_old_component_sequence_id ;
2463: -- Cursor completed Bug 2722280
2464:
2465: CURSOR l_wip_name_for_job_cur

Line 2945: bom_inventory_components b,

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

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

5756:
5757: -- ECO for Bills implementation process
5758: --
5759: -- Select all component rows for the assembly and change notice in
5760: -- question from bom_inventory_components
5761: --
5762: -- if the common bom has a diiferent effectivity from the scheduled date then
5763: -- reset the eff_date value used for processing
5764: -- assuming that the components with the same effectivity are grouped together

Line 6365: Update bom_components_b --bom_inventory_components

6361: ELSE*/
6362: old_comp_rec.disable_date := eff_date;
6363: --END IF;
6364:
6365: Update bom_components_b --bom_inventory_components
6366: set disable_date = old_comp_rec.disable_date,
6367: to_object_revision_id = old_comp_rec.to_object_revision_id,
6368: overlapping_changes = old_comp_rec.overlapping_changes,
6369: change_notice = old_comp_rec.change_notice,

Line 6404: Update bom_components_b --bom_inventory_components

6400: Raise abort_implementation;
6401: end if;
6402: end if;
6403:
6404: Update bom_components_b --bom_inventory_components
6405: set to_end_item_unit_number = X_prev_unit_number,
6406: to_object_revision_id = old_comp_rec.to_object_revision_id,
6407: overlapping_changes = old_comp_rec.overlapping_changes,
6408: change_notice = old_comp_rec.change_notice,

Line 6438: Update bom_components_b --bom_inventory_components

6434: ELSE*/
6435: old_comp_rec.disable_date := eff_date;
6436: --END IF;
6437:
6438: Update bom_components_b --bom_inventory_components
6439: set disable_date = old_comp_rec.disable_date,
6440: to_object_revision_id = old_comp_rec.to_object_revision_id,
6441: overlapping_changes = old_comp_rec.overlapping_changes,
6442: change_notice = old_comp_rec.change_notice,

Line 6487: Update bom_components_b --bom_inventory_components

6483: Raise abort_implementation;
6484: end if;
6485: end if;
6486:
6487: Update bom_components_b --bom_inventory_components
6488: set to_end_item_rev_id = l_prev_end_item_rev_id,
6489: to_object_revision_id = old_comp_rec.to_object_revision_id,
6490: overlapping_changes = old_comp_rec.overlapping_changes,
6491: change_notice = old_comp_rec.change_notice,

Line 6524: Update bom_components_b --bom_inventory_components

6520: END IF;*/
6521: old_comp_rec.disable_date := eff_date; --bug 5622459
6522: l_old_disable_date := old_comp_rec.disable_date;
6523: -- Date effectivity implementation
6524: Update bom_components_b --bom_inventory_components
6525: set disable_date = old_comp_rec.disable_date,
6526: to_object_revision_id = old_comp_rec.to_object_revision_id,
6527: overlapping_changes = old_comp_rec.overlapping_changes,
6528: change_notice = old_comp_rec.change_notice,

Line 6756: FROM Bom_Inventory_Components bic,

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

Line 7001: Update bom_components_b--bom_inventory_components

6997: component.overlapping_changes := null;
6998: END IF;
6999: end if;
7000:
7001: Update bom_components_b--bom_inventory_components
7002: set implementation_date = today,
7003: change_notice = item.change_notice,
7004: disable_date = component.disable_date,
7005: effectivity_date = eff_date,

Line 7026: UPDATE bom_components_b--bom_inventory_components

7022: -- Not done as any UI updates will maintain the attrs in sync
7023: -----------------------------------------------------------
7024: IF isCommonedBOM = 'Y'
7025: THEN
7026: UPDATE bom_components_b--bom_inventory_components
7027: SET implementation_date = today,
7028: change_notice = item.change_notice,
7029: disable_date = component.disable_date,
7030: effectivity_date = eff_date,

Line 7096: Update bom_components_b--bom_inventory_components

7092: --
7093:
7094: If component.acd_type = acd_change then
7095: IF item.eco_for_production = 2 Then
7096: Update bom_components_b--bom_inventory_components
7097: set old_component_sequence_id = component.component_sequence_id,
7098: last_update_date = sysdate,
7099: last_updated_by = userid,
7100: last_update_login = loginid,

Line 7259: from bom_components_b --bom_inventory_components

7255: TO_END_ITEM_MINOR_REV_ID,
7256: COMPONENT_ITEM_REVISION_ID,
7257: COMMON_COMPONENT_SEQUENCE_ID,
7258: BASIS_TYPE
7259: from bom_components_b --bom_inventory_components
7260: where component_sequence_id = component.component_sequence_id;
7261: If component.acd_type = acd_delete then
7262: Delete from bom_components_b --bom_inventory_components
7263: -- where current of chng_component_rows;

Line 7262: Delete from bom_components_b --bom_inventory_components

7258: BASIS_TYPE
7259: from bom_components_b --bom_inventory_components
7260: where component_sequence_id = component.component_sequence_id;
7261: If component.acd_type = acd_delete then
7262: Delete from bom_components_b --bom_inventory_components
7263: -- where current of chng_component_rows;
7264: where component_sequence_id = component.component_sequence_id;
7265:
7266: -----------------------------------------------------------

Line 8614: FROM bom_inventory_components

8610: --
8611: /* DELETE FROM bom_reference_designators
8612: WHERE component_sequence_id IN
8613: ( SELECT component_sequence_id
8614: FROM bom_inventory_components
8615: WHERE
8616: --fixed for bug 1870813
8617: revised_item_sequence_id = p_revised_item_sequence_id
8618: ) ;

Line 8624: FROM bom_inventory_components

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
8626: WHERE revised_item_sequence_id = p_revised_item_sequence_id
8627: ) ;
8628: */

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

8625: -- fixed for bug 1870813
8626: WHERE revised_item_sequence_id = p_revised_item_sequence_id
8627: ) ;
8628: */
8629: -- before delete the related bom_inventory_components records,
8630: -- make the old conponents active again.
8631: FOR i in 1..rev_comp_disable_date_tbl.count
8632: LOOP
8633:

Line 8634: UPDATE bom_components_b--bom_inventory_components

8630: -- make the old conponents active again.
8631: FOR i in 1..rev_comp_disable_date_tbl.count
8632: LOOP
8633:
8634: UPDATE bom_components_b--bom_inventory_components
8635: SET
8636: disable_date = rev_comp_disable_date_tbl(i).disable_date,
8637: last_update_date = sysdate,
8638: last_updated_by = userid,

Line 8671: -- Delete the related bom_inventory_components whose

8667: END IF;
8668: -----------------------------------------------------------
8669: -- R12: End Step 2.1: Changes for Common BOM Enhancement --
8670: -----------------------------------------------------------
8671: -- Delete the related bom_inventory_components whose
8672: -- eco_for_production = 1.
8673: DELETE FROM bom_components_b--bom_inventory_components
8674: WHERE revised_item_sequence_id = p_revised_item_sequence_id ;
8675:

Line 8673: DELETE FROM bom_components_b--bom_inventory_components

8669: -- R12: End Step 2.1: Changes for Common BOM Enhancement --
8670: -----------------------------------------------------------
8671: -- Delete the related bom_inventory_components whose
8672: -- eco_for_production = 1.
8673: DELETE FROM bom_components_b--bom_inventory_components
8674: WHERE revised_item_sequence_id = p_revised_item_sequence_id ;
8675:
8676: -- Delete the related eng revised _components whose
8677: -- eco_for_production = 1.