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 10669: FROM wsh_delivery_assignments_v wda

10665: lpn_pjm_prj_tsk_rec pjm_rectype;
10666:
10667: CURSOR others_in_mmtt_delivery_cursor(l_lpn_id IN NUMBER) IS
10668: SELECT wda.delivery_id
10669: FROM wsh_delivery_assignments_v wda
10670: , wsh_delivery_details_ob_grp_v wdd
10671: , mtl_material_transactions_temp mmtt
10672: WHERE mmtt.transfer_lpn_id = l_lpn_id
10673: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 10688: FROM wsh_delivery_assignments_v wda

10684: child_lpns_rec child_lpns_cursor%ROWTYPE;
10685:
10686: CURSOR current_delivery_cursor IS
10687: SELECT wda.delivery_id
10688: FROM wsh_delivery_assignments_v wda
10689: , wsh_delivery_details_ob_grp_v wdd
10690: , mtl_material_transactions_temp mmtt
10691: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
10692: AND wdd.move_order_line_id = mmtt.move_order_line_id

Line 10699: FROM wsh_delivery_assignments_v wda

10695: AND mmtt.organization_id = p_organization_id;
10696:
10697: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
10698: SELECT wda.delivery_id
10699: FROM wsh_delivery_assignments_v wda
10700: , wsh_delivery_details_ob_grp_v wdd
10701: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
10702: AND wdd.lpn_id = l_lpn_id
10703: AND wdd.organization_id = p_organization_id