DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEM_UTIL dependencies on BOM_STRUCTURES_B

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

2472: -- by reschedule
2473: CURSOR c_source_components(
2474: cp_change_notice eng_engineering_changes.change_notice%TYPE
2475: , cp_revised_item_seq_id eng_revised_items.revised_item_sequence_id%TYPE
2476: , cp_bill_sequence_id bom_structures_b.bill_sequence_id%TYPE) IS
2477: SELECT bcb.component_sequence_id
2478: FROM bom_components_b bcb
2479: WHERE bcb.CHANGE_NOTICE = cp_change_notice
2480: AND bcb.revised_item_sequence_id = cp_revised_item_seq_id