[Home] [Help]
60:
61: SELECT *
62: INTO l_locator_rec
63: FROM
64: mtl_item_locations
65: WHERE inventory_location_id = x_locator_id;
66:
67: IF l_locator_rec.project_id = p_project_id
68: AND l_locator_rec.task_id = p_task_id THEN
77: BEGIN
78: SELECT inventory_location_id
79: INTO l_locator_id
80: FROM
81: mtl_item_locations
82: WHERE physical_location_id = x_locator_id
83: AND project_id = p_project_id
84: AND task_id = p_task_id
85: AND ROWNUM < 2;
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
254: mmtt.move_order_line_id = wdd.move_order_line_id AND
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
277: mmtt.move_order_line_id = wdd.move_order_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_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
299: wdd.released_status = 'Y' AND
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
321: wdd.delivery_detail_id = wda.delivery_detail_id AND
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
347: wdd.delivery_detail_id = wda.delivery_detail_id AND
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
377: WHERE
378: mol.line_id = wdd.move_order_line_id AND
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
404: mol.carton_grouping_id = v_carton_grouping_id AND
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
433: mol.carton_grouping_id = v_carton_grouping_id AND
461: SELECT mil.inventory_location_id locator_id,
462: mil.subinventory_code subinventory_code,
463: mil.dropping_order,
464: mil.picking_order
465: FROM mtl_item_locations mil,
466: mtl_secondary_inventories msi,
467: mtl_material_transactions_temp mmtt
468: WHERE mmtt.transaction_temp_id = p_task_id
469: AND mil.subinventory_code = mmtt.transfer_subinventory
498: SELECT mil.inventory_location_id locator_id,
499: mil.subinventory_code subinventory_code,
500: mil.dropping_order,
501: mil.picking_order
502: FROM mtl_item_locations mil,
503: mtl_secondary_inventories msi,
504: mtl_material_transactions_temp mmtt,
505: mtl_material_transactions_temp pmmtt
506: WHERE mmtt.transaction_temp_id = p_task_id
852: BEGIN
853: IF (p_call_mode <> 3) THEN
854: SELECT 1
855: INTO l_cons_loc_exists_flag
856: FROM mtl_item_locations mil,
857: mtl_secondary_inventories msi,
858: mtl_material_transactions_temp mmtt
859: WHERE mmtt.transaction_temp_id = p_task_id
860: AND mil.subinventory_code = mmtt.transfer_subinventory
867: ;
868: ELSE
869: SELECT 1
870: INTO l_cons_loc_exists_flag
871: FROM mtl_item_locations mil,
872: mtl_secondary_inventories msi,
873: mtl_material_transactions_temp mmtt,
874: mtl_material_transactions_temp pmmtt
875: WHERE mmtt.transaction_temp_id = p_task_id
951: l_validate_loc_subinventory,
952: l_validate_loc_empty_flag,
953: l_loc_disable_date,
954: l_sub_disable_date
955: FROM mtl_item_locations mil,
956: mtl_secondary_inventories msi
957: WHERE mil.inventory_location_id = p_locator_id
958: AND msi.secondary_inventory_name = mil.subinventory_code
959: AND msi.organization_id = mil.organization_id
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
1195: mmtt.content_lpn_id = wdd2.lpn_id AND
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
1221: mmtt.move_order_line_id = wdd.move_order_line_id AND
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
1265: wdd.locator_id = mil.inventory_location_id AND
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
1292: mol.line_id = wdd.move_order_line_id AND
1293: wdd.released_status = 'Y' AND
1693: l_pick_release_locator_id,
1694: l_pick_release_locator_type
1695: FROM
1696: mtl_material_transactions_temp mmtt,
1697: mtl_item_locations mil
1698: WHERE mmtt.transaction_temp_id = p_task_id
1699: AND mil.inventory_location_id = mmtt.transfer_to_location
1700: AND mil.organization_id = mmtt.organization_id
1701: ;
1710: l_pick_release_locator_type
1711: FROM
1712: mtl_material_transactions_temp mmtt,
1713: mtl_material_transactions_temp pmmtt,
1714: mtl_item_locations mil
1715: WHERE mmtt.transaction_temp_id = p_task_id
1716: AND mmtt.parent_line_id = pmmtt.transaction_temp_id
1717: AND mil.inventory_location_id = pmmtt.locator_id
1718: AND mil.organization_id = pmmtt.organization_id
1803: l_validate_loc_subinventory,
1804: l_validate_loc_empty_flag,
1805: l_loc_disable_date,
1806: l_sub_disable_date
1807: FROM mtl_item_locations mil,
1808: mtl_secondary_inventories msi
1809: WHERE mil.inventory_location_id = p_locator_id
1810: AND msi.secondary_inventory_name = mil.subinventory_code
1811: AND msi.organization_id = mil.organization_id