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.ENG_REVISED_ITEMS_PKG dependencies on BOM_COMPONENTS_B

Line 604: FROM bom_components_b bcb

600: cp_change_notice eng_engineering_changes.change_notice%TYPE
601: , cp_revised_item_seq_id eng_revised_items.revised_item_sequence_id%TYPE
602: , cp_bill_sequence_id bom_structures_b.bill_sequence_id%TYPE) IS
603: SELECT bcb.component_sequence_id
604: FROM bom_components_b bcb
605: WHERE bcb.CHANGE_NOTICE = cp_change_notice
606: AND bcb.revised_item_sequence_id = cp_revised_item_seq_id
607: AND bcb.bill_sequence_id = cp_bill_sequence_id
608: AND (bcb.common_component_sequence_id IS NULL

Line 880: FROM bom_components_b

876:
877: CURSOR c_query_revised_component
878: IS
879: SELECT revised_item_sequence_id, acd_type, component_sequence_id
880: FROM bom_components_b
881: WHERE component_item_id = p_component_item_id
882: AND (p_effectivity_date IS NULL OR effectivity_date = p_effectivity_date)
883: AND bill_sequence_id = p_bill_sequence_id
884: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR)

Line 988: FROM eng_revised_items eri , mtl_system_items_vl msiv , bom_components_b bcb

984: -- 2: revised item status check
985: -- 3: common bom for src pending changes
986: CURSOR c_chk_rev_comp_editable IS
987: SELECT eri.revised_item_sequence_id
988: FROM eng_revised_items eri , mtl_system_items_vl msiv , bom_components_b bcb
989: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
990: and bcb.component_sequence_id = p_component_sequence_id
991: AND eri.revised_item_id = msiv.inventory_item_id
992: AND eri.organization_id = msiv.organization_id