APPS.ENG_REVISED_ITEMS_PKG dependencies on BOM_STRUCTURES_B

Line 602: , cp_bill_sequence_id bom_structures_b.bill_sequence_id%TYPE) IS

598: -- by reschedule
599: CURSOR c_source_components(
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

Line 860: FROM bom_structures_b

856: l_api_version NUMBER;
857:
858: CURSOR c_bill_details IS
859: SELECT alternate_bom_designator
860: FROM bom_structures_b
861: WHERE bill_sequence_id = p_bill_sequence_id;
862:
863: CURSOR c_query_revised_item
864: IS