[Home] [Help]
2035: FROM dual
2036: WHERE EXISTS (
2037: SELECT mtrl.line_id
2038: FROM mtl_txn_request_lines mtrl
2039: ,mtl_txn_request_headers mtrh
2040: WHERE 1 = 1
2041: AND mtrl.header_id = mtrh.header_id
2042: AND mtrh.move_order_type = 6
2043: AND mtrl.lpn_id = l_lpn_id_tab(i)
2504: SELECT wln.outermost_lpn_id
2505: FROM wms_dispatched_tasks wdt
2506: ,mtl_txn_request_lines mtrl
2507: ,mtl_material_transactions_temp mmtt
2508: ,mtl_txn_request_headers mtrh
2509: ,wms_license_plate_numbers wln
2510: WHERE p_drop_type = G_DT_DROP_ALL
2511: AND mtrh.header_id = mtrl.header_id
2512: AND mtrh.move_order_type = 6
2762: ,mtl_txn_request_lines mtrl
2763: ,wms_dispatched_tasks wdt
2764: --,mtl_item_locations milk
2765: ,mtl_system_items_kfv msik
2766: ,mtl_txn_request_headers mtrh
2767: ,wms_license_plate_numbers wln
2768: --,mtl_secondary_inventories msi
2769: WHERE wdt.organization_id = p_org_id
2770: -- kajain
5117: SELECT mmtt.transaction_temp_id
5118: FROM wms_dispatched_tasks wdt
5119: ,mtl_txn_request_lines mtrl
5120: ,mtl_material_transactions_temp mmtt
5121: ,mtl_txn_request_headers mtrh
5122: WHERE mtrh.header_id = mtrl.header_id
5123: AND mtrh.move_order_type = 6
5124: AND mtrl.line_status = 7
5125: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
5150: SELECT mmtt.transaction_temp_id
5151: FROM wms_dispatched_tasks wdt
5152: ,mtl_txn_request_lines mtrl
5153: ,mtl_material_transactions_temp mmtt
5154: ,mtl_txn_request_headers mtrh
5155: WHERE mtrh.header_id = mtrl.header_id
5156: AND mtrh.move_order_type = 6
5157: AND mtrl.line_status = 7
5158: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
9398: , mtrl.inspection_status
9399: , msi.primary_uom_code
9400: FROM mtl_material_transactions_temp mmtt
9401: , mtl_txn_request_lines mtrl
9402: , mtl_txn_request_headers mtrh
9403: , mtl_system_items_kfv msi
9404: , ( /*5723418*/
9405: SELECT wlpn.lpn_id
9406: FROM wms_license_plate_numbers wlpn