DBA Data[Home] [Help]

APPS.WSH_WSHRDMBL_XMLP_PKG dependencies on WSH_SHIP_FROM_ORGS_V

Line 10: WSH_SHIP_FROM_ORGS_V WSFO,

6: SELECT
7: ORGANIZATION_NAME
8: INTO L_SHIPPER_NAME
9: FROM
10: WSH_SHIP_FROM_ORGS_V WSFO,
11: WSH_TRIP_STOPS WTS
12: WHERE TRIP_ID = P_TRIP_ID
13: AND WTS.STOP_LOCATION_ID = WSFO.LOCATION_ID
14: AND WTS.STOP_SEQUENCE_NUMBER = (

Line 31: WSH_SHIP_FROM_ORGS_V WSFO,

27: DISTINCT
28: ORGANIZATION_NAME
29: INTO L_SHIPPER_NAME
30: FROM
31: WSH_SHIP_FROM_ORGS_V WSFO,
32: WSH_TRIP_STOPS WTS,
33: WSH_NEW_DELIVERIES WND,
34: WSH_DELIVERY_LEGS WDL
35: WHERE WTS.TRIP_ID = P_TRIP_ID