eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_PICK_LIST dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 829: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_assignments_v wda,

825:
826: --Cursor to get the Trip stop id associated with the PickUp Stop of delivery detail line.
827: CURSOR get_dd_pup_trip_stop(v_org_id IN NUMBER, v_dd_id NUMBER) IS
828: SELECT wts.STOP_ID
829: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_assignments_v wda,
830: wsh_delivery_legs wdl, wsh_delivery_details wdd
831: WHERE wdd.delivery_detail_id = v_dd_id
832: AND wdd.organization_id = v_org_id
833: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 841: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda

837:
838: -- Workflow Change
839: CURSOR c_get_picked_lines_count (c_delivery_detail_id NUMBER) IS
840: SELECT count (wdd.delivery_detail_id), delivery_id
841: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
842: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
843: AND wda.delivery_id = ( SELECT delivery_id
844: FROM wsh_delivery_assignments_v
845: WHERE delivery_detail_id = c_delivery_detail_id )

Line 844: FROM wsh_delivery_assignments_v

840: SELECT count (wdd.delivery_detail_id), delivery_id
841: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
842: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
843: AND wda.delivery_id = ( SELECT delivery_id
844: FROM wsh_delivery_assignments_v
845: WHERE delivery_detail_id = c_delivery_detail_id )
846: AND wdd.released_status NOT IN ('R', 'X', 'N')
847: AND wdd.pickable_flag = 'Y'
848: AND wdd.container_flag = 'N'

Line 3711: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd,

3707: --Cursor to get delivery detail attributes for ship confirm rule and Packing level.
3708: CURSOR get_dels_in_group(v_batch_id in number, v_sc_rule_id in number, v_ap_level in number) IS
3709: SELECT DISTINCT wda.delivery_id, wdd.organization_id,
3710: wdd.ship_from_location_id
3711: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd,
3712: wsh_shipping_parameters wsp
3713: WHERE wdd.batch_id = v_batch_id
3714: AND wdd.delivery_detail_id = wda.delivery_detail_id
3715: AND wdd.organization_id = wsp.organization_id

Line 3724: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

3720: --Cursor to get delivery detail attributes for batch_id.
3721: CURSOR get_dels_in_batch(v_batch_id in number) IS
3722: SELECT DISTINCT wda.delivery_id, wdd.organization_id,
3723: wdd.ship_from_location_id
3724: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
3725: WHERE wdd.batch_id = v_batch_id
3726: AND wdd.delivery_detail_id = wda.delivery_detail_id
3727: AND NVL(wdd.LINE_DIRECTION , 'O') IN ('O', 'IO'); -- J Inbound Logistics
3728:

Line 3740: wsh_delivery_assignments_v wda,

3736: SELECT wdd.delivery_detail_id, wda.delivery_id, wda.parent_delivery_detail_id, wdd.organization_id,
3737: wdd.line_direction, wdd.gross_weight, wdd.net_weight, wdd.volume,
3738: wnd.planned_flag, wnd.batch_id
3739: FROM wsh_delivery_details wdd,
3740: wsh_delivery_assignments_v wda,
3741: wsh_new_deliveries wnd
3742: WHERE wdd.batch_id = l_batch_id
3743: AND wdd.delivery_detail_id = wda.delivery_detail_id
3744: AND wdd.released_status = 'B'

Line 3759: wsh_delivery_assignments_v wda

3755:
3756: CURSOR c_get_unassigned_details(l_batch_id NUMBER, l_organization_id NUMBER) IS
3757: SELECT wdd.delivery_detail_id
3758: FROM wsh_delivery_details wdd,
3759: wsh_delivery_assignments_v wda
3760: WHERE wdd.batch_id = l_batch_id
3761: AND wdd.released_status in ('S','Y')
3762: AND wdd.delivery_detail_id = wda.delivery_detail_id
3763: AND wdd.organization_id = l_organization_id

Line 3883: wsh_delivery_assignments_v wda,

3879:
3880: CURSOR c_batch_unplanned_del(l_batch_id NUMBER) IS
3881: SELECT DISTINCT wda.delivery_id
3882: FROM wsh_delivery_details wdd,
3883: wsh_delivery_assignments_v wda,
3884: wsh_new_deliveries wnd,
3885: wsh_shipping_parameters wsp
3886: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
3887: AND wdd.batch_id = l_batch_id

Line 7161: select 1 from wsh_delivery_assignments_v a, wsh_delivery_details d

7157: and d.batch_id = c_batch_id;
7158:
7159: --Cursor to check unassign delivery for an batch.
7160: CURSOR check_unassigned_dels(c_org_id IN NUMBER, c_batch_id IN NUMBER) IS
7161: select 1 from wsh_delivery_assignments_v a, wsh_delivery_details d
7162: where d.organization_id = c_org_id
7163: and d.batch_id = c_batch_id
7164: and d.delivery_detail_id = a.delivery_detail_id
7165: and a.delivery_id is null

Line 7178: FROM wsh_delivery_assignments wda,

7174: --OTM R12, this cursor is found if detail is not assigned to delivery
7175: --and include for planning
7176: CURSOR c_is_detail_assigned(p_detail_id IN NUMBER) IS
7177: SELECT 1
7178: FROM wsh_delivery_assignments wda,
7179: wsh_delivery_details wdd
7180: WHERE wda.delivery_detail_id = p_detail_id
7181: AND wda.delivery_detail_id = wdd.delivery_detail_id
7182: AND wda.delivery_id IS NULL