[Home] [Help]
114: WHERE organization_id = l_locator_rec.organization_id;
115:
116: SELECT *
117: INTO l_subinventory_code
118: FROM mtl_secondary_inventories
119: WHERE secondary_inventory_name = l_locator_rec.subinventory_code
120: AND organization_id = l_locator_rec.organization_id;
121:
122:
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
300: wdd.released_status = 'Y' AND
301: wdd.locator_id = mil.inventory_location_id AND
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
325: wdd.delivery_detail_id = wda.delivery_detail_id AND
326: wdd.released_status = 'S' AND
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
351: wdd.delivery_detail_id = wda.delivery_detail_id AND
352: wdd.released_status = 'S' AND
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
381: WHERE
382: mol.line_id = wdd.move_order_line_id AND
383: wdd.released_status = 'Y' AND
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
408: mol.carton_grouping_id = v_carton_grouping_id AND
409: mmtt.move_order_line_id = wdd.move_order_line_id AND
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
437: mol.carton_grouping_id = v_carton_grouping_id AND
438: mmtt.move_order_line_id = wdd.move_order_line_id AND
466: mil.subinventory_code subinventory_code,
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
506: mil.subinventory_code subinventory_code,
507: mil.dropping_order,
508: mil.picking_order
509: FROM mtl_item_locations mil,
510: mtl_secondary_inventories msi,
511: mtl_material_transactions_temp mmtt,
512: mtl_material_transactions_temp pmmtt
513: WHERE mmtt.transaction_temp_id = p_task_id
514: AND mil.subinventory_code = pmmtt.subinventory_code
935: IF (p_call_mode <> 3) THEN
936: SELECT 1
937: INTO l_cons_loc_exists_flag
938: FROM mtl_item_locations mil,
939: mtl_secondary_inventories msi,
940: mtl_material_transactions_temp mmtt
941: WHERE mmtt.transaction_temp_id = p_task_id
942: AND mil.subinventory_code = mmtt.transfer_subinventory
943: AND mil.organization_id = mmtt.organization_id
950: ELSE
951: SELECT 1
952: INTO l_cons_loc_exists_flag
953: FROM mtl_item_locations mil,
954: mtl_secondary_inventories msi,
955: mtl_material_transactions_temp mmtt,
956: mtl_material_transactions_temp pmmtt
957: WHERE mmtt.transaction_temp_id = p_task_id
958: AND pmmtt.transaction_temp_id = mmtt.parent_line_id
1035: l_validate_loc_empty_flag,
1036: l_loc_disable_date,
1037: l_sub_disable_date
1038: FROM mtl_item_locations mil,
1039: mtl_secondary_inventories msi
1040: WHERE mil.inventory_location_id = p_locator_id
1041: AND msi.secondary_inventory_name = mil.subinventory_code
1042: AND msi.organization_id = mil.organization_id
1043: ;
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
1375: wdd.locator_id = mil.inventory_location_id AND
1376: (nvl(mil.inventory_location_type, g_loc_type_storage_loc) = G_LOC_TYPE_STAGING_LANE
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
1402: mol.line_id = wdd.move_order_line_id AND
1403: wdd.released_status = 'Y' AND
1404: wdd.locator_id = mil.inventory_location_id AND
1914: l_validate_loc_empty_flag,
1915: l_loc_disable_date,
1916: l_sub_disable_date
1917: FROM mtl_item_locations mil,
1918: mtl_secondary_inventories msi
1919: WHERE mil.inventory_location_id = p_locator_id
1920: AND msi.secondary_inventory_name = mil.subinventory_code
1921: AND msi.organization_id = mil.organization_id
1922: ;