APPS.WSH_UTIL_CORE dependencies on MTL_PARAMETERS

Line 645: FROM mtl_parameters

641: IS
642:
643: CURSOR c_get_master_from_org(c_org_id IN NUMBER) IS
644: SELECT master_organization_id
645: FROM mtl_parameters
646: WHERE organization_id = c_org_id;
647:
648: org_not_found EXCEPTION;
649:

Line 692: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:org in mtl_parameters not found');

688: WHEN org_not_found THEN
689: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
690: --
691: IF l_debug_on THEN
692: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:org in mtl_parameters not found');
693: END IF;
694: --
695: WHEN others THEN
696: IF c_get_master_from_org%ISOPEN THEN

Line 3403: mtl_parameters mp

3399: CURSOR get_delivery_wms(x_delivery_id NUMBER) IS
3400: SELECT mp.wms_enabled_flag,
3401: wnd.delivery_id
3402: FROM wsh_new_deliveries wnd,
3403: mtl_parameters mp
3404: WHERE wnd.delivery_id = x_delivery_id AND
3405: mp.organization_id = wnd.organization_id AND
3406: mp.wms_enabled_flag = 'Y';
3407:

Line 3417: mtl_parameters mp

3413: mp.wms_enabled_flag
3414: FROM wsh_new_deliveries dl,
3415: wsh_delivery_legs dg,
3416: wsh_trip_stops st,
3417: mtl_parameters mp
3418: WHERE dg.delivery_id = dl.delivery_id AND
3419: nvl(dl.SHIPMENT_DIRECTION, 'O') IN ('O', 'IO') AND -- J Inbound Logistics jckwok
3420: st.stop_location_id = dl.initial_pickup_location_id AND
3421: st.stop_id = dg.pick_up_stop_id AND

Line 8103: FROM hr_organization_units hou,mtl_parameters mp

8099: THEN
8100: -- outbound or mixed use first stop location id
8101: SELECT mp. organization_id
8102: INTO l_organization_id
8103: FROM hr_organization_units hou,mtl_parameters mp
8104: WHERE hou.organization_id = mp.organization_id
8105: AND hou.location_id = l_first_stop_loc_id
8106: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
8107: ELSE

Line 8111: FROM hr_organization_units hou,mtl_parameters mp

8107: ELSE
8108: -- inbound so use last stop
8109: SELECT mp. organization_id
8110: INTO l_organization_id
8111: FROM hr_organization_units hou,mtl_parameters mp
8112: WHERE hou.organization_id = mp.organization_id
8113: AND hou.location_id = l_last_stop_loc_id
8114: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
8115: END IF;