APPS.FLM_COPY_ROUTING dependencies on BOM_STD_OP_RESOURCES

Line 561: Select * From bom_std_op_resources

557: Select * From bom_standard_operations
558: Where standard_operation_id = p_standard_operation_id;
559:
560: Cursor c_std_op_res(p_standard_operation_id number) Is
561: Select * From bom_std_op_resources
562: Where standard_operation_id = p_standard_operation_id ;
563:
564: Cursor c_new_rtg_seq_id(p_item_id number, p_org_id number, p_alternate varchar2) Is
565: Select routing_sequence_id

Line 1128: from bom_std_op_resources bsor

1124: l_op_resource_tbl(k).Row_identifier := l_op_res_rec.Row_identifier;
1125: l_op_res_cnt := 0;
1126: if l_operations_rec.Standard_Operation_id is not null then
1127: select count(1) into l_op_res_cnt
1128: from bom_std_op_resources bsor
1129: where bsor.Standard_Operation_id = l_operations_rec.Standard_Operation_id
1130: and bsor.resource_seq_num = l_op_res_rec.Resource_Sequence_Number;
1131: if l_op_res_cnt > 0 then
1132: l_op_resource_tbl(k).Transaction_type := 'UPDATE';