DBA Data[Home] [Help]

APPS.WSH_ITM_PKG dependencies on WSH_EXCEPTIONS

Line 135: FROM WSH_EXCEPTIONS WE ,

131: l_exception_id,
132: l_event_name,
133: l_old_status,
134: l_organization_id
135: FROM WSH_EXCEPTIONS WE ,
136: WSH_ITM_REQUEST_CONTROL IRC
137: WHERE WE.DELIVERY_ID = IRC.ORIGINAL_SYSTEM_REFERENCE
138: AND WE.EXCEPTION_NAME = DECODE(IRC.TRIGGERING_POINT,G_PICK_RELEASE_EVENT,G_SUB_PICK_RELEASE_EXCEPTION,G_SHIP_CONFIRM_EVENT,G_SUB_SHIP_CONFIRM_EXCEPTION)
139: AND IRC.REQUEST_CONTROL_ID = P_REQUEST_CONTROL_ID