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_V

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

810:
811: --Cursor to get the Trip stop id associated with the PickUp Stop of delivery detail line.
812: CURSOR get_dd_pup_trip_stop(v_org_id IN NUMBER, v_dd_id NUMBER) IS
813: SELECT wts.STOP_ID
814: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_assignments_v wda,
815: wsh_delivery_legs wdl, wsh_delivery_details wdd
816: WHERE wdd.delivery_detail_id = v_dd_id
817: AND wdd.organization_id = v_org_id
818: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 826: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda

822:
823: -- Workflow Change
824: CURSOR c_get_picked_lines_count (c_delivery_detail_id NUMBER) IS
825: SELECT count (wdd.delivery_detail_id), delivery_id
826: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
827: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
828: AND wda.delivery_id = ( SELECT delivery_id
829: FROM wsh_delivery_assignments_v
830: WHERE delivery_detail_id = c_delivery_detail_id )

Line 829: FROM wsh_delivery_assignments_v

825: SELECT count (wdd.delivery_detail_id), delivery_id
826: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
827: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
828: AND wda.delivery_id = ( SELECT delivery_id
829: FROM wsh_delivery_assignments_v
830: WHERE delivery_detail_id = c_delivery_detail_id )
831: AND wdd.released_status NOT IN ('R', 'X', 'N')
832: AND wdd.pickable_flag = 'Y'
833: AND wdd.container_flag = 'N'

Line 3623: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd,

3619: --Cursor to get delivery detail attributes for ship confirm rule and Packing level.
3620: CURSOR get_dels_in_group(v_batch_id in number, v_sc_rule_id in number, v_ap_level in number) IS
3621: SELECT DISTINCT wda.delivery_id, wdd.organization_id,
3622: wdd.ship_from_location_id
3623: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd,
3624: wsh_shipping_parameters wsp
3625: WHERE wdd.batch_id = v_batch_id
3626: AND wdd.delivery_detail_id = wda.delivery_detail_id
3627: AND wdd.organization_id = wsp.organization_id

Line 3636: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

3632: --Cursor to get delivery detail attributes for batch_id.
3633: CURSOR get_dels_in_batch(v_batch_id in number) IS
3634: SELECT DISTINCT wda.delivery_id, wdd.organization_id,
3635: wdd.ship_from_location_id
3636: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
3637: WHERE wdd.batch_id = v_batch_id
3638: AND wdd.delivery_detail_id = wda.delivery_detail_id
3639: AND NVL(wdd.LINE_DIRECTION , 'O') IN ('O', 'IO'); -- J Inbound Logistics
3640:

Line 3652: wsh_delivery_assignments_v wda,

3648: SELECT wdd.delivery_detail_id, wda.delivery_id, wda.parent_delivery_detail_id, wdd.organization_id,
3649: wdd.line_direction, wdd.gross_weight, wdd.net_weight, wdd.volume,
3650: wnd.planned_flag, wnd.batch_id
3651: FROM wsh_delivery_details wdd,
3652: wsh_delivery_assignments_v wda,
3653: wsh_new_deliveries wnd
3654: WHERE wdd.batch_id = l_batch_id
3655: AND wdd.delivery_detail_id = wda.delivery_detail_id
3656: AND wdd.released_status = 'B'

Line 3671: wsh_delivery_assignments_v wda

3667:
3668: CURSOR c_get_unassigned_details(l_batch_id NUMBER, l_organization_id NUMBER) IS
3669: SELECT wdd.delivery_detail_id
3670: FROM wsh_delivery_details wdd,
3671: wsh_delivery_assignments_v wda
3672: WHERE wdd.batch_id = l_batch_id
3673: AND wdd.released_status in ('S','Y')
3674: AND wdd.delivery_detail_id = wda.delivery_detail_id
3675: AND wdd.organization_id = l_organization_id

Line 3795: wsh_delivery_assignments_v wda,

3791:
3792: CURSOR c_batch_unplanned_del(l_batch_id NUMBER) IS
3793: SELECT DISTINCT wda.delivery_id
3794: FROM wsh_delivery_details wdd,
3795: wsh_delivery_assignments_v wda,
3796: wsh_new_deliveries wnd,
3797: wsh_shipping_parameters wsp
3798: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
3799: AND wdd.batch_id = l_batch_id

Line 7019: select 1 from wsh_delivery_assignments_v a, wsh_delivery_details d

7015: and d.batch_id = c_batch_id;
7016:
7017: --Cursor to check unassign delivery for an batch.
7018: CURSOR check_unassigned_dels(c_org_id IN NUMBER, c_batch_id IN NUMBER) IS
7019: select 1 from wsh_delivery_assignments_v a, wsh_delivery_details d
7020: where d.organization_id = c_org_id
7021: and d.batch_id = c_batch_id
7022: and d.delivery_detail_id = a.delivery_detail_id
7023: and a.delivery_id is null