APPS.ENG_REVISED_ITEMS_PKG dependencies on BOM_STRUCTURES_B

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

596: -- by reschedule
597: CURSOR c_source_components(
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

Line 837: FROM bom_structures_b

833: l_api_version NUMBER;
834:
835: CURSOR c_bill_details IS
836: SELECT alternate_bom_designator
837: FROM bom_structures_b
838: WHERE bill_sequence_id = p_bill_sequence_id;
839:
840: CURSOR c_query_revised_item
841: IS