APPS.BOM_DELETE_ENTITY dependencies on BOM_OPERATIONAL_ROUTINGS

Line 181: FROM bom_operational_routings

177: RETURN NUMBER
178: IS
179: CURSOR rtgseq is
180: select routing_sequence_id
181: FROM bom_operational_routings
182: where assembly_item_id = assembly_id and
183: organization_id = org_id and
184: nvl(alternate_routing_designator,'none') = nvl(alternate_desg,'none');
185: BEGIN

Line 512: new_rtg_seq bom_operational_routings.routing_sequence_id%type;

508: new_del_seq bom_delete_entities.delete_entity_sequence_id%type;
509: new_comp_seq bom_delete_sub_entities.component_sequence_id%type := NULL;
510: new_operation_seq bom_delete_sub_entities.operation_sequence_id%type;
511: new_bill_seq bom_bill_of_materials.bill_sequence_id%type;
512: new_rtg_seq bom_operational_routings.routing_sequence_id%type;
513: new_item_id bom_delete_entities.inventory_item_id%type;
514: component_id bom_inventory_components.component_item_id%type;
515: oper_seq_num bom_inventory_components.operation_seq_num%type;
516: effective_date bom_inventory_components.effectivity_date%type;