APPS.INV_PICK_RELEASE_PUB dependencies on WSH_SHIPPING_PARAMETERS

Line 434: FROM wsh_shipping_parameters -- Bug 16309114 changed from wsh_parameters

430: IF l_grouping_rule_id IS NULL THEN
431: BEGIN
432: SELECT pick_grouping_rule_id
433: INTO l_grouping_rule_id
434: FROM wsh_shipping_parameters -- Bug 16309114 changed from wsh_parameters
435: WHERE organization_id = l_organization_id;
436: EXCEPTION
437: WHEN no_data_found THEN
438: ROLLBACK TO Assign_pick_slip;

Line 1464: FROM WSH_SHIPPING_PARAMETERS

1460:
1461: BEGIN
1462: SELECT print_pick_slip_mode, pick_grouping_rule_id
1463: INTO l_print_mode, g_org_grouping_rule_id
1464: FROM WSH_SHIPPING_PARAMETERS
1465: WHERE organization_id = l_organization_id;
1466: EXCEPTION
1467: WHEN no_data_found THEN
1468: If is_debug then

Line 1631: FROM wsh_shipping_parameters

1627: Else
1628: BEGIN
1629: SELECT pick_grouping_rule_id
1630: INTO l_grouping_rule_id
1631: FROM wsh_shipping_parameters
1632: WHERE organization_id = l_organization_id;
1633: EXCEPTION
1634: WHEN no_data_found THEN
1635: If is_debug then

Line 3904: FROM WSH_SHIPPING_PARAMETERS

3900:
3901: BEGIN
3902: SELECT print_pick_slip_mode, pick_grouping_rule_id
3903: INTO l_print_mode, g_org_grouping_rule_id
3904: FROM WSH_SHIPPING_PARAMETERS
3905: WHERE organization_id = p_org_id;
3906: EXCEPTION
3907: WHEN no_data_found THEN
3908: If is_debug then