[Home] [Help]
1972:
1973: CURSOR reserved_quantity_nonctl( p_organization_id NUMBER
1974: ,p_inventory_item_id NUMBER ) is
1975: Select sum(nvl(requested_quantity,0)), sum(nvl(requested_quantity2,0))
1976: From wsh_delivery_details
1977: Where organization_id = p_organization_id
1978: and inventory_item_id = p_inventory_item_id
1979: and released_status in ('S', 'Y');
1980:
1991:
1992: /* Bug 3297382 shipset cursor declarations */
1993: CURSOR get_shipset_id IS
1994: SELECT nvl(ship_set_id, 0), source_header_id
1995: FROM wsh_delivery_details
1996: WHERE delivery_detail_id = p_delivery_detail_id;
1997:
1998: CURSOR Shipping_parameters( v_org_id IN NUMBER) IS
1999: SELECT NVL(ENFORCE_SHIP_SET_AND_SMC,'N')
2004: -- Get high level reserved qty. That is sum of requested qtys for all delivery detail lines which are
2005: -- relesed to warehouse for a given warehouse and item combination.
2006: CURSOR high_level_reserved_qty(p_organization_id NUMBER, p_inventory_item_id NUMBER) is
2007: SELECT NVL(sum(nvl(requested_quantity,0)),0), NVL(sum(nvl(requested_quantity2,0)),0)
2008: FROM wsh_delivery_details
2009: WHERE organization_id = p_organization_id
2010: AND inventory_item_id = p_inventory_item_id
2011: AND source_code = 'OE'
2012: AND released_status = 'S';
2022: AND completed_ind = 0
2023: AND delete_mark = 0
2024: AND trans_qty < 0
2025: AND EXISTS(SELECT 1
2026: FROM wsh_delivery_details
2027: WHERE delivery_detail_id = itp.line_detail_id
2028: AND source_code = 'OE'
2029: AND released_status = 'S');
2030:
2383:
2384: -- odaboval, Oct-2001, standalone fix for Tropicana.
2385: CURSOR c_get_wsh_released_status( l_so_line_id IN NUMBER) IS
2386: SELECT released_status
2387: FROM wsh_delivery_details
2388: WHERE released_status IN ('Y', 'C')
2389: AND source_line_id = l_so_line_id;
2390:
2391: BEGIN
2956: -- Cursor Declarations
2957:
2958: CURSOR shipset_item IS
2959: Select delivery_detail_id, inventory_item_id, organization_id, source_line_id, requested_quantity, requested_quantity2
2960: FROM wsh_delivery_details
2961: WHERE source_header_id = p_source_header_id
2962: AND ship_set_id = p_shipset_id
2963: AND source_code = 'OE'
2964: AND released_status <> 'D';
2966: itm_rec shipset_item%ROWTYPE;
2967:
2968: CURSOR shipset_item_group IS
2969: Select inventory_item_id, Sum(requested_quantity) total_requested
2970: FROM wsh_delivery_details
2971: WHERE source_header_id = p_source_header_id
2972: AND ship_set_id = p_shipset_id
2973: AND source_code = 'OE'
2974: AND released_status <> 'D'
2991: WHERE item_id=l_opm_itm_id;
2992:
2993: CURSOR reserved_quantity_nonctl(l_apps_itm_id NUMBER ) is
2994: Select sum(nvl(requested_quantity,0)), sum(nvl(requested_quantity2,0))
2995: From wsh_delivery_details
2996: Where organization_id = p_organization_id
2997: and inventory_item_id = l_apps_itm_id
2998: and released_status in ('S', 'Y');
2999:
3023: -- Get high level reserved qty. That is sum of requested qtys for all delivery detail lines which are
3024: -- relesed to warehouse for a given warehouse and item combination.
3025: CURSOR high_level_reserved_qty(p_organization_id NUMBER, p_inventory_item_id NUMBER) is
3026: SELECT NVL(sum(nvl(requested_quantity,0)),0), NVL(sum(nvl(requested_quantity2,0)),0)
3027: FROM wsh_delivery_details
3028: WHERE organization_id = p_organization_id
3029: AND inventory_item_id = p_inventory_item_id
3030: AND source_code = 'OE'
3031: AND released_status = 'S';
3041: AND completed_ind = 0
3042: AND delete_mark = 0
3043: AND trans_qty < 0
3044: AND EXISTS(SELECT 1
3045: FROM wsh_delivery_details
3046: WHERE delivery_detail_id = itp.line_detail_id
3047: AND source_code = 'OE'
3048: AND released_status = 'S');
3049: