APPS.WMS_WAVE_PLANNING_PVT dependencies on WSH_SHIPPING_PARAMETERS

Line 2429: FROM WSH_SHIPPING_PARAMETERS

2425: default_stage_locator_id
2426: INTO g_enforce_ship_set_and_smc,
2427: g_default_stage_subinventory,
2428: g_default_stage_locator_id
2429: FROM WSH_SHIPPING_PARAMETERS
2430: WHERE ORGANIZATION_ID = p_organization_id;
2431:
2432:
2433: --g_from_subinventory := nvl(Pick from subinventory given in Planning criteria, g_pick_subinventory);

Line 12279: FROM WSH_SHIPPING_PARAMETERS

12275: DEFAULT_STAGE_SUBINVENTORY,
12276: DEFAULT_STAGE_LOCATOR_ID,
12277: PICK_SEQUENCE_RULE_ID,
12278: PICK_GROUPING_RULE_ID
12279: FROM WSH_SHIPPING_PARAMETERS
12280: WHERE ORGANIZATION_ID = org_id;
12281:
12282: cursor c_get_wave_parameters is
12283: SELECT restrictions.PARAMETER_ID,

Line 13054: FROM WSH_SHIPPING_PARAMETERS WSP

13050: V_CURSOR_FLAG := 'Y';
13051:
13052: SELECT enforce_ship_set_and_smc
13053: INTO g_enforce_ship_set_and_smc
13054: FROM WSH_SHIPPING_PARAMETERS WSP
13055: WHERE WSP.ORGANIZATION_ID = p_organization_id;
13056:
13057:
13058:

Line 14102: FROM wsh_shipping_parameters

14098: SELECT uom_code
14099: into v_weight_uom
14100: FROM mtl_units_of_measure_vl
14101: WHERE uom_class = (SELECT weight_uom_class
14102: FROM wsh_shipping_parameters
14103: WHERE organization_id = p_orgid)
14104: AND base_uom_flag = 'Y';
14105:
14106: for l_uom in c_uom loop

Line 14147: FROM wsh_shipping_parameters

14143: SELECT uom_code
14144: into v_volume_uom
14145: FROM mtl_units_of_measure_vl
14146: WHERE uom_class = (SELECT volume_uom_class
14147: FROM wsh_shipping_parameters
14148: WHERE organization_id = p_orgid)
14149: AND base_uom_flag = 'Y';
14150:
14151: for l_uom in c_uom loop

Line 14206: FROM wsh_shipping_parameters

14202: SELECT uom_code
14203: into v_weight_uom
14204: FROM mtl_units_of_measure_vl
14205: WHERE uom_class = (SELECT weight_uom_class
14206: FROM wsh_shipping_parameters
14207: WHERE organization_id = p_orgid)
14208: AND base_uom_flag = 'Y';
14209:
14210: SELECT uom_code

Line 14214: FROM wsh_shipping_parameters

14210: SELECT uom_code
14211: into v_volume_uom
14212: FROM mtl_units_of_measure_vl
14213: WHERE uom_class = (SELECT volume_uom_class
14214: FROM wsh_shipping_parameters
14215: WHERE organization_id = p_orgid)
14216: AND base_uom_flag = 'Y';
14217:
14218: for l_uom in c_uom loop