[Home] [Help]
76: l_cont_name VARCHAR2(30);
77:
78: CURSOR Get_Name (v_cont_inst_id NUMBER) IS
79: SELECT container_name
80: FROM WSH_DELIVERY_DETAILS
81: WHERE delivery_detail_id = v_cont_inst_id
82: AND container_flag in ('Y', 'C');
83:
84: --
285: requested_quantity_uom,
286: master_container_item_id, detail_container_item_id, hold_code,
287: load_seq_number, net_weight,
288: weight_uom_code, volume, volume_uom_code, organization_id
289: FROM WSH_DELIVERY_DETAILS
290: WHERE delivery_detail_id = v_del_detail_id
291: AND container_flag = 'N';
292:
293: CURSOR Get_Container_Info (v_cont_instance_id NUMBER, v_org_id NUMBER)IS
295: inventory_item_id container_item_id, item_description,
296: gross_weight, net_weight, (gross_weight - net_weight), weight_uom_code,
297: volume, volume_uom_code, fill_percent, maximum_load_weight,
298: maximum_volume, minimum_fill_percent
299: FROM WSH_DELIVERY_DETAILS
300: WHERE delivery_detail_id = v_cont_instance_id
301: AND organization_id = v_org_id
302: AND container_flag in ('Y', 'C');
303:
314:
315: CURSOR get_cont_fill_qty (v_container_instance_id NUMBER) IS
316: SELECT sum(nvl(wdd.shipped_quantity,
317: NVL(wdd.picked_quantity, wdd.requested_quantity))) packed_qty
318: FROM wsh_delivery_details wdd
319: WHERE wdd.delivery_detail_id IN
320: (SELECT wda.delivery_detail_id
321: FROM wsh_delivery_assignments_v wda
322: WHERE wda.parent_delivery_detail_id IS NOT NULL
1060: requested_quantity_uom,
1061: master_container_item_id, detail_container_item_id, hold_code,
1062: load_seq_number, net_weight,
1063: weight_uom_code, volume, volume_uom_code, organization_id
1064: FROM WSH_DELIVERY_DETAILS
1065: WHERE delivery_detail_id = v_del_detail_id
1066: AND container_flag = 'N';
1067:
1068: CURSOR Get_Container_Info (v_cont_instance_id NUMBER, v_org_id NUMBER)IS
1070: inventory_item_id container_item_id, item_description,
1071: gross_weight, net_weight, (gross_weight - net_weight), weight_uom_code,
1072: volume, volume_uom_code, fill_percent, maximum_load_weight,
1073: maximum_volume, minimum_fill_percent
1074: FROM WSH_DELIVERY_DETAILS
1075: WHERE delivery_detail_id = v_cont_instance_id
1076: AND organization_id = v_org_id
1077: AND container_flag in ('Y', 'C');
1078:
1732: requested_quantity,requested_quantity_uom,
1733: gross_weight, net_weight, (gross_weight - net_weight), weight_uom_code,
1734: volume, volume_uom_code, fill_percent,
1735: minimum_fill_percent, organization_id
1736: FROM WSH_DELIVERY_DETAILS
1737: WHERE delivery_detail_id = v_cont_instance_id
1738: AND organization_id = nvl(v_org_id, organization_id)
1739: AND container_flag in ('Y', 'C');
1740:
2236: CONNECT BY PRIOR parent_delivery_detail_id = delivery_detail_id;
2237:
2238: CURSOR Get_Serial_Number (v_detail_id NUMBER) IS
2239: SELECT master_serial_number, delivery_detail_id, container_flag
2240: FROM WSH_DELIVERY_DETAILS
2241: WHERE delivery_detail_id = v_detail_id;
2242:
2243: l_det_id NUMBER;
2244: l_cont_flag VARCHAR2(1);
2398: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
2399:
2400: CURSOR l_get_det_attribs_csr(p_detail_id IN NUMBER) IS
2401: SELECT container_flag, nvl(line_direction, 'O'), organization_id
2402: from wsh_delivery_details
2403: where delivery_detail_id = p_detail_id;
2404:
2405: l_cont_instance_id NUMBER;
2406:
2450: -- not included in the results of get_child_containers.
2451: IF (p_container_instance_id <> p_master_cont_instance_id)
2452: OR (p_master_cont_instance_id IS NULL) THEN
2453: --{
2454: UPDATE WSH_DELIVERY_DETAILS
2455: SET master_serial_number = p_master_serial_number
2456: WHERE delivery_detail_id = p_container_instance_id
2457: RETURNING container_flag, NVL(line_direction, 'O'), organization_id
2458: INTO l_cnt_flag, l_line_direction, l_organization_id;
2586: --}
2587: END IF;
2588: -- K LPN CONV. rv
2589: --
2590: UPDATE WSH_DELIVERY_DETAILS
2591: SET master_serial_number = p_master_serial_number
2592: WHERE delivery_detail_id = det.delivery_detail_id;
2593:
2594: IF (SQL%ROWCOUNT > 1 OR SQL%NOTFOUND) THEN
2726:
2727:
2728: CURSOR Get_Master_Serial (v_cont_instance_id NUMBER) IS
2729: SELECT master_serial_number
2730: FROM WSH_DELIVERY_DETAILS
2731: WHERE delivery_detail_id = v_cont_instance_id;
2732:
2733: l_cont_name VARCHAR2(30);
2734:
2835:
2836: CURSOR Fetch_Details (v_cont_instance_id NUMBER) IS
2837: SELECT wda.delivery_detail_id, wda.delivery_id
2838: FROM wsh_delivery_assignments_v wda,
2839: WSH_DELIVERY_DETAILS wdd
2840: WHERE wda.parent_delivery_detail_id = v_cont_instance_id
2841: AND wdd.delivery_detail_id = wda.delivery_detail_id
2842: AND wdd.container_flag = 'N'
2843: AND rownum < 2
2942:
2943:
2944: CURSOR c_details_exist (v_delivery_detail_id NUMBER) IS
2945: SELECT 1
2946: FROM wsh_delivery_details
2947: WHERE delivery_detail_id in (
2948: SELECT delivery_detail_id
2949: FROM wsh_delivery_assignments_v
2950: START WITH delivery_detail_id = v_delivery_detail_id
3040: x_return_status OUT NOCOPY VARCHAR2) IS
3041:
3042: CURSOR Get_Fill_Percent (v_cont_instance_id NUMBER) IS
3043: SELECT fill_percent
3044: FROM WSH_DELIVERY_DETAILS
3045: WHERE delivery_detail_id = v_cont_instance_id
3046: AND container_flag in ('Y', 'C');
3047:
3048: l_fill_percent NUMBER;
3154: x_return_status OUT NOCOPY VARCHAR2) IS
3155:
3156: CURSOR Get_Delivery_Status (v_cont_instance_id NUMBER) IS
3157: SELECT wda.delivery_id, wnd.status_code
3158: FROM wsh_delivery_assignments_v wda, WSH_NEW_DELIVERIES wnd, WSH_DELIVERY_DETAILS wdd
3159: WHERE wda.delivery_detail_id = v_cont_instance_id
3160: AND wda.delivery_id = wnd.delivery_id
3161: AND wdd.delivery_detail_id = wda.delivery_detail_id
3162: AND wdd.container_flag in ('Y', 'C');
3273: x_return_status OUT NOCOPY VARCHAR2) IS
3274:
3275: CURSOR Check_Dup_Cont IS
3276: SELECT delivery_detail_id
3277: FROM WSH_DELIVERY_DETAILS
3278: WHERE container_name = p_container_name
3279: AND container_flag in ('Y', 'C');
3280:
3281: l_cont_instance_id NUMBER;