DBA Data[Home] [Help]

APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on WSH_TRIP_STOPS

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

1726: FROM mtl_secondary_inventories msub
1727: WHERE msub.organization_id = p_organization_id
1728: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1729: AND EXISTS( SELECT wda.staging_lane_id
1730: FROM wms_dock_appointments_b wda, mtl_item_locations milk, wsh_trip_stops pickup_stop
1731: WHERE milk.inventory_location_id(+) = wda.staging_lane_id
1732: AND milk.organization_id(+) = wda.organization_id
1733: AND milk.organization_id = p_organization_id
1734: AND milk.subinventory_code = msub.secondary_inventory_name