[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
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_assignments_v wda,
295: mtl_item_locations mil,
296: mtl_secondary_inventories msi,
297: wms_dispatched_tasks_history wdth
298: WHERE wda.delivery_detail_id = wdd.delivery_detail_id AND
312: Nvl(mil.inventory_location_type, 3) del_locator_type,
313: Sysdate creation_date
314: FROM mtl_material_transactions_temp mmtt,
315: wsh_delivery_details wdd,
316: wsh_delivery_assignments_v wda,
317: mtl_item_locations mil,
318: mtl_secondary_inventories msi
319: WHERE mmtt.operation_plan_id = v_operation_plan_id AND
320: mmtt.move_order_line_id = wdd.move_order_line_id AND
338: Sysdate creation_date
339: FROM mtl_material_transactions_temp mmtt,
340: mtl_material_transactions_temp pmmtt,
341: wsh_delivery_details wdd,
342: wsh_delivery_assignments_v wda,
343: mtl_item_locations mil,
344: mtl_secondary_inventories msi
345: WHERE mmtt.operation_plan_id = v_operation_plan_id AND
346: mmtt.move_order_line_id = wdd.move_order_line_id AND
368: wdd.locator_id mol_locator_id,
369: nvl(mil.inventory_location_type, 3) mol_locator_type,
370: wdth.creation_date
371: FROM wsh_delivery_details wdd,
372: wsh_delivery_assignments_v wda,
373: mtl_txn_request_lines mol,
374: mtl_item_locations mil,
375: mtl_secondary_inventories msi,
376: wms_dispatched_tasks_history wdth
395: Sysdate creation_date
396: FROM mtl_material_transactions_temp mmtt,
397: mtl_txn_request_lines mol,
398: wsh_delivery_details wdd,
399: wsh_delivery_assignments_v wda,
400: mtl_item_locations mil,
401: mtl_secondary_inventories msi
402: WHERE mmtt.operation_plan_id = v_operation_plan_id AND
403: mmtt.move_order_line_id = mol.line_id AND
424: FROM mtl_material_transactions_temp mmtt,
425: mtl_material_transactions_temp pmmtt,
426: mtl_txn_request_lines mol,
427: wsh_delivery_details wdd,
428: wsh_delivery_assignments_v wda,
429: mtl_item_locations mil,
430: mtl_secondary_inventories msi
431: WHERE mmtt.operation_plan_id = v_operation_plan_id AND
432: mmtt.move_order_line_id = mol.line_id AND
1186: mtl_material_transactions_temp mmtt,
1187: mtl_txn_request_lines mol,
1188: wsh_delivery_details wdd1,
1189: wsh_delivery_details wdd2,
1190: wsh_delivery_assignments_v wda,
1191: mtl_item_locations mil
1192: WHERE
1193: mmtt.transaction_temp_id = p_task_id AND
1194: wdd1.move_order_line_id = mol.line_id AND
1212: mtl_material_transactions_temp mmtt,
1213: mtl_material_transactions_temp pmmtt,
1214: mtl_txn_request_lines mol,
1215: wsh_delivery_details wdd,
1216: wsh_delivery_assignments_v wda,
1217: mtl_item_locations mil
1218: WHERE
1219: mmtt.transaction_temp_id = p_task_id AND
1220: mmtt.move_order_line_id = mol.line_id AND
1240: mol.organization_id
1241: FROM
1242: mtl_txn_request_lines mol,
1243: wsh_delivery_details wdd,
1244: wsh_delivery_assignments_v wda
1245: WHERE
1246: mol.line_id = p_mol_id AND
1247: wdd.move_order_line_id = mol.line_id AND
1248: wdd.released_status = 'S' AND
1256: SELECT wdd.subinventory del_subinventory,
1257: wdd.locator_id del_locator_id,
1258: nvl(mil.inventory_location_type, 3) del_locator_type
1259: FROM wsh_delivery_details wdd,
1260: wsh_delivery_assignments_v wda,
1261: mtl_item_locations mil,
1262: mtl_secondary_inventories msi
1263: WHERE wda.delivery_detail_id = wdd.delivery_detail_id AND
1264: wdd.released_status = 'Y' AND
1283: SELECT wdd.subinventory mol_subinventory,
1284: wdd.locator_id mol_locator_id,
1285: nvl(mil.inventory_location_type, 3) mol_locator_type
1286: FROM wsh_delivery_details wdd,
1287: wsh_delivery_assignments_v wda,
1288: mtl_txn_request_lines mol,
1289: mtl_item_locations mil,
1290: mtl_secondary_inventories msi
1291: WHERE
1924: l_organization_id,
1925: l_delivery_id
1926: FROM mtl_material_transactions_temp mmtt,
1927: wsh_delivery_details wdd,
1928: wsh_delivery_assignments_v wda
1929: WHERE mmtt.transaction_temp_id = p_task_id
1930: AND wdd.move_order_line_id = mmtt.move_order_line_id
1931: AND wdd.released_status = 'S'
1932: AND wdd.delivery_detail_id = wda.delivery_detail_id;