[Home] [Help]
7400: mtl_secondary_inventories sub
7401: , mtl_txn_request_lines mol
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
7721: mtl_secondary_inventories sub
7722: , mtl_txn_request_lines mol
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
8010: mtl_secondary_inventories sub
8011: , mtl_txn_request_lines mol
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
8117: mtl_secondary_inventories sub
8118: , mtl_txn_request_lines mol
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
8482: mtl_secondary_inventories sub
8483: , mtl_txn_request_lines mol
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
8589: mtl_secondary_inventories sub
8590: , mtl_txn_request_lines mol
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
8946: mtl_secondary_inventories sub
8947: , mtl_txn_request_lines mol
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
9051: mtl_secondary_inventories sub
9052: , mtl_txn_request_lines mol
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
9410: mtl_secondary_inventories sub
9411: , mtl_txn_request_lines mol
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
9515: mtl_secondary_inventories sub
9516: , mtl_txn_request_lines mol
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
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
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
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);
12576:
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