116: CURSOR cur_itemdetails(p_delivery_id IN NUMBER,
117: p_delivery_detail_id IN NUMBER)
118: IS
119: SELECT *
120: FROM wsh_opsm_asn_item_details_v
121: WHERE delivery_id = p_delivery_id
122: AND delivery_detail_id = p_delivery_detail_id;
123:
124: --bug 10357152 - opsmperf begin
1183: CURSOR cur_itemdetails(p_delivery_id IN NUMBER,
1184: p_delivery_detail_id IN NUMBER)
1185: IS
1186: SELECT *
1187: FROM wsh_opsm_asn_item_details_v
1188: WHERE delivery_id = p_delivery_id
1189: AND delivery_detail_id = p_delivery_detail_id;
1190:
1191: --bug 10357152 - opsmperf begin