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_LOAD dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 12965: FROM wsh_delivery_assignments_v wda

12961: lpn_pjm_prj_tsk_rec pjm_rectype;
12962:
12963: CURSOR others_in_mmtt_delivery_cursor(l_lpn_id IN NUMBER) IS
12964: SELECT wda.delivery_id
12965: FROM wsh_delivery_assignments_v wda
12966: , wsh_delivery_details_ob_grp_v wdd
12967: , mtl_material_transactions_temp mmtt
12968: WHERE mmtt.transfer_lpn_id = l_lpn_id
12969: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 12984: FROM wsh_delivery_assignments_v wda

12980: child_lpns_rec child_lpns_cursor%ROWTYPE;
12981:
12982: CURSOR current_delivery_cursor IS
12983: SELECT wda.delivery_id
12984: FROM wsh_delivery_assignments_v wda
12985: , wsh_delivery_details_ob_grp_v wdd
12986: , mtl_material_transactions_temp mmtt
12987: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
12988: AND wdd.move_order_line_id = mmtt.move_order_line_id

Line 12995: FROM wsh_delivery_assignments_v wda

12991: AND mmtt.organization_id = p_organization_id;
12992:
12993: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
12994: SELECT wda.delivery_id
12995: FROM wsh_delivery_assignments_v wda
12996: , wsh_delivery_details_ob_grp_v wdd
12997: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
12998: AND wdd.lpn_id = l_lpn_id
12999: AND wdd.organization_id = p_organization_id