[Home] [Help]
454:
455: CURSOR get_item_type(c_dtl_id IN NUMBER) IS
456: SELECT m.container_type_code
457: FROM mtl_system_items_b m ,
458: wsh_delivery_details d
459: WHERE d.inventory_item_id=m.inventory_item_id and
460: d.organization_id = m.organization_id and
461: d.delivery_detail_id=c_dtl_id;
462:
4770: da.parent_delivery_id,
4771: dl.parent_delivery_leg_id
4772: FROM wsh_delivery_assignments da,
4773: wsh_delivery_legs dl ,
4774: wsh_delivery_details dd,
4775: wsh_trip_stops s
4776: WHERE da.delivery_id=dl.delivery_id and
4777: dl.pick_up_stop_id=s.stop_id and
4778: s.trip_id = c_trip_id and
5273: da.parent_delivery_id,
5274: dl.parent_delivery_leg_id
5275: FROM wsh_delivery_assignments da,
5276: wsh_delivery_legs dl ,
5277: wsh_delivery_details dd
5278: WHERE da.delivery_id=dl.delivery_id and
5279: dl.pick_up_stop_id=c_pick_up_stop_id and
5280: da.delivery_detail_id = dd.delivery_detail_id and
5281: (
5335: da.parent_delivery_id,
5336: dl.parent_delivery_leg_id
5337: FROM wsh_delivery_assignments da,
5338: wsh_delivery_legs dl ,
5339: wsh_delivery_details dd
5340: WHERE da.delivery_id=dl.delivery_id and
5341: dl.drop_off_stop_id=c_drop_off_stop_id and
5342: da.delivery_detail_id = dd.delivery_detail_id and
5343: (
6805: null,--MDC columns
6806: null,--MDC columns
6807: null--MDC columns
6808: FROM wsh_delivery_assignments da,
6809: wsh_delivery_details dd
6810: WHERE da.delivery_id=c_delivery_id and
6811: da.parent_delivery_detail_id is null and
6812: da.delivery_detail_id = dd.delivery_detail_id;
6813:
11735: da.parent_delivery_id,
11736: dl.parent_delivery_leg_id
11737: FROM wsh_delivery_assignments da,
11738: wsh_delivery_legs dl ,
11739: wsh_delivery_details dd,
11740: wsh_trip_stops s
11741: WHERE da.delivery_id=dl.delivery_id and
11742: s.trip_id=c_trip_id and
11743: dl.pick_up_stop_id=s.stop_id and