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.

[Home] [Help]

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 11583: , wsh_delivery_assignments_v wda

11579: SELECT COUNT(wdd2.lpn_id)
11580: INTO l_shipped_wdd_count_in_lpn
11581: FROM wsh_delivery_details wdd1
11582: , wsh_delivery_details wdd2
11583: , wsh_delivery_assignments_v wda
11584: , wms_license_plate_numbers wlpn
11585: WHERE wdd1.released_status = 'C'
11586: AND wda.delivery_detail_id = wdd1.delivery_detail_id
11587: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id

Line 15283: FROM wsh_delivery_assignments wda,

15279: AND organization_id = p_organization_id;
15280:
15281: CURSOR pick_delivery_cursor IS
15282: SELECT wda.delivery_id
15283: FROM wsh_delivery_assignments wda,
15284: wsh_delivery_details wdd,
15285: mtl_material_transactions_temp temp
15286: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
15287: AND wdd.move_order_line_id = temp.move_order_line_id

Line 15294: FROM wsh_delivery_assignments wda,

15290: AND temp.organization_id = p_organization_id ;
15291:
15292: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
15293: SELECT wda.delivery_id
15294: FROM wsh_delivery_assignments wda,
15295: wsh_delivery_details wdd,
15296: wms_license_plate_numbers lpn
15297: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
15298: AND wdd.lpn_id = lpn.lpn_id

Line 15541: FROM wsh_delivery_assignments wda,

15537:
15538:
15539: CURSOR pick_delivery_cursor IS
15540: SELECT wda.delivery_id
15541: FROM wsh_delivery_assignments wda,
15542: wsh_delivery_details wdd,
15543: mtl_material_transactions_temp temp
15544: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
15545: AND wdd.move_order_line_id = temp.move_order_line_id

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

15550: CURSOR drop_delivery_cursor (l_delivery_id_c IN NUMBER,
15551: l_drop_sub_c IN VARCHAR2,
15552: l_drop_loc_c IN NUMBER ) IS
15553: --Bug Fix 4622935 Added hint as suggested by Ben Chihaoui
15554: SELECT /*+ index(wda WSH_DELIVERY_ASSIGNMENTS_N1) ORDERED USE_NL (WDA WDD WLPN) */ wlpn.outermost_lpn_id
15555: FROM wsh_delivery_assignments wda,
15556: wsh_delivery_details wdd,
15557: wms_license_plate_numbers wlpn
15558: WHERE wda.delivery_id = l_delivery_id_c

Line 15555: FROM wsh_delivery_assignments wda,

15551: l_drop_sub_c IN VARCHAR2,
15552: l_drop_loc_c IN NUMBER ) IS
15553: --Bug Fix 4622935 Added hint as suggested by Ben Chihaoui
15554: SELECT /*+ index(wda WSH_DELIVERY_ASSIGNMENTS_N1) ORDERED USE_NL (WDA WDD WLPN) */ wlpn.outermost_lpn_id
15555: FROM wsh_delivery_assignments wda,
15556: wsh_delivery_details wdd,
15557: wms_license_plate_numbers wlpn
15558: WHERE wda.delivery_id = l_delivery_id_c
15559: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id