[Home] [Help]
786: CURSOR bom_cursor (bill_seq IN NUMBER,
787: exp_type IN VARCHAR2,
788: sort_ord IN VARCHAR2) IS
789: select count(top_bill_sequence_id) count
790: from bom_explosions be, bom_inventory_components bic
791: where top_bill_sequence_id = bill_seq
792: and explosion_type = exp_type
793: and sort_order = sort_ord
794: and be.component_sequence_id = bic.component_sequence_id