APPS.WSH_UTIL_CORE dependencies on MTL_PARAMETERS

Line 653: FROM mtl_parameters

649: IS
650:
651: CURSOR c_get_master_from_org(c_org_id IN NUMBER) IS
652: SELECT master_organization_id
653: FROM mtl_parameters
654: WHERE organization_id = c_org_id;
655:
656: org_not_found EXCEPTION;
657:

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

696: WHEN org_not_found THEN
697: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
698: --
699: IF l_debug_on THEN
700: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:org in mtl_parameters not found');
701: END IF;
702: --
703: WHEN others THEN
704: IF c_get_master_from_org%ISOPEN THEN

Line 3439: mtl_parameters mp

3435: CURSOR get_delivery_wms(x_delivery_id NUMBER) IS
3436: SELECT mp.wms_enabled_flag,
3437: wnd.delivery_id
3438: FROM wsh_new_deliveries wnd,
3439: mtl_parameters mp
3440: WHERE wnd.delivery_id = x_delivery_id AND
3441: mp.organization_id = wnd.organization_id AND
3442: mp.wms_enabled_flag = 'Y';
3443:

Line 3453: mtl_parameters mp

3449: mp.wms_enabled_flag
3450: FROM wsh_new_deliveries dl,
3451: wsh_delivery_legs dg,
3452: wsh_trip_stops st,
3453: mtl_parameters mp
3454: WHERE dg.delivery_id = dl.delivery_id AND
3455: nvl(dl.SHIPMENT_DIRECTION, 'O') IN ('O', 'IO') AND -- J Inbound Logistics jckwok
3456: st.stop_location_id = dl.initial_pickup_location_id AND
3457: st.stop_id = dg.pick_up_stop_id AND

Line 8139: FROM hr_organization_units hou,mtl_parameters mp

8135: THEN
8136: -- outbound or mixed use first stop location id
8137: SELECT mp. organization_id
8138: INTO l_organization_id
8139: FROM hr_organization_units hou,mtl_parameters mp
8140: WHERE hou.organization_id = mp.organization_id
8141: AND hou.location_id = l_first_stop_loc_id
8142: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
8143: ELSE

Line 8147: FROM hr_organization_units hou,mtl_parameters mp

8143: ELSE
8144: -- inbound so use last stop
8145: SELECT mp. organization_id
8146: INTO l_organization_id
8147: FROM hr_organization_units hou,mtl_parameters mp
8148: WHERE hou.organization_id = mp.organization_id
8149: AND hou.location_id = l_last_stop_loc_id
8150: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
8151: END IF;