66: p_Employee_Id,
67: p_org_id,
68: p_device_id,
69: sysdate,
70: FND_GLOBAL.USER_ID,
71: sysdate,
72: FND_GLOBAL.USER_ID,
73: FND_GLOBAL.LOGIN_ID );
74:
68: p_device_id,
69: sysdate,
70: FND_GLOBAL.USER_ID,
71: sysdate,
72: FND_GLOBAL.USER_ID,
73: FND_GLOBAL.LOGIN_ID );
74:
75: l_wcs_enabled := wms_devices_pkg.is_wcs_enabled(P_ORG_ID);
76:
69: sysdate,
70: FND_GLOBAL.USER_ID,
71: sysdate,
72: FND_GLOBAL.USER_ID,
73: FND_GLOBAL.LOGIN_ID );
74:
75: l_wcs_enabled := wms_devices_pkg.is_wcs_enabled(P_ORG_ID);
76:
77: IF (l_wcs_enabled='Y') THEN
489: AND WBED.organization_id = WD.organization_id
490: AND wd.ENABLED_FLAG = 'Y'
491: AND decode (level_type, 200,wbed.subinventory_code,level_value) =
492: decode(level_type,200,p_subinventory,100,p_organization_id ,300, p_locator_id,400,
493: FND_GLOBAL.USER_ID,level_value)
494: AND Nvl(wbed.organization_id,-1) = Nvl(p_organization_id ,Nvl(wbed.organization_id ,-1))
495: --AND wbed.AUTO_ENABLED_FLAG = decode('Y','Y','Y','N')
496: AND wbed.business_event_id = wms_device_integration_pvt.wms_be_pick_load
497: ORDER BY level_type desc