DBA Data[Home] [Help]

APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on WSH_NEW_DELIVERIES

Line 90: WSH_NEW_DELIVERIES WND,

86: cursor l_stop_dd_org_csr(p_stop_id IN NUMBER) is
87: SELECT HOU.ORGANIZATION_ID
88: FROM HR_ALL_ORGANIZATION_UNITS HOU,
89: WSH_LOCATIONS WL,
90: WSH_NEW_DELIVERIES WND,
91: WSH_DELIVERY_LEGS WDL,
92: WSH_TRIP_STOPS WTS
93: WHERE WTS.STOP_ID = p_stop_id
94: AND HOU.LOCATION_ID = WL.SOURCE_LOCATION_ID

Line 120: WSH_NEW_DELIVERIES WND,

116: FROM HZ_CUST_ACCOUNTS HCA,
117: HZ_PARTIES HP,
118: HZ_PARTY_SITES HPS,
119: WSH_LOCATIONS WL,
120: WSH_NEW_DELIVERIES WND,
121: WSH_DELIVERY_LEGS WDL,
122: WSH_TRIP_STOPS WTS,
123: WSH_DELIVERY_ASSIGNMENTS WDA,
124: WSH_DELIVERY_DETAILS WDD

Line 267: FROM WSH_NEW_DELIVERIES WND,

263: WLT1.LOCATION_ID WLT1_ST_LOC_ID,
264: WLT1.CORPORATION_ID WLT1_CUST_ID,
265: WLT2.LOCATION_ID WLT2_SF_LOC_ID,
266: WLT2.CORPORATION_ID WLT2_ORG_ID
267: FROM WSH_NEW_DELIVERIES WND,
268: WSH_OTM_LOCATIONS_GTMP WLT1,
269: WSH_OTM_LOCATIONS_GTMP WLT2
270: WHERE WND.DELIVERY_ID = p_delivery_id
271: AND WND.ULTIMATE_DROPOFF_LOCATION_ID = WLT1.LOCATION_ID (+)