[Home] [Help]
111: it is the first item in routing sequence.
112: Fix : Forward ported changes done for 11i bugs 4680221 and 5017903
113: (corresponding R12 FP bugs - 4940629 and 5072683).
114: Following changes are done:
115: 1)Cursor c_get_rout_status will get the data from wip_operations
116: instead of bom_operation_sequences.
117: 2)Cursor c_discrete_bill_seq_id (and its use) is removed. Data
118: from the po_dist record will be used instead.
119: 3)Modified the filter condition in the cursor of c_component_rec.
323: /* to check if this is the first operation. */
324: /*This cursor re-written for bug 8602495*/
325: CURSOR c_get_rout_status(cp_wip_entity_id NUMBER, cp_wip_operation NUMBER) IS
326: SELECT COUNT(1)
327: FROM wip_operations
328: WHERE wip_entity_id = cp_wip_entity_id
329: AND operation_seq_num < cp_wip_operation ;
330:
331: CURSOR c_check_reqmt_ops( cp_wip_entity_id po_distributions_all.wip_entity_id%TYPE , cp_wip_op_seq_num po_distributions_all.wip_operation_seq_num%TYPE) IS