APPS.WSH_PICK_LIST dependencies on WSH_SHIPPING_PARAMETERS

Line 821: p_use_header_flag IN WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE, -- bug 8623544

817: p_express_pick_flag IN VARCHAR2,
818: p_pick_slip_grouping_rule IN NUMBER,
819: p_to_subinventory IN VARCHAR2,
820: p_to_locator IN VARCHAR2,
821: p_use_header_flag IN WSH_SHIPPING_PARAMETERS.AUTOCREATE_DEL_ORDERS_PR_FLAG%TYPE, -- bug 8623544
822: x_curr_count IN OUT NOCOPY NUMBER,
823: x_return_status OUT NOCOPY VARCHAR2)
824: IS
825:

Line 3700: FROM wsh_shipping_parameters wsp, wsh_delivery_details wdd

3696:
3697: --Cursor to get ship confirm rule and Packing level.
3698: CURSOR get_pack_ship_groups(v_batch_id in number) IS
3699: SELECT wsp.ship_confirm_rule_id, wsp.autopack_level
3700: FROM wsh_shipping_parameters wsp, wsh_delivery_details wdd
3701: WHERE wdd.batch_id = v_batch_id
3702: AND wsp.organization_id = wdd.organization_id
3703: GROUP BY wsp.ship_confirm_rule_id, wsp.autopack_level;
3704:

Line 3712: wsh_shipping_parameters wsp

3708: CURSOR get_dels_in_group(v_batch_id in number, v_sc_rule_id in number, v_ap_level in number) IS
3709: SELECT DISTINCT wda.delivery_id, wdd.organization_id,
3710: wdd.ship_from_location_id
3711: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd,
3712: wsh_shipping_parameters wsp
3713: WHERE wdd.batch_id = v_batch_id
3714: AND wdd.delivery_detail_id = wda.delivery_detail_id
3715: AND wdd.organization_id = wsp.organization_id
3716: AND NVL(wsp.ship_confirm_rule_id, 0) = NVL(v_sc_rule_id, 0)

Line 3885: wsh_shipping_parameters wsp

3881: SELECT DISTINCT wda.delivery_id
3882: FROM wsh_delivery_details wdd,
3883: wsh_delivery_assignments_v wda,
3884: wsh_new_deliveries wnd,
3885: wsh_shipping_parameters wsp
3886: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
3887: AND wdd.batch_id = l_batch_id
3888: AND wdd.released_status = 'Y'
3889: AND wda.delivery_id = wnd.delivery_id

Line 3952: from wsh_shipping_parameters wsp, wsh_tmp wt

3948: nvl(wpgr.end_date_active, trunc(sysdate)+1);
3949:
3950: CURSOR c_is_print_ps_mode_I IS
3951: select wsp.organization_id
3952: from wsh_shipping_parameters wsp, wsh_tmp wt
3953: where wt.id = wsp.organization_id
3954: and wsp.print_pick_slip_mode = 'I'
3955: and rownum = 1;
3956:

Line 3959: from wsh_shipping_parameters wsp

3955: and rownum = 1;
3956:
3957: CURSOR c_is_print_ps_mode_I_for_org(p_org_id NUMBER) IS
3958: select wsp.organization_id
3959: from wsh_shipping_parameters wsp
3960: where wsp.organization_id = p_org_id
3961: and wsp.print_pick_slip_mode = 'I';
3962:
3963: CURSOR c_prnt_PS_mode_PS_grp IS

Line 3965: from wsh_shipping_parameters wsp, wsh_tmp wt

3961: and wsp.print_pick_slip_mode = 'I';
3962:
3963: CURSOR c_prnt_PS_mode_PS_grp IS
3964: select wsp.organization_id
3965: from wsh_shipping_parameters wsp, wsh_tmp wt
3966: where wt.id = wsp.organization_id
3967: and (wsp.print_pick_slip_mode = 'I'
3968: OR exists
3969: (select '1'

Line 3979: from wsh_shipping_parameters wsp

3975: AND rownum = 1;
3976:
3977: CURSOR c_prnt_PS_mode_PS_grp_for_org (p_org_id NUMBER) IS
3978: select wsp.organization_id
3979: from wsh_shipping_parameters wsp
3980: where wsp.organization_id = p_org_id
3981: and (wsp.print_pick_slip_mode = 'I'
3982: OR exists
3983: (select '1'

Line 7141: from wsh_delivery_details d, wsh_shipping_parameters p

7137:
7138: --Cursor to validate auto packing.
7139: CURSOR check_detail_for_AP (c_batch_id IN NUMBER) IS
7140: select distinct p.organization_id
7141: from wsh_delivery_details d, wsh_shipping_parameters p
7142: where d.organization_id = p.organization_id
7143: and NVL(p.autopack_level,0) = 0
7144: and d.batch_id = c_batch_id;
7145:

Line 7151: from wsh_delivery_details d, wsh_shipping_parameters p, mtl_parameters m

7147: --Cursor to validate ship confirm.
7148: CURSOR check_detail_for_SC (c_batch_id IN NUMBER) IS
7149: select distinct p.organization_id, p.ship_confirm_rule_id,
7150: p.autocreate_deliveries_flag, m.mo_pick_confirm_required
7151: from wsh_delivery_details d, wsh_shipping_parameters p, mtl_parameters m
7152: where d.organization_id = p.organization_id and
7153: m.organization_id = d.organization_id
7154: and (ship_confirm_rule_id IS NULL
7155: or NVL(p.autocreate_deliveries_flag, 'N') <> 'Y'