[Home] [Help]
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
253: mmtt.move_order_line_id = mol.line_id AND
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
276: mmtt.move_order_line_id = mol.line_id AND
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
299: WHERE wda.delivery_detail_id = wdd.delivery_detail_id AND
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
324: mmtt.move_order_line_id = wdd.move_order_line_id AND
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
350: mmtt.move_order_line_id = wdd.move_order_line_id AND
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,
380: wms_dispatched_tasks_history wdth
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
407: mmtt.move_order_line_id = mol.line_id AND
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
436: mmtt.move_order_line_id = mol.line_id AND
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
1278: wdd1.move_order_line_id = mol.line_id AND
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
1302: AND mmtt.move_order_line_id = mol.line_id
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
1330: mmtt.move_order_line_id = mol.line_id AND
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
1358: wdd.released_status = 'S' AND
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
1374: wdd.released_status = 'Y' AND
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
1401: WHERE
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'
2042: AND wdd.delivery_detail_id = wda.delivery_detail_id;