[Home] [Help]
244: mil.task_id
245: FROM
246: mtl_material_transactions_temp mmtt,
247: mtl_txn_request_lines mol,
248: wsh_delivery_details wdd,
249: wsh_delivery_assignments_v wda,
250: mtl_item_locations mil
251: WHERE
252: mmtt.transaction_temp_id = p_task_id AND
267: FROM
268: mtl_material_transactions_temp mmtt,
269: mtl_material_transactions_temp pmmtt,
270: mtl_txn_request_lines mol,
271: wsh_delivery_details wdd,
272: wsh_delivery_assignments_v wda,
273: mtl_item_locations mil
274: WHERE
275: mmtt.transaction_temp_id = p_task_id AND
289: SELECT wdd.subinventory del_subinventory,
290: wdd.locator_id del_locator_id,
291: nvl(mil.inventory_location_type, 3) del_locator_type,
292: wdth.creation_date
293: FROM wsh_delivery_details wdd,
294: wsh_delivery_details wdd2,
295: wsh_delivery_assignments_v wda,
296: mtl_item_locations mil,
297: mtl_secondary_inventories msi,
290: wdd.locator_id del_locator_id,
291: nvl(mil.inventory_location_type, 3) del_locator_type,
292: wdth.creation_date
293: FROM wsh_delivery_details wdd,
294: wsh_delivery_details wdd2,
295: wsh_delivery_assignments_v wda,
296: mtl_item_locations mil,
297: mtl_secondary_inventories msi,
298: wms_dispatched_tasks_history wdth
315: mmtt.transfer_to_location del_locator_id,
316: Nvl(mil.inventory_location_type, 3) del_locator_type,
317: Sysdate creation_date
318: FROM mtl_material_transactions_temp mmtt,
319: wsh_delivery_details wdd,
320: wsh_delivery_assignments_v wda,
321: mtl_item_locations mil,
322: mtl_secondary_inventories msi
323: WHERE mmtt.operation_plan_id = v_operation_plan_id AND
341: Nvl(mil.inventory_location_type, 3) del_locator_type,
342: Sysdate creation_date
343: FROM mtl_material_transactions_temp mmtt,
344: mtl_material_transactions_temp pmmtt,
345: wsh_delivery_details wdd,
346: wsh_delivery_assignments_v wda,
347: mtl_item_locations mil,
348: mtl_secondary_inventories msi
349: WHERE mmtt.operation_plan_id = v_operation_plan_id AND
371: SELECT wdd.subinventory mol_subinventory,
372: wdd.locator_id mol_locator_id,
373: nvl(mil.inventory_location_type, 3) mol_locator_type,
374: wdth.creation_date
375: FROM wsh_delivery_details wdd,
376: wsh_delivery_assignments_v wda,
377: mtl_txn_request_lines mol,
378: mtl_item_locations mil,
379: mtl_secondary_inventories msi,
398: Nvl(mil.inventory_location_type, 3) mol_locator_type,
399: Sysdate creation_date
400: FROM mtl_material_transactions_temp mmtt,
401: mtl_txn_request_lines mol,
402: wsh_delivery_details wdd,
403: wsh_delivery_assignments_v wda,
404: mtl_item_locations mil,
405: mtl_secondary_inventories msi
406: WHERE mmtt.operation_plan_id = v_operation_plan_id AND
427: Sysdate creation_date
428: FROM mtl_material_transactions_temp mmtt,
429: mtl_material_transactions_temp pmmtt,
430: mtl_txn_request_lines mol,
431: wsh_delivery_details wdd,
432: wsh_delivery_assignments_v wda,
433: mtl_item_locations mil,
434: mtl_secondary_inventories msi
435: WHERE mmtt.operation_plan_id = v_operation_plan_id AND
467: mil.dropping_order,
468: mil.picking_order
469: FROM mtl_item_locations mil,
470: mtl_secondary_inventories msi,
471: mtl_material_transactions_temp mmtt,wsh_delivery_details wdd1
472: WHERE mmtt.transaction_temp_id = p_task_id
473: AND mil.subinventory_code = mmtt.transfer_subinventory
474: AND mil.organization_id = mmtt.organization_id
475: AND nvl(mil.inventory_location_type, 3)= G_LOC_TYPE_CONSOLIDATION -- consolidation locator
483: (mil.inventory_location_id=mil.physical_location_id or mil.physical_location_id is NULL))) --bug 8657987
484: -- bug 4017457
485: AND NOT exists (SELECT 1
486: FROM mtl_material_transactions_temp mmtt2,
487: wsh_delivery_details wdd
488: WHERE mmtt2.move_order_line_id = wdd.move_order_line_id AND
489: wdd.released_status = 'S' AND
490: mmtt2.transfer_organization = mil.organization_id AND
491: mmtt2.transfer_subinventory = mil.subinventory_code AND
492: mmtt2.transfer_to_location = mil.inventory_location_id)
493: AND NOT exists (SELECT 1
494: FROM mtl_material_transactions_temp mmtt3,
495: mtl_material_transactions_temp pmmtt2,
496: wsh_delivery_details wdd
497: WHERE mmtt3.move_order_line_id = wdd.move_order_line_id AND
498: wdd.released_status = 'S' AND
499: pmmtt2.transaction_temp_id = mmtt3.parent_line_id AND
500: pmmtt2.organization_id = mil.organization_id AND
522: AND pmmtt.transaction_temp_id = mmtt.parent_line_id
523: -- bug 4017457
524: AND NOT exists (SELECT 1
525: FROM mtl_material_transactions_temp mmtt2,
526: wsh_delivery_details wdd
527: WHERE mmtt2.move_order_line_id = wdd.move_order_line_id AND
528: wdd.released_status = 'S' AND
529: mmtt2.transfer_organization = mil.organization_id AND
530: mmtt2.transfer_subinventory = mil.subinventory_code AND
531: mmtt2.transfer_to_location = mil.inventory_location_id)
532: AND NOT exists (SELECT 1
533: FROM mtl_material_transactions_temp mmtt3,
534: mtl_material_transactions_temp pmmtt2,
535: wsh_delivery_details wdd
536: WHERE mmtt3.move_order_line_id = wdd.move_order_line_id AND
537: wdd.released_status = 'S' AND
538: pmmtt2.transaction_temp_id = mmtt3.parent_line_id AND
539: pmmtt2.organization_id = mil.organization_id AND
1268: mil.organization_id
1269: FROM
1270: mtl_material_transactions_temp mmtt,
1271: mtl_txn_request_lines mol,
1272: wsh_delivery_details wdd1,
1273: wsh_delivery_details wdd2,
1274: wsh_delivery_assignments_v wda,
1275: mtl_item_locations mil
1276: WHERE
1269: FROM
1270: mtl_material_transactions_temp mmtt,
1271: mtl_txn_request_lines mol,
1272: wsh_delivery_details wdd1,
1273: wsh_delivery_details wdd2,
1274: wsh_delivery_assignments_v wda,
1275: mtl_item_locations mil
1276: WHERE
1277: mmtt.transaction_temp_id = p_task_id AND
1293: mil.organization_id
1294: FROM
1295: mtl_material_transactions_temp mmtt,
1296: mtl_txn_request_lines mol,
1297: wsh_delivery_details wdd,
1298: wsh_delivery_assignments_v wda,
1299: mtl_item_locations mil,
1300: mtl_parameters mpara
1301: WHERE mmtt.transaction_temp_id = p_task_id
1321: FROM
1322: mtl_material_transactions_temp mmtt,
1323: mtl_material_transactions_temp pmmtt,
1324: mtl_txn_request_lines mol,
1325: wsh_delivery_details wdd,
1326: wsh_delivery_assignments_v wda,
1327: mtl_item_locations mil
1328: WHERE
1329: mmtt.transaction_temp_id = p_task_id AND
1349: mol.task_id,
1350: mol.organization_id
1351: FROM
1352: mtl_txn_request_lines mol,
1353: wsh_delivery_details wdd,
1354: wsh_delivery_assignments_v wda
1355: WHERE
1356: mol.line_id = p_mol_id AND
1357: wdd.move_order_line_id = mol.line_id AND
1365: IS
1366: SELECT wdd.subinventory del_subinventory,
1367: wdd.locator_id del_locator_id,
1368: nvl(mil.inventory_location_type, 3) del_locator_type
1369: FROM wsh_delivery_details wdd,
1370: wsh_delivery_assignments_v wda,
1371: mtl_item_locations mil,
1372: mtl_secondary_inventories msi
1373: WHERE wda.delivery_detail_id = wdd.delivery_detail_id AND
1392: IS
1393: SELECT wdd.subinventory mol_subinventory,
1394: wdd.locator_id mol_locator_id,
1395: nvl(mil.inventory_location_type, 3) mol_locator_type
1396: FROM wsh_delivery_details wdd,
1397: wsh_delivery_assignments_v wda,
1398: mtl_txn_request_lines mol,
1399: mtl_item_locations mil,
1400: mtl_secondary_inventories msi
2033: l_to_loc_id,
2034: l_organization_id,
2035: l_delivery_id
2036: FROM mtl_material_transactions_temp mmtt,
2037: wsh_delivery_details wdd,
2038: wsh_delivery_assignments_v wda
2039: WHERE mmtt.transaction_temp_id = p_task_id
2040: AND wdd.move_order_line_id = mmtt.move_order_line_id
2041: AND wdd.released_status = 'S'