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.WMS_TASK_DISPATCH_GEN dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 7979: FROM wsh_delivery_assignments_v wda

7975: lpn_pjm_prj_tsk_rec pjm_rectype;
7976:
7977: CURSOR others_in_mmtt_delivery_cursor(l_lpn_id IN NUMBER) IS
7978: SELECT wda.delivery_id
7979: FROM wsh_delivery_assignments_v wda
7980: , wsh_delivery_details wdd
7981: , mtl_material_transactions_temp mmtt
7982: WHERE mmtt.transfer_lpn_id = l_lpn_id
7983: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 8004: FROM wsh_delivery_assignments_v wda

8000: child_lpns_rec child_lpns_cursor%ROWTYPE;
8001:
8002: CURSOR current_delivery_cursor IS
8003: SELECT wda.delivery_id
8004: FROM wsh_delivery_assignments_v wda
8005: , wsh_delivery_details wdd
8006: , mtl_material_transactions_temp mmtt
8007: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
8008: AND wdd.move_order_line_id = mmtt.move_order_line_id

Line 8015: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

8011: AND mmtt.organization_id = p_organization_id;
8012:
8013: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
8014: SELECT wda.delivery_id
8015: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
8016: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
8017: AND wdd.lpn_id = l_lpn_id
8018: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
8019: AND wdd.organization_id = p_organization_id;

Line 11720: , wsh_delivery_assignments_v wda

11716: SELECT COUNT(wdd2.lpn_id)
11717: INTO l_open_wdd_count_in_lpn
11718: FROM wsh_delivery_details wdd1
11719: , wsh_delivery_details wdd2
11720: , wsh_delivery_assignments_v wda
11721: , wms_license_plate_numbers wlpn
11722: WHERE wdd2.released_status = 'X'
11723: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id
11724: AND wda.delivery_detail_id = wdd1.delivery_detail_id

Line 11732: , wsh_delivery_assignments_v wda

11728: SELECT COUNT(wdd2.lpn_id)
11729: INTO l_shipped_wdd_count_in_lpn
11730: FROM wsh_delivery_details wdd1
11731: , wsh_delivery_details wdd2
11732: , wsh_delivery_assignments_v wda
11733: , wms_license_plate_numbers wlpn
11734: WHERE wdd1.released_status = 'C'
11735: AND wda.delivery_detail_id = wdd1.delivery_detail_id
11736: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id

Line 15683: FROM wsh_delivery_assignments wda,

15679: AND organization_id = p_organization_id;
15680:
15681: CURSOR pick_delivery_cursor IS
15682: SELECT wda.delivery_id
15683: FROM wsh_delivery_assignments wda,
15684: wsh_delivery_details wdd,
15685: mtl_material_transactions_temp temp
15686: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
15687: AND wdd.move_order_line_id = temp.move_order_line_id

Line 15694: FROM wsh_delivery_assignments wda,

15690: AND temp.organization_id = p_organization_id ;
15691:
15692: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
15693: SELECT wda.delivery_id
15694: FROM wsh_delivery_assignments wda,
15695: wsh_delivery_details wdd,
15696: wms_license_plate_numbers lpn
15697: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
15698: AND wdd.lpn_id = lpn.lpn_id

Line 15941: FROM wsh_delivery_assignments wda,

15937:
15938:
15939: CURSOR pick_delivery_cursor IS
15940: SELECT wda.delivery_id
15941: FROM wsh_delivery_assignments wda,
15942: wsh_delivery_details wdd,
15943: mtl_material_transactions_temp temp
15944: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
15945: AND wdd.move_order_line_id = temp.move_order_line_id

Line 15954: SELECT /+ index(wda WSH_DELIVERY_ASSIGNMENTS_N1) ORDERED USE_NL (WDA WDD WLPN) / wlpn.outermost_lpn_id

15950: CURSOR drop_delivery_cursor (l_delivery_id_c IN NUMBER,
15951: l_drop_sub_c IN VARCHAR2,
15952: l_drop_loc_c IN NUMBER ) IS
15953: --Bug Fix 4622935 Added hint as suggested by Ben Chihaoui
15954: SELECT /*+ index(wda WSH_DELIVERY_ASSIGNMENTS_N1) ORDERED USE_NL (WDA WDD WLPN) */ wlpn.outermost_lpn_id
15955: FROM wsh_delivery_assignments wda,
15956: wsh_delivery_details wdd,
15957: wms_license_plate_numbers wlpn
15958: WHERE wda.delivery_id = l_delivery_id_c

Line 15955: FROM wsh_delivery_assignments wda,

15951: l_drop_sub_c IN VARCHAR2,
15952: l_drop_loc_c IN NUMBER ) IS
15953: --Bug Fix 4622935 Added hint as suggested by Ben Chihaoui
15954: SELECT /*+ index(wda WSH_DELIVERY_ASSIGNMENTS_N1) ORDERED USE_NL (WDA WDD WLPN) */ wlpn.outermost_lpn_id
15955: FROM wsh_delivery_assignments wda,
15956: wsh_delivery_details wdd,
15957: wms_license_plate_numbers wlpn
15958: WHERE wda.delivery_id = l_delivery_id_c
15959: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id