DBA Data[Home] [Help]

APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on WSH_TRIP_STOPS

Line 2105: FROM wms_dock_appointments_b wda, mtl_item_locations milk, wsh_trip_stops pickup_stop

2101: FROM mtl_secondary_inventories msub
2102: WHERE msub.organization_id = p_organization_id
2103: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2104: AND EXISTS( SELECT wda.staging_lane_id
2105: FROM wms_dock_appointments_b wda, mtl_item_locations milk, wsh_trip_stops pickup_stop
2106: WHERE milk.inventory_location_id(+) = wda.staging_lane_id
2107: AND milk.organization_id(+) = wda.organization_id
2108: AND milk.organization_id = p_organization_id
2109: AND milk.subinventory_code = msub.secondary_inventory_name