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

Line 7745: wsh_delivery_assignments_v wda --added

7741: , mtl_txn_request_headers moh
7742: , -- mtl_system_items msi -- bug 2648133
7743: wsh_delivery_details_ob_grp_v wdd
7744: , -- added
7745: wsh_delivery_assignments_v wda --added
7746: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
7747: AND wdtv.organization_id = p_sign_on_org_id
7748: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
7749: AND mol.header_id = moh.header_id

Line 8066: wsh_delivery_assignments_v wda --added

8062: , mtl_txn_request_headers moh
8063: , -- mtl_system_items msi -- bug 2648133
8064: wsh_delivery_details_ob_grp_v wdd
8065: , -- added
8066: wsh_delivery_assignments_v wda --added
8067: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
8068: AND wdtv.organization_id = p_sign_on_org_id
8069: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
8070: AND mol.header_id = moh.header_id

Line 8355: wsh_delivery_assignments_v wda --added

8351: , mtl_txn_request_headers moh
8352: , -- mtl_system_items msi -- bug 2648133
8353: wsh_delivery_details_ob_grp_v wdd
8354: , -- added
8355: wsh_delivery_assignments_v wda --added
8356: WHERE wdt.transaction_temp_id = qt.task_id
8357: AND wdt.status in ( 2,3) -- Queued and dispatched tasks only bug 4310093
8358: AND wdt.person_id = p_sign_on_emp_id
8359: AND wdt.organization_id = p_sign_on_org_id

Line 8462: wsh_delivery_assignments_v wda --added

8458: , mtl_txn_request_headers moh
8459: , -- mtl_system_items msi -- bug 2648133
8460: wsh_delivery_details_ob_grp_v wdd
8461: , -- added
8462: wsh_delivery_assignments_v wda --added
8463: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
8464: AND wdtv.organization_id = p_sign_on_org_id
8465: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
8466: AND mol.header_id = moh.header_id

Line 8827: wsh_delivery_assignments_v wda --added

8823: , mtl_txn_request_headers moh
8824: , -- mtl_system_items msi -- bug 2648133
8825: wsh_delivery_details_ob_grp_v wdd
8826: , -- added
8827: wsh_delivery_assignments_v wda --added
8828: WHERE wdt.transaction_temp_id = qt.task_id
8829: AND wdt.status in ( 2,3) -- Queued and dispatched tasks only bug 4310093
8830: AND wdt.person_id = p_sign_on_emp_id
8831: AND wdt.organization_id = p_sign_on_org_id

Line 8934: wsh_delivery_assignments_v wda --added

8930: , mtl_txn_request_headers moh
8931: , -- mtl_system_items msi -- bug 2648133
8932: wsh_delivery_details_ob_grp_v wdd
8933: , -- added
8934: wsh_delivery_assignments_v wda --added
8935: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
8936: AND wdtv.organization_id = p_sign_on_org_id
8937: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
8938: AND mol.header_id = moh.header_id

Line 9291: wsh_delivery_assignments_v wda --added

9287: , mtl_txn_request_headers moh
9288: , -- mtl_system_items msi -- bug 2648133
9289: wsh_delivery_details_ob_grp_v wdd
9290: , -- added
9291: wsh_delivery_assignments_v wda --added
9292: WHERE wdt.transaction_temp_id = qt.task_id
9293: AND wdt.status in( 2,3) -- Queued and dispatched tasks only bug 4310093
9294: AND wdt.person_id = p_sign_on_emp_id
9295: AND wdt.organization_id = p_sign_on_org_id

Line 9396: wsh_delivery_assignments_v wda --added

9392: , mtl_txn_request_headers moh
9393: , -- mtl_system_items msi -- bug 2648133
9394: wsh_delivery_details_ob_grp_v wdd
9395: , -- added
9396: wsh_delivery_assignments_v wda --added
9397: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
9398: AND wdtv.organization_id = p_sign_on_org_id
9399: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
9400: AND mol.header_id = moh.header_id

Line 9755: wsh_delivery_assignments_v wda --added

9751: , mtl_txn_request_headers moh
9752: , -- mtl_system_items msi -- bug 2648133
9753: wsh_delivery_details_ob_grp_v wdd
9754: , -- added
9755: wsh_delivery_assignments_v wda --added
9756: WHERE wdt.transaction_temp_id = qt.task_id
9757: AND wdt.status in ( 2,3) -- Queued and dispatched tasks only bug 4310093
9758: AND wdt.person_id = p_sign_on_emp_id
9759: AND wdt.organization_id = p_sign_on_org_id

Line 9860: wsh_delivery_assignments_v wda --added

9856: , mtl_txn_request_headers moh
9857: , -- mtl_system_items msi -- bug 2648133
9858: wsh_delivery_details_ob_grp_v wdd
9859: , -- added
9860: wsh_delivery_assignments_v wda --added
9861: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
9862: AND wdtv.organization_id = p_sign_on_org_id
9863: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
9864: AND mol.header_id = moh.header_id

Line 12142: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda

12138: , mmtt.item_lot_control_code
12139: , mmtt.item_serial_control_code
12140: , mmtt.serial_allocated_flag
12141: , Decode(Nvl(mmtt.lot_number, mtlt.LOT_NUMBER), NULL, 'N', 'Y') lot_allocated_flag -- Added for 14699845 (Flexible lot allocation)
12142: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
12143: , MTL_TRANSACTION_LOTS_TEMP mtlt -- Added for 14699845 (Flexible lot allocation)
12144: WHERE mmtt.move_order_line_id = mol.line_id
12145: -- AND mol.header_id = p_move_order_header_id -- no need since wct only have the records in concerns
12146: AND mol.line_id = wdd.move_ordeR_line_id

Line 12312: wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda

12308: , mmtt.item_serial_control_code
12309: , mmtt.serial_allocated_flag
12310: , Decode(Nvl(mmtt.lot_number, mtlt.LOT_NUMBER), NULL, 'N', 'Y') lot_allocated_flag -- Added for 14699845 (Flexible lot allocation)
12311: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,
12312: wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
12313: , MTL_TRANSACTION_LOTS_TEMP mtlt -- Added for 14699845 (Flexible lot allocation)
12314: WHERE mmtt.move_order_line_id = mol.line_id
12315: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id (+) -- Added for 14699845 (Flexible lot allocation)
12316: AND ( mmtt.serial_allocated_flag = 'N' -- do not bulk serial allocated lines

Line 12796: FROM mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda

12792: -- Added for 14699845 (Flexible lot allocation)
12793: AND ((l_lot_allocated_flag = 'Y' AND EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt WHERE mtlt.transaction_temp_id=wct.transaction_temp_id))
12794: OR (l_lot_allocated_flag = 'N' AND NOT EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt WHERE mtlt.transaction_temp_id=wct.transaction_temp_id)))
12795: AND EXISTS(SELECT 1
12796: FROM mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
12797: WHERE mol.line_id = wct.move_order_line_id
12798: AND mol.line_id = wdd.move_ordeR_line_id
12799: AND wdd.delivery_detail_id = wda.delivery_detail_id
12800: AND NVL(wda.delivery_id,mol.carton_grouping_id) = l_carton_grouping_id)

Line 13106: wsh_delivery_assignments_v wda

13102: -- A new cursor will be defined to find all the child tasks ordered by delivery
13103: Cursor c_child_tasks(p_parent_line_id NUMBER) is
13104: Select mmtt.transaction_temp_id,mmtt.transaction_quantity,mmtt.secondary_transaction_quantity,mmtt.primary_quantity
13105: From wms_cartonization_temp mmtt,mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,
13106: wsh_delivery_assignments_v wda
13107: WHERE mmtt.parent_line_id = p_parent_line_id
13108: And mol.line_id = mmtt.move_order_line_id
13109: and mol.line_id = wdd.move_order_line_id
13110: and wdd.delivery_detail_id = wda.delivery_detail_id