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 602: FROM bom_components_b bcb

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

Line 857: FROM bom_components_b

853:
854: CURSOR c_query_revised_component
855: IS
856: SELECT revised_item_sequence_id, acd_type, component_sequence_id
857: FROM bom_components_b
858: WHERE component_item_id = p_component_item_id
859: AND (p_effectivity_date IS NULL OR effectivity_date = p_effectivity_date)
860: AND bill_sequence_id = p_bill_sequence_id
861: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR)

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

961: -- 2: revised item status check
962: -- 3: common bom for src pending changes
963: CURSOR c_chk_rev_comp_editable IS
964: SELECT eri.revised_item_sequence_id
965: FROM eng_revised_items eri , mtl_system_items_vl msiv , bom_components_b bcb
966: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
967: and bcb.component_sequence_id = p_component_sequence_id
968: AND eri.revised_item_id = msiv.inventory_item_id
969: AND eri.organization_id = msiv.organization_id