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 7406: wsh_delivery_assignments_v wda --added

7402: , mtl_txn_request_headers moh
7403: , -- mtl_system_items msi -- bug 2648133
7404: wsh_delivery_details_ob_grp_v wdd
7405: , -- added
7406: wsh_delivery_assignments_v wda --added
7407: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
7408: AND wdtv.organization_id = p_sign_on_org_id
7409: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
7410: AND mol.header_id = moh.header_id

Line 7727: wsh_delivery_assignments_v wda --added

7723: , mtl_txn_request_headers moh
7724: , -- mtl_system_items msi -- bug 2648133
7725: wsh_delivery_details_ob_grp_v wdd
7726: , -- added
7727: wsh_delivery_assignments_v wda --added
7728: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
7729: AND wdtv.organization_id = p_sign_on_org_id
7730: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
7731: AND mol.header_id = moh.header_id

Line 8016: wsh_delivery_assignments_v wda --added

8012: , mtl_txn_request_headers moh
8013: , -- mtl_system_items msi -- bug 2648133
8014: wsh_delivery_details_ob_grp_v wdd
8015: , -- added
8016: wsh_delivery_assignments_v wda --added
8017: WHERE wdt.transaction_temp_id = qt.task_id
8018: AND wdt.status in ( 2,3) -- Queued and dispatched tasks only bug 4310093
8019: AND wdt.person_id = p_sign_on_emp_id
8020: AND wdt.organization_id = p_sign_on_org_id

Line 8123: wsh_delivery_assignments_v wda --added

8119: , mtl_txn_request_headers moh
8120: , -- mtl_system_items msi -- bug 2648133
8121: wsh_delivery_details_ob_grp_v wdd
8122: , -- added
8123: wsh_delivery_assignments_v wda --added
8124: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
8125: AND wdtv.organization_id = p_sign_on_org_id
8126: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
8127: AND mol.header_id = moh.header_id

Line 8488: wsh_delivery_assignments_v wda --added

8484: , mtl_txn_request_headers moh
8485: , -- mtl_system_items msi -- bug 2648133
8486: wsh_delivery_details_ob_grp_v wdd
8487: , -- added
8488: wsh_delivery_assignments_v wda --added
8489: WHERE wdt.transaction_temp_id = qt.task_id
8490: AND wdt.status in ( 2,3) -- Queued and dispatched tasks only bug 4310093
8491: AND wdt.person_id = p_sign_on_emp_id
8492: AND wdt.organization_id = p_sign_on_org_id

Line 8595: wsh_delivery_assignments_v wda --added

8591: , mtl_txn_request_headers moh
8592: , -- mtl_system_items msi -- bug 2648133
8593: wsh_delivery_details_ob_grp_v wdd
8594: , -- added
8595: wsh_delivery_assignments_v wda --added
8596: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
8597: AND wdtv.organization_id = p_sign_on_org_id
8598: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
8599: AND mol.header_id = moh.header_id

Line 8952: wsh_delivery_assignments_v wda --added

8948: , mtl_txn_request_headers moh
8949: , -- mtl_system_items msi -- bug 2648133
8950: wsh_delivery_details_ob_grp_v wdd
8951: , -- added
8952: wsh_delivery_assignments_v wda --added
8953: WHERE wdt.transaction_temp_id = qt.task_id
8954: AND wdt.status in( 2,3) -- Queued and dispatched tasks only bug 4310093
8955: AND wdt.person_id = p_sign_on_emp_id
8956: AND wdt.organization_id = p_sign_on_org_id

Line 9057: wsh_delivery_assignments_v wda --added

9053: , mtl_txn_request_headers moh
9054: , -- mtl_system_items msi -- bug 2648133
9055: wsh_delivery_details_ob_grp_v wdd
9056: , -- added
9057: wsh_delivery_assignments_v wda --added
9058: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
9059: AND wdtv.organization_id = p_sign_on_org_id
9060: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
9061: AND mol.header_id = moh.header_id

Line 9416: wsh_delivery_assignments_v wda --added

9412: , mtl_txn_request_headers moh
9413: , -- mtl_system_items msi -- bug 2648133
9414: wsh_delivery_details_ob_grp_v wdd
9415: , -- added
9416: wsh_delivery_assignments_v wda --added
9417: WHERE wdt.transaction_temp_id = qt.task_id
9418: AND wdt.status in ( 2,3) -- Queued and dispatched tasks only bug 4310093
9419: AND wdt.person_id = p_sign_on_emp_id
9420: AND wdt.organization_id = p_sign_on_org_id

Line 9521: wsh_delivery_assignments_v wda --added

9517: , mtl_txn_request_headers moh
9518: , -- mtl_system_items msi -- bug 2648133
9519: wsh_delivery_details_ob_grp_v wdd
9520: , -- added
9521: wsh_delivery_assignments_v wda --added
9522: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
9523: AND wdtv.organization_id = p_sign_on_org_id
9524: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks
9525: AND mol.header_id = moh.header_id

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

11703: , mmtt.item_primary_uom_code
11704: , mmtt.item_lot_control_code
11705: , mmtt.item_serial_control_code
11706: , mmtt.serial_allocated_flag
11707: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
11708: WHERE mmtt.move_order_line_id = mol.line_id
11709: -- AND mol.header_id = p_move_order_header_id -- no need since wct only have the records in concerns
11710: AND mol.line_id = wdd.move_ordeR_line_id
11711: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 11859: wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda

11855: , mmtt.item_lot_control_code
11856: , mmtt.item_serial_control_code
11857: , mmtt.serial_allocated_flag
11858: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,
11859: wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
11860: WHERE mmtt.move_order_line_id = mol.line_id
11861: AND ( mmtt.serial_allocated_flag = 'N' -- do not bulk serial allocated lines
11862: or mmtt.serial_allocated_flag is null)
11863: AND mol.line_id = wdd.move_ordeR_line_id

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

12293: AND NVL(transaction_action_id, -1) = NVL(l_transaction_action_id, NVL(transaction_action_id, -1))
12294: AND NVL(transaction_source_type_id, -1) = NVL(l_transaction_source_type_id, NVL(transaction_source_type_id, -1))
12295: AND NVL(cost_group_id, -1) = NVL(l_cost_group_id, NVL(cost_group_id, -1))
12296: AND EXISTS(SELECT 1
12297: FROM mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
12298: WHERE mol.line_id = wct.move_order_line_id
12299: AND mol.line_id = wdd.move_ordeR_line_id
12300: AND wdd.delivery_detail_id = wda.delivery_detail_id
12301: AND NVL(wda.delivery_id,mol.carton_grouping_id) = l_carton_grouping_id);

Line 12581: wsh_delivery_assignments_v wda

12577: -- A new cursor will be defined to find all the child tasks ordered by delivery
12578: Cursor c_child_tasks(p_parent_line_id NUMBER) is
12579: Select mmtt.transaction_temp_id,mmtt.transaction_quantity
12580: From wms_cartonization_temp mmtt,mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,
12581: wsh_delivery_assignments_v wda
12582: WHERE mmtt.parent_line_id = p_parent_line_id
12583: And mol.line_id = mmtt.move_order_line_id
12584: and mol.line_id = wdd.move_order_line_id
12585: and wdd.delivery_detail_id = wda.delivery_detail_id