DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEM_UTIL dependencies on BOM_STRUCTURES_B

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

2496: -- by reschedule
2497: CURSOR c_source_components(
2498: cp_change_notice eng_engineering_changes.change_notice%TYPE
2499: , cp_revised_item_seq_id eng_revised_items.revised_item_sequence_id%TYPE
2500: , cp_bill_sequence_id bom_structures_b.bill_sequence_id%TYPE) IS
2501: SELECT bcb.component_sequence_id
2502: FROM bom_components_b bcb
2503: WHERE bcb.CHANGE_NOTICE = cp_change_notice
2504: AND bcb.revised_item_sequence_id = cp_revised_item_seq_id